Laughable SQL would be a great topic. Probably quite popular, and potentially quite valuable.

Could have examples of some of the really bad cursor solutions as one part, nested recursive...

Try this. It does the "last 52 weeks" thing, and I fixed the problem with the date range you mentioned.

-- "Params"

declare @SDate datetime, @EDate datetime;

select @SDate = '3/1/09', @EDate...

Are you trying to manipulate the files directly? If so, then SQL Server is using them, as far as Windows is concerned, and they will always be "in use"...

Chirag (4/23/2009)

---

Jeff Moden (4/22/2009)

---

I've been very disappointed with every outsourcing venture we've had, so far. Examples include such things as code that has UDF's that call 4 levels of...

Sorry, wasn't aiming that comment at you, Wayne. Was meant for the OP.

No real differences in maintenance that I know of. Not on the day-to-day stuff, anyway.

One thing I might suggest is, if you're looking at upgrading from 32 to 64,...

Steve:

This one's actually a pretty much duplicate post. He and Flo have been discussing the same thing, with the same problems in his posts, on another thread.

I might interview the guy, but it would be mostly for entertainment value, and would depend on whether I had the free time for that kind of thing or not.

At...

My first recommendation is always, get a copy of SQL Server Dev Edition for yourself, and start building and testing things with it. If you aren't spending at least...

I just checked Amazon, and there does appear to be a difference on there. Where do you usually buy software for your company? Can't you just contact them...

Please don't double-post in multiple forums.

Grant Fritchey (4/23/2009)

---

I'm sorry, I don't have my abstracts in a readily digestible format anywhere. Something else to do next time.

However, if you register as a speaker you can look...

If you have a Numbers/Tally table, I think this will do what you need:

declare @SDate datetime, @EDate datetime;

select @SDate = '4/1/09', @EDate = '4/19/09'

select Number as Week, dateadd(week, number-1, @SDate)...

How are you doing the output? If it's through SSIS, I believe you can set the delimiter dynamically through a variable.

Grab a log parser, look inside that log file. You can get a free trial for the ApexSQL one. I think RedGate has one that works for SQL...