Viewing 15 posts - 5,491 through 5,505 (of 9,722 total)
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
Sorry, but Chris's solution is probably the best solution you will get without posting the code that's causing you this heartache. We need to see the problem in order to...
July 27, 2011 at 4:36 am
Have you tried running sp_helptext on the function?
EDIT: Nevermind. Apparently it doesn't work on this function.
July 27, 2011 at 4:30 am
A little funny for the day.
I was having problems with the internet yesterday (and SSC). Then, later, my SO was responding on another forum to someone else who was having...
July 26, 2011 at 11:49 am
There's a very specific set of articles on SQL Server and LUN setups somewhere that I cannot find or remember the titles of that could help you out. I'm going...
July 26, 2011 at 7:52 am
Do you have a 2k8 server in the domain that VS2k5 is in? Have you tested the connection that way?
I'm wondering if there's a problem with VS2k5 seeing SQL Server...
July 26, 2011 at 7:50 am
In an effort to not scare you off of full-text, I've called in reinforcements to offer alternatives. I have, unfortunately, reached the limit of my knowledge in this subject.
July 26, 2011 at 7:40 am
Can someone with Full Text knowledge help out here: http://www.sqlservercentral.com/Forums/Topic1147434-1292-1.aspx#bm1147915
I think I scared the OP into thinking Full Text was Evil and useless, which is not what I was trying...
July 26, 2011 at 7:38 am
Glad I could help.
Remember, keep "pretty" on the user side. Don't worry about it for the backend stuff.
July 26, 2011 at 7:34 am
justintime (7/25/2011)
yep gotcha on the string length parts. does the value that i set for the variable matter?
We're just using the variable as an example. you don't...
July 26, 2011 at 7:33 am
Where the 5 and 4 are in my code, these are the string lengths. If you want a variable strength length, then you just replace the numbers with LEN(Myfield)-1 and...
July 25, 2011 at 12:36 pm
Viewing 15 posts - 5,491 through 5,505 (of 9,722 total)