Search Result

Collapse
7 results in 0.0024 seconds.
Keywords
Members
Tags
sql server 2008
  •  
  • Palyadav
    started a topic How Can I Do Stored Procedure ?
    in SQL Server

    How Can I Do Stored Procedure ?

    Code:
    ;with cte as (
    select
        empid,
        cast(datepart(hh, logtime) as varchar(2)) + ':' +
        right('0' + cast(datepart(mi, logtime) as varchar(2)), 2) as logtime,
        row_number() over (partition by empid order by logid) as row
    from #timing
)
select c1.empid as EmployeeID, min(c1.logtime) as InTime, max(c2.logtime) as OutTime, min(isnull(p.punches, '')) as Punches
    ...
    See more | Go to post
    • Charlie Price
      started a topic Information-Schema and Sys user accounts
      in SQL Server

      Information-Schema and Sys user accounts

      I migrated a database from Microsoft Sql server 2005 to a MS Sql server 2008 box. On the old server the under security/users the information_sch ema and sys accounts were active. When I try to enable them using:

      Grant Connect To Information_Sch ema the command completes but I get a message stating I cnanot enable this account.

      What do I need to do grant these accounts Connect?

      this is causing some software...
      See more | Go to post
      • QueenKirsty
        started a topic unable to run stored procedure using data from linked server via VBA
        in SQL Server

        unable to run stored procedure using data from linked server via VBA

        Setup:
        1. I have a SQL Server 2008 db (called VantageTrans) with a linked server (a Progress db called VANTAGE - the back end of our financial system).
        2. I have a stored procedure (spUpdateTblFor File) on VantageTrans (the SQL Server db) that pulls data out of the tables in VANTAGE (the linked server) and dumps the manipulated data into tables in VantageTrans.

        Issue:
        The stored procedure runs fine on when run...
        See more | Go to post
        • bkernan
          started a topic Upsizing Access 2007 .accdb with Attachments to SQL Server 2008
          in Access

          Upsizing Access 2007 .accdb with Attachments to SQL Server 2008

          I upsized my Asset Template .accdb to SQL Server 2008. Every field except the Attachments works as expected.

          I tried changing the datatype of the Attachments field in the SQL Server table, no types would get the Attachments field to work.

          We don't have the time to spend coding VBA to handle attachments ourselves (possibly with storing the path to the file in the db and making our own upload form).

          Is...
          See more | Go to post
          • ShaluGoogle
            started a topic Login failed while synchronizing via merge replication
            in SQL Server

            Login failed while synchronizing via merge replication

            I'm getting the following error when I'm doing merge replication. Plz, tell me how can I overcome this problem. I cannot able to start the agent... Plz, someone help me

            Login failed for user 'myserver\login name'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

            Error :18456,Severity :14,State:11 in the error log...

            Atleast any troubleshoot...
            See more | Go to post
            • simple simon
              started a topic Inserting into multiple related tables using table valued parameters.
              in SQL Server

              Inserting into multiple related tables using table valued parameters.

              How would I insert into multiple related tables using a table valued parameter? Is there any way to do this without using a WHILE loop?

              I know how to insert from a table valued parameter into one table:
              INSERT INTO dbo.Table
              SELECT * FROM @TVP

              But what do I do when I want to insert all of someone's information into multiple tables, and have those records related to each other by foreign keys? For example, I...
              See more | Go to post
              • ulas
                started a topic Storing a series of numbers of variable length
                in SQL Server

                Storing a series of numbers of variable length

                Hi,

                I am designing a table in SQL Server 2008 which will contain, in each row, a list of numbers of variable length. The maximum (10) and minimum (2) list lengths are known. The most obvious approach seems to be just creating 10 columns (num1, num2....,num10) and making num3...num10 nullable. Is there a better way of doing this? It just seems wasteful to have so many columns that will be empty most of the time for most of the rows...
                See more | Go to post
                Previous template Next
                Working...