Viewing 15 posts - 3,061 through 3,075 (of 4,080 total)
I wonder if you guys feel asleep with your faces resting on the keyboard....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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 =...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 15, 2009 at 4:25 pm
Oh good. People keep using that word and I get paranoid.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 15, 2009 at 4:16 pm
Are you talking about me Lynn? :ermm:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 14, 2009 at 2:27 pm
That's cruel.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 14, 2009 at 1:19 pm
This is a classic crosstab problem. You handle it by case expressions to test the value in the fields column to populate a column in the result...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 14, 2009 at 1:07 pm
Viewing 15 posts - 3,061 through 3,075 (of 4,080 total)