Viewing 15 posts - 5,476 through 5,490 (of 9,722 total)
Then take Chris's code and adjust it. Expand the temp table's column list, making sure the Name column is the first one, then do the insert as he says. Make...
July 27, 2011 at 6:13 am
Eugene Elutin (7/27/2011)
....
If you are right,...
July 27, 2011 at 6:08 am
I'm almost scared to ask...
Why are you changing the registry setting for collation? And to a value that isn't even a proper collation value?
July 27, 2011 at 6:00 am
Glad we could help. Let us know what you find out.
July 27, 2011 at 5:50 am
Eugene Elutin (7/27/2011)
Brandie Tarvin (7/27/2011)
...You can't have line item detail and a summary together that will display correctly in SSMS. You get to pick: Detail or Summary. Not both.
...
You can...
July 27, 2011 at 5:46 am
Thanks for the link. It explains why I can't figure out what State is being used for. So far, it's not.
July 27, 2011 at 5:41 am
Does "name" in the first result come close to being the same datatype of any of the columns in the second result set?
July 27, 2011 at 5:38 am
Verify with your SAN administrator, but it does sound correct. Then again, I've never used Raid 10, so I wouldn't know for sure.
Or, if you are the admin, verify with...
July 27, 2011 at 5:34 am
Sean Lange (7/26/2011)
Nothing wrong with it as long you realize you are only going to the first 3 characters in your string.
In addition to this statement, if the datatype is...
July 27, 2011 at 5:25 am
So far as I know (and I could be wrong) Padding Off is Padding Off. You can't have padding in the query result and not between the lines. It's a...
July 27, 2011 at 5:23 am
Since your pseudocode isn't in a Create Procedure format, we can't tell anything from what you've posted. For one, we don't even know if you've declared your input variables correctly.
Could...
July 27, 2011 at 5:18 am
Can you include Create Table statements and Insert statements with sample data? It would help us come up with a solution that works for you without it being broken.
July 27, 2011 at 5:15 am
Your problem is "Server ip".
An IP address has 3 periods (aka decimal points) in it. That is the 3 periods used by a linked server. Hence, the rest of...
July 27, 2011 at 5:13 am
I missed this when I looked earlier. Table sys.servers has a column called collation_name. Mine is NULL because we use the default, which is based on the OS collation. (Note:...
July 27, 2011 at 5:10 am
I haven't used Except yet, and I seldom use Not Exists. But now, I'm going to try and see what I come up with.
You're probably crazy, but that doesn't...
July 27, 2011 at 4:53 am
Viewing 15 posts - 5,476 through 5,490 (of 9,722 total)