Viewing 15 posts - 166 through 180 (of 262 total)
I think you will be looking at doing something like this. You will need to adjust it to suit your needs, but hopefully the concept makes sense? You will need...
July 10, 2014 at 2:25 pm
It may also be possible to re-write your SP as a Function and use CROSS APPLY. Just thinking out loud.
July 10, 2014 at 2:04 pm
You can also insert explicit values into an IDENTITY column by using SET IDENTITY_INSERT
ON.
July 7, 2014 at 4:38 pm
Okay, not sure if this is of any interest or any use to anyone at this point, but here is basically what I ended up doing:
IF object_id('tempdb..#Existing') IS NOT NULL
DROP...
June 30, 2014 at 4:10 pm
I am a huge fan of CTE's as well. I guess different structures are inherently more intuitive to different people. Perhaps with enough experience that will change and I will...
June 19, 2014 at 8:06 am
What a fantastic explanation! Thank you so much for taking the time!
June 19, 2014 at 7:30 am
Ohhhhhh! Okay, thank you. The indentation makes a massive difference in getting my head around it.
Now that that part of it is solved, I guess I just need to...
June 18, 2014 at 6:33 pm
Sorry, guilty as charged. Was trying to limit the code to only the relevant bit. Is this better?
SELECT blablabla
FROM
T1
FULL OUTER JOIN T2
FULL OUTER JOIN T3
INNER JOIN...
June 18, 2014 at 6:04 pm
I should probably just delete this thread since I got it off on the wrong foot by omitting DDL. Sorry again.
I think I'm going to re-post it next week...
June 7, 2014 at 7:23 pm
Thanks for the reply! The problem is we still need the "other columns". Again, it's my bad for not getting the DDL together for this one first. I will try...
June 7, 2014 at 10:15 am
For what it's worth, I've noticed that in scripts where I first drop a table and then create it, I have to include the "GO" command after the initial DROP...
June 6, 2014 at 5:19 pm
I understand. I will try to come up with some good sample DDL. Thanks nonetheless for your efforts.
June 6, 2014 at 1:30 pm
What are Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8? I don't mean the data types, but what are they? Are any of these columns a unique or primary key...
June 6, 2014 at 11:57 am
Sorry Lynn, I wasn't sure DDL was necessary in this case.
Yes, we are importing data from an external source into Scratch, scrubbing it for dupes again Live, and then...
June 6, 2014 at 10:55 am
Viewing 15 posts - 166 through 180 (of 262 total)