Forum Replies Created
Viewing 15 posts - 541 through 555 (of 4,080 total)
-
RE: output identity values
I agree with Sean that the easiest solution for you is to add the additional column to store the old ID.
The OUTPUT clause can only access columns from the table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
The 😉 was intended to denote sarcasm, guys.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Grant Fritchey (6/5/2014)
Sean Lange (6/5/2014)
I am just going to leave this here...http://www.sqlusa.com/bestpractices/%5B/url%5D
Don't worry there is soap for your eyes. Then if you read some of the content you may want...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Grant Fritchey (6/5/2014)
Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem, where was I),...__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Koen Verbeeck (6/3/2014)
jasona.work (6/3/2014)
You know, I'd not really thought about this until now, but...How do people find all these "undocumented" options for various SQL commands?
dbcc autopilot???
create index... WITH STATISTICS_ONLY =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
GilaMonster (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??Replacing EXISTS with (something) because Some Person said it's slow.
As Stevie Wonder once...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Can I use Output Into for this idea?
The composable DML looks interesting. I'm curious to look at it's execution plan and see how it performs with large batches.
An alternative I've seen involved a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: STintersect with buff
Eirikur Eiriksson (5/29/2014)
I have found that one should generally (as much as I dislike generalization) avoid AUTO_GRID.😎
Would you care to elaborate why?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Convert multiple rows to one row separated by delimiter
create table #TestData (Col1 varchar(20))
insert into #TestData
select 'aaa' union all
select 'bbb' union all
select 'ccc'
select stuff((select ','+Col1
from #TestData
order by col1
for xml path(''))
,1,1,'') as delimitedlist
Edited:
Whups, you were too...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Have a great summer, Steve.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Open the pod bay door, Hal....
http://www.visual-memory.co.uk/amk/doc/zg.html
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Calculating interest between two dates - which is the best data type?
Looks like it's been cleaned up already.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Calculating interest between two dates - which is the best data type?
Wow. Talk about a blast from the past..... 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Cumulative sum of previous rows
+1 Good topic, good article, and good discussion. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Avoiding Cursors
I agree this is best as a series of small articles.
Some of my favorite techniques:
1) Use a tally table and SUBSTRING() to represent character string as a table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 541 through 555 (of 4,080 total)