Viewing 15 posts - 1 through 15 (of 93 total)
Good stuff. Will remember this when the shop I work for ever moves off SQL 2000!
May 14, 2013 at 4:50 am
Sounds great, thanks 🙂
October 3, 2012 at 7:27 am
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...
October 2, 2012 at 6:05 pm
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...
October 2, 2012 at 5:48 pm
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.
September 29, 2011 at 8:45 am
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...
October 29, 2010 at 7:53 am
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...
October 27, 2010 at 9:11 am
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...
August 10, 2010 at 12:19 pm
Looks great! If only I had SQL2005....sadly I do not. Is there a backwards-compatible version of this for SQL2000?
March 16, 2010 at 8:40 am
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:
October 8, 2009 at 7:41 am
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...
October 8, 2009 at 7:07 am
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...
July 14, 2009 at 6:32 am
Lynn Pettis (2/18/2009)
Okay, I have checked and can see that some people have checked out my code. Anyone have any feedback regarding my small test suite?
Lynn Pettis (2/18/2009)
Hi Lynn, if you...
February 18, 2009 at 1:01 pm
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...
February 18, 2009 at 8:46 am
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...
February 18, 2009 at 8:06 am