Thanks that really helped. not how to get them to reference the reference dataset you mention but this makes sense.

Thank you

That makes it clearer, thanks for the explanation.

The Year holds 2015

and if I run this:

I get this (if it helps)

Select dateadd(year,[Year]-1900,0)

from ##Shift

Column1

2015-01-01

2015-01-01

2015-01-01

But I still do...

Hi,

I jsut got this to work:

I had to add -S and the server name

Thanks:-)

Just curious, this would be more efficient if it were possable to do the sub query in a inline view.

Does anyone know if that is possable in anyway?

I cannot get...

Thanks that makes sennce.

thnak you.

Hi,

And thanks for the alternate way of doing this, but when I compard the execution plans the cost was about the same; I was looking for a more efficent way....

Thank you

Thanks that what I foung too but want to be sure I was seeing this right.

Thanks

That really helped:-)

Thanks I relly appreciate it.

In regards to the first question, but if two peope were hiting the same record what would happen. I always thought that it was a first come first serve process;...