Viewing 15 posts - 5,461 through 5,475 (of 9,707 total)
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
Okay, I do have a question. Is this query for a report?
You can't have line item detail and a summary together that will display correctly in SSMS. You get to...
July 27, 2011 at 4:50 am
Ignoring Celko's comment about best SQL programming practices (which he and I will always disagree on to some extent), he's correct that we need more information in order to assist...
July 27, 2011 at 4:44 am
Hence my edited comment.
I'm trying to figure this one out. I know that sys.databases has collation, but I'm not sure where the server information is or even if that's where...
July 27, 2011 at 4:38 am
Viewing 15 posts - 5,461 through 5,475 (of 9,707 total)