Viewing 15 posts - 31 through 45 (of 56 total)
All rows must always be treated as being in a random order.
Until sorted by "order by".
Rgds,
Dave.
November 16, 2011 at 6:41 am
I usually set up any new sql server instances so that it runs a job at 7am every day which runs some sql to check all jobs and steps that...
November 16, 2011 at 2:49 am
I set it to once an hour.
I always set mine to 50 minutes..... then 10 minute breaks every hour...even just to stretch legs and get some blood circulation going.......
November 10, 2011 at 12:54 pm
Thanks for the reply.
Your post shows the source code. I was looking for the syntax documentation - as what is usually found in BOL for system functions.
October 5, 2011 at 2:41 am
I park my bike in the staff car park, in the motorcycle bay... It's quite small, enough space for around 6 bikes, and on average there's only 4 bikes...
September 1, 2011 at 2:29 pm
That's strange. I wonder why you are getting different results to me. My example 1 and 2 results are using sql server 2000, and they give the same...
August 2, 2011 at 6:08 am
Example 1 gives me:
Value Seq
1011
1012
1021
1022
1023
1024
1031
1041
1042
1043
Example 2 gives me:
Value Seq
1011
1011
1021
1021
1021
1022
1031
1041
1041
1041
August 1, 2011 at 9:08 am
:exclamationmark:
>>>Strangely when I run this code and do a select on the table I get 8 rows.
Yep, the code I ran was just a simple copy and paste from...
July 21, 2011 at 8:30 am
Strangely when I run this code and do a select on the table I get 8 rows.
(SQL Server 2000)
July 20, 2011 at 10:19 am
Not sure if it's relevant now, but in case... here's my code for an example where a list of Top Bills of Materials is used and a product structure table,...
June 21, 2011 at 3:22 pm
Here's my code for the finished example where a list of Top Bills of Materials is used and a product structure table, to create a BOM explosion:
------------------------------------------------------------------------
-- BOM explosion example,...
June 21, 2011 at 7:47 am
Since you don't have a productID for the live runs, which groupings do you want them totalised into??
April 12, 2011 at 9:43 am
Yep, they always show as failure on my maint plans. On old sql (2000) any plans that have a txn log backup, and that contain db's with simple recovery,...
April 12, 2011 at 9:38 am
I take it you didn't actually read what I sent you, then.
--Jeff Moden
--------------------------------------------------------------------------------
Yep of course I read it 🙂
But I haven't had a chance to convert my code to...
April 11, 2011 at 3:38 pm
Viewing 15 posts - 31 through 45 (of 56 total)