Here's a dynamic version for SQL 2000 version

drop table #scratchpad7

drop table #scratchpad3

create table #scratchpad7 ( [EMPLOYEENUMBER] smallint,

TotalRegHours decimal(10,2),

TotalOt...

That's because of the Max(EndDate) that we are using in the pivot. You need to use an aggregate for the pivot function, so I used that field. Are...

Depends on if you're male or female 🙂

Glad I could help

I had to play around with the Item names to label the Start and End Dates. I haven't had a chance to fully test it, but here's a start...

Edited - forgot it was a sql 2000 forum

Can you provide a sample of what your expecting for a result set?

You can use IsNull on each field

IsNull((SELECT CT_County_Name FROM LookUps.dbo.CT_County_Table where CT_County = A.HA_COUNTY),'') + ', '

+ IsNUll((SELECT TOP 1 ROUTE_NAME FROM LookUps.dbo.LKUP_County_Route WHERE LK_CODE = A.HA_ROUTE ),'')...

Are you looking to populate the StartDate on the nextrow with the EndDate from the previous row? You can use a CTE, but be careful as these can be...

Just a followup. When the job ran, it set the next time to run for 125 minutes from the last time it ran, so it seems to be working...

Hopefully the table and the Archive able are partitioned and have the same layouts, constraints, PKs, filegroupings etc. If this is the case, then you could swap out...

It's actually a dynamic pivot that I found somewhere on this site and use quite often. To sort the columns, I guess it depends on how you want them...

I tried it and I get the error "Value of 125 is not valid for value. V alue should be between Minimum and Maximum Parameter name" When I look...

In your original post you wrote that you were calling CheckSQLVersion with 4 parameters, then you listed 5 in the last post. Is Parm4 in this file the password...

check the compatability mode of the database on the server you are getting the issue on. It might be set to 2005 or lower.

No offense, but it's kinda dumb to use an apostophe as a delimiter for the exact reasons your specifying. It's seems like more work to go in and put...