Good stuff. Will remember this when the shop I work for ever moves off SQL 2000!

Sounds great, thanks 🙂

Thanks for responding, and so quickly!

The 'dense_rank()' and 'over(partition by' bits in the stored procedure are not functions in SQL 2000, and I don't have use of Analysis Services either...

Gagne - I know this post is old but I came across it looking for a 4-4-5 fiscal calendar generator with exactly the criteria you have (Jan1-Dec31 fiscal year, periods...

With limitations this can be done directly in the SQL in the result set SELECT statement, and only if the target output of the process will always be Excel.

If you...

Someone mentioned going back 110 years to beat Marconi to the punch in inventing the radio... well I'd go back to the same timeframe to shoot Marconi to prevent him...

Sorry to hijack this thread but I'd like to extend the same line of questions if I may - Right now I have SQL Server 2000\Visual Studio 2003 for supporting...

Hi Sidney - I know this is an old post but I hope you might still be listening in as I am struggling with the merged dataset approach (not with...

Looks great! If only I had SQL2005....sadly I do not. Is there a backwards-compatible version of this for SQL2000?

Cheers

Jut did a quick test on my Excel to MS Project import suggestion and it worked satisfactorily to me anyway.

1) Created & saved an Excel file with three columns:

Task Name...

I haven't done this myself but the first thing that comes to mind is that if you have a handle on the job's key information like the name & start\end...

The older LEFT|RIGHT OUTER JOIN operator syntax no longer works such as '*=' or '=*', but the explicit LEFT|RIGHT OUTER JOIN syntax still does even with the compatibility level set...

Hi Lynn, if you...

I'm aware ofthe functional equivalences between RIGHT and LEFT joins, I just always thought '*=' was really RIGHT OUTER JOIN and '=*' was LEFT OUTER JOIN is all, opposite of...

Not to belabor an obscure and deprecated operation too much, but I'm surprised to learn in this post that the left or right side orientation of the '*' in the...