Viewing 15 posts - 901 through 915 (of 4,080 total)
Here is the query to give you the results you want.
I assume you can write the stored procedure to pass in a parameter to a WHERE clause.
;with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 26, 2011 at 10:49 pm
Is there an upper limit to how many descriptions might have to be concatenated?
If so, how many? 10? 20? 100? 1000?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 24, 2011 at 8:27 pm
Glad it's working for you. I just hope you don't have too many rows in these user tables, because that is NOT going to scale well.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 10:58 pm
You're welcome. I'm sure you'll find enough to get you started, but don't hesitate to come back if you have specific questions.
By the way, PIVOT is an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 5:07 pm
Sorry to take so long. My daughter called from NZ and she gets priority 🙂
Anyway, I think this will give you the results you want. Use...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 4:50 pm
Coming right up.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 2:46 pm
But the IDs should remain the same, only the sort value will change on each row. Right?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 2:39 pm
I think I understand the problem now. He wants the [Sort] columns for all rows with a number equal to or greater to the "moved" row to be...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 2:37 pm
What troubles me is the idea that you are trying to store rows in a specific order in a table. This isn't a spreadsheet or a flat file,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 2:27 pm
The output you want is commonly referred to as a PIVOT or cross-tab ("crosstab"). If you'll search this site using those terms, you'll find plenty of examples....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 23, 2011 at 2:14 pm
:crazy:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 18, 2011 at 12:30 pm
We need some use cases. Please post up what your current source table(s) look like and the query as it has been developed so far. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 15, 2011 at 1:42 pm
It helps to remember that CASE is an expression, not a statement.
CASE is basically like a function with "if logic" built in, a more powerful version of ISNULL() or COALESCE().
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 15, 2011 at 1:36 pm
drew.allen (11/9/2011)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 9, 2011 at 11:59 am
You do it with two separate queries. One to update table "B" and then another to update table "C".
You are thinking procedurally, not set-based, whenever you say...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
November 9, 2011 at 11:06 am
Viewing 15 posts - 901 through 915 (of 4,080 total)