Viewing 15 posts - 5,521 through 5,535 (of 9,722 total)
If the domains don't trust each other, I don't think any amount of SQL perms verification will help. Check with your domain admin to make sure that A) the domains...
July 25, 2011 at 10:40 am
You have to turn the whole statement into a dynamic SQL statement. You can't just assign variables to the various bits of it. Do you know how to do dynamic...
July 25, 2011 at 10:38 am
Have you compared execution plans between the regular SELECT and the SELECT...INTO queries?
July 25, 2011 at 10:34 am
mtillman-921105 (7/25/2011)
July 25, 2011 at 10:32 am
halifaxdal (7/25/2011)
Brandie Tarvin (7/25/2011)
halifaxdal (7/25/2011)
SSMS is not reliable and it's very buggy
What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we...
July 25, 2011 at 10:30 am
halifaxdal (7/25/2011)
SSMS is not reliable and it's very buggy
What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we might be able...
July 25, 2011 at 9:31 am
Revenant (7/25/2011)
Brandie Tarvin (7/25/2011)
crookj (7/25/2011)
Ray K (7/25/2011)
Daniel Bowlin (7/25/2011)
ruthlesspeople
Despicable
Me
Really?
Movie title. "Despicable Me."
July 25, 2011 at 8:56 am
zapouk (7/22/2011)
July 25, 2011 at 8:51 am
I love chapter 2, The First Programmer was a Lady.
July 25, 2011 at 8:44 am
crookj (7/25/2011)
Ray K (7/25/2011)
Daniel Bowlin (7/25/2011)
ruthlesspeople
Despicable
Me
July 25, 2011 at 8:32 am
Let me see if I understand your situation correctly.
You want to update A, B & C when none of these columns equal the A, B, and C columns from another...
July 22, 2011 at 10:42 am
Kath,
Thank you for adding your insight. I think only one of the previous respondents works with HL7, so your perspective is very welcome indeed.
July 22, 2011 at 8:23 am
Ah, okay. I thought your post before last was a "I still need help" kind of post. That's why I asked if you were going to do that in your...
July 21, 2011 at 11:18 am
Is that really what you are going to be doing with your code?
July 21, 2011 at 10:58 am
Viewing 15 posts - 5,521 through 5,535 (of 9,722 total)