Search Result

Palyadav · Dec 14 '11, 04:56 AM

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

...

Charlie Price · Feb 25 '11, 05:14 PM

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...

QueenKirsty · Aug 31 '10, 04:48 PM

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...

bkernan · Apr 27 '10, 03:05 PM

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...

ShaluGoogle · Feb 17 '10, 09:29 AM

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...

simple simon · Jan 16 '10, 04:44 AM

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...

ulas · Nov 27 '08, 01:51 AM

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...

Search Result

How Can I Do Stored Procedure ?

Information-Schema and Sys user accounts

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

Upsizing Access 2007 .accdb with Attachments to SQL Server 2008

Login failed while synchronizing via merge replication

Inserting into multiple related tables using table valued parameters.

Storing a series of numbers of variable length