Viewing 15 posts - 346 through 360 (of 1,183 total)
KEEPNULLS will keep any NULL value as in what would be in column C here ... "A,B,,D"
But your data has a value, and that value is the word "NULL".
I do...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 11, 2011 at 9:30 am
A few notes/comments/questions:
1. Is this for a trigger, it appears so?
2. Where do the other variables get set? @ptFlagIndicator1Var, @ptFlagIndicator2Var, etc...
3. The "simple update" at the end IS relevant to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2011 at 10:41 am
Can you post your "other" actions. There may be a way to solve your problem without a cursor.
Try thinking "SET BASED" and apply the select/update to the result set of...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2011 at 8:30 am
Lookup PIVOT in BOL. It will get you part way.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2011 at 8:01 am
You can still use the pivot summing on an irrelevant column, and ignore it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2011 at 7:19 am
ARGH!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2011 at 6:36 am
You would be much better off moving this out of the trigger.
As in .....
Have your trigger insert the PK values for the updated records into another table along with a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 1, 2011 at 9:33 am
Jeff Moden (3/25/2011)
Have you tried INSERT/EXEC?
That's what I've ended up doing. Although to be dynamic is taking some more work.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 26, 2011 at 8:07 pm
Craig Farrell (3/24/2011)
CELKO (3/24/2011)
SELECT A.column_a, A.column_b
FROM TableA AS A
LEFT OUTER JOIN
Flagged_Records AS FR
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 24, 2011 at 7:56 pm
Modify my previous script to use a temp table instead of a table variable, and it will work.
I think I've found a Question of the day to submit. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 1:59 pm
OK, So this is not a complete answer. But it now has me asking WTF?
The code below SHOULD work, at least from what I can see it should. You'll see...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 1:45 pm
Brandie Tarvin (3/18/2011)
Daniel Bowlin (3/18/2011)
I'm not really paranoid, but people are out to get me. 😀Just because I'm paranoid doesn't mean people aren't out to get me.
EVERYONE thinks I'm...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 1:22 pm
Tara-1044200 (3/18/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 1:02 pm
change it to ..... ORDER BY gpm.GMPI)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 12:58 pm
What makes them unique?
Can you post sample data/DDL scripts?
It's much easier to assist if I have sample data.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMarch 18, 2011 at 12:57 pm
Viewing 15 posts - 346 through 360 (of 1,183 total)