Viewing 15 posts - 106 through 120 (of 479 total)
Bob Hovious (3/19/2009)
I will try to dig up the Documentation of the undocumented parameters and try to figure out the correct order even if it takes a life time...
You...
March 19, 2009 at 8:49 am
Roy Ernest (3/19/2009)
RBarryYoung (3/18/2009)
Bruce W Cassidy (3/18/2009)
As a suggestion, go buy a collection of soft, squishy balls. Not only can you play with them as stress relievers,...
March 19, 2009 at 7:24 am
Ben Leighton (3/19/2009)
if the SET READ_COMMITTED_SNAPSHOT is set to on for the database you are using then the query will return 1 and 2...
I'm being picky...
March 19, 2009 at 7:20 am
Thinking of quoting, I was looking at Bob's signature...
“Against stupidity the very gods themselves contend in vain.” - Friedrich von Schiller.
I had previously heard...
“Against boredom the gods themselves fight in...
March 19, 2009 at 7:07 am
Bob Hovious (3/18/2009)
Jeff, I warned Fox he would hear about triangular joins one day.Let us get the man weaned off cursors first !! 😉
The method...
March 19, 2009 at 6:01 am
I presume the code for this is separate from the Simple-Talk Prettifier, since the new formatter seems to be done in JavaScript (I was using Firefox yesterday and it kept...
March 19, 2009 at 5:38 am
Bob Hovious (3/18/2009)
March 19, 2009 at 4:28 am
Alvin Ramard (3/18/2009)
Lynn Pettis (3/18/2009)
Greg Snidow (3/18/2009)
Jack Corbett (3/18/2009)I have to ask though, have you read all 2700+ posts?
I'm up to around page 30, and I have found it particularly...
March 18, 2009 at 6:42 pm
Lynn Pettis (3/18/2009)
Steve Jones - Editor (3/18/2009)
I'm with Bruce, I'm amazed and in awe of what you did. And I'm glad no one held a grudge.
To be honest, would it...
March 18, 2009 at 6:25 pm
foxjazz (3/18/2009)
so would something like this work?
update tbl set seq = tbl.seq + (select count(*) from insertdata)...
March 18, 2009 at 6:11 pm
I suspect he may be an application developer who's had to start using data in SQL server. As mentioned, someone who uses Oracle (which I gather used to do a...
March 18, 2009 at 12:05 pm
foxjazz (3/18/2009)
let me give some datapartnumber, producttype, sequence
7401,belt,1
7432,belt,2
8401,hose,1
8422,hose,2
This is the table.
inert a record (8403,hose,?)
after a resequence you would have
8401,hose,1
8402,hose,2
8422,hose,3
If you must do this, then the following, based on Bob's code...
March 18, 2009 at 11:26 am
foxjazz (3/18/2009)
declare @i int
select top 10 @i = @i + 1 , partnumber from prd
I shouldn't get an error. But...
March 18, 2009 at 11:00 am
How easy would it be to revert the [ code ][ /code ] tags to work as before and add a new set of [ tsql ][ /tsql ] tags?
Hence...
March 18, 2009 at 9:35 am
Since the formatting is active for historical code, you also have interesting effects where the 'code' wasn't t-sql, for example
http://www.sqlservercentral.com/Forums/FindPost661664.aspx
Or where I inserted 'font' tags in the code to...
March 18, 2009 at 9:29 am
Viewing 15 posts - 106 through 120 (of 479 total)