Hi all, the missing part is 'through a SQL Server 7' database.

Thanks

Tryst

ok - sorted!

Thanks for the repies, guys!

Tryst

Yeah, that works sushila, but for some reason SERVERPROPERTY('productversion') and SERVERPROPERTY ('edition') doesn't return anything.

(I have SP 3 - is it a major requirement to jump to SP4?)

Thanks

Tryst

This is what I get. Nothing about what Service Pack I have installed is there...

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

Dec 17 2002 14:22:05

Copyright (c) 1988-2003...

Cool! Excellent replies people!

Some good insights there, Michael.

Thanks

Tryst

Hi all,

and thanks for the replies.

I guess it will be a design decision in a sense then, so i will give it some thought.

Tryst

Ok - I got it now.

Thanks people.

Tryst

Thanks for the reply guys!

I will look into the best approach when I get into work on Monday.

Tryst

ok - thanks for the insight on it.

Tryst

PW: is there any need for the following...

dt.MaxCreatedPerGroup = tbl1.DateCreated

...in your ON clause? As if the inner SELECT is grouping by GroupID, meaning it should only bring back one row...

Hi dba321,

its always good to post your solution if you have managed to solve the task yourself, as this will help other people who may have similar problem in the...

So will this return the week number for the week in that current year (i.e Week 9 for end of Feb) and not return the week number from the date...

Yes, convert the date to the format you want - look on BOL for teh various formats. You may have to use the LEFT function as well to trim the...

Ahh, so naming the passed in variables the same as the names in which the parameters are declared in the SP?

Thanks

Tryst

Yeah, I had that solution.

Out of curosity, why have you use 'myvar=@var1' instead of just passing in @var1?

Thanks

Tryst