Viewing 15 posts - 3,061 through 3,075 (of 4,081 total)
If I'm not mistaken, ASCII and Unicode are both ANSI standards, but I didn't want to add that level of complexity to the explanation.
EBCDIC !!!
April 16, 2009 at 6:49 am
I wonder if you guys feel asleep with your faces resting on the keyboard....
April 16, 2009 at 6:48 am
I hope this helps. There is a faster way to do this with a single UPDATE to @Results but there are some issues with that approach I am...
April 15, 2009 at 6:45 pm
Just share it with the entire thread and I'll read it.
Like Jeff, I'm now thinking that I will have to learn to code CLR in self...
April 15, 2009 at 6:23 pm
Bob, did you notice? We should hit 3500 posts soon!
I'm not going to get all excited again until we are approaching 5K 🙂
I've been trying...
April 15, 2009 at 5:10 pm
Is there a way to update a group of records such as all "cqs%" to become "CQS%"?
Keeping it simple....
UPDATE sometable
SET someColumn =...
April 15, 2009 at 4:25 pm
Oh good. People keep using that word and I get paranoid.
April 15, 2009 at 4:16 pm
Are you talking about me Lynn? :ermm:
April 15, 2009 at 4:04 pm
Tendenzwende (a shift in the Zeitgeist);
A change in the weather
Is known to be extreme.
But what's the use of changing
Horses, in midstream?
I can change, I swear....
- Bob Dylan
Also.... Lynn...
April 15, 2009 at 2:51 pm
Hey TW:
I'm glad to be of assistance. 🙂
Let's use your posted results as sample data. All you have to do is this. Anyone can cut and...
April 15, 2009 at 10:26 am
Give this a try. I obviously couldn't test it without you providing some test data, but I think it's what you're looking for. In the future,...
April 15, 2009 at 10:09 am
You can even think about using PIVOT table on Table2 to convert rows into columns.
VK, try an experiment for me. Set up a PIVOT on Table...
April 15, 2009 at 8:40 am
VK, I've seen this before in a couple of different contexts. In the absence of Sparse Columns, I've heard it proposed as a way to store "occasional" columns of...
April 15, 2009 at 8:35 am
Makes you wonder if he's asking the questions or being asked the questions. Also makes you wonder where the sudden improvement in his written expressions came from....
April 14, 2009 at 2:27 pm
Viewing 15 posts - 3,061 through 3,075 (of 4,081 total)