Forum Replies Created
Viewing 15 posts - 1,741 through 1,755 (of 4,080 total)
-
RE: Assign value to another fieldname using CASE statement
The main reason why I try to avoid SQL_VARIANT is the need to cast it again once you need to use that column in a join condition.
Fair enough, Lutz. ...
__________________________________________________
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: Stopping Duplicates with INSTEAD OF INSERT Problem
OKAY... once more from the top. In the example below, there are either one or two rows in the source table, but each have the same GUID...
__________________________________________________
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: Insert with Output clause keeping track of old and new values
MUCH clearer, to me at least. I'm glad you found a workable solution. 🙂
__________________________________________________
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: Stopping Duplicates with INSTEAD OF INSERT Problem
There is nothing wrong with the NOT EXISTS syntax that the LEFT JOIN is going to cure. That's just another technique for doing the same non-existence test....
__________________________________________________
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: Stopping Duplicates with INSTEAD OF INSERT Problem
Eric, in the absence of sample data, I'm going to hazard an opinion. You have a join at some point that is causing multiple rows with the same...
__________________________________________________
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: Insert with Output clause keeping track of old and new values
Yes you are doing something wrong. You are failing to punctuate. This makes your questions and comments all run together and is discouraging to people who are...
__________________________________________________
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: how to find records from a dataset with different conditions
Here it is. Like the pivot, it avoids the index seek required by the NOT EXISTS. The execution plans appear to be close, if...
__________________________________________________
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: Assign value to another fieldname using CASE statement
Did you not even look at my example casting an integer as SQL_VARIANT datatype?
__________________________________________________
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: how to find records from a dataset with different conditions
This one is more basic. It only shows the list of patients. However it produces a nice execution plan if we can assume that there...
__________________________________________________
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: T-SQL Oddities
Just to be cruel... go into query options (on someone else's machine) and change the batch separator from "GO" to "SELECT".
__________________________________________________
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: how to strip out all non alpha numeric characters?
Latin1_General_CI_AS is an example of a Windows collation.
SQL_Latin1_General_CP1_CI_AS is a SQL collation.
Latin1_General_BIN is a binary code point collation.
This is exactly what I needed to know. Thanks for bringing...
__________________________________________________
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 (3/23/2010)
Changing the subject (if there is one), any art critics here?The world is grey, the mountains old.
The forge's fire is ashen-cold.
No harp is rung, no hammer falls.
The darkness dwells...
__________________________________________________
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: help in avoiding loop
We still don't know what results you are expecting, so we are unlikely to be of any more assistance. At this point, I don't even know why you...
__________________________________________________
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: how to strip out all non alpha numeric characters?
Paul, I have to ask just when is Windows collation used?
I would assume that since all the work is being done inside SQL that some default SQL...
__________________________________________________
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?
RBarryYoung (3/23/2010)
The Dixie Flatline (3/23/2010)
Man, you're in fine form tonight Barry. The pain meds must be extra-fine. It almost makes me wish I'd kept my...__________________________________________________
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 - 1,741 through 1,755 (of 4,080 total)