Viewing 15 posts - 9,361 through 9,375 (of 9,720 total)
Matt,
I absolutely LOVE your .sig! @=)
As far as your answer goes... Hmm. I was afraid you were going to say that. Oh, well. In this particular...
October 26, 2007 at 4:12 am
If you want to do this, I suggest using a combination of Substring() and PatIndex(). Use the PatIndex() to find the spaces in your names and then the Substring()...
October 25, 2007 at 4:53 pm
At some point earlier in the year, someone did suggest you could call Microsoft and ask them if you could upgrade straight from SQL 7 to 2k5. But other...
October 25, 2007 at 8:31 am
It occurs to me that what I really need to do, to keep the table dynamic, is to make an image out of the result set of the Proc and...
October 24, 2007 at 9:04 am
That's a wonderful resource, but unfortunately, it doesn't help me in this particular situation for several reasons.
1) I've already written my dynamic pivot script as T-SQL and it works great.
2)...
October 24, 2007 at 6:49 am
I had a query where I was pulling directly from the linked server (multiple tables in JOINs) with a SELECT statement on the destination server. After reading Steve's article,...
October 22, 2007 at 7:00 am
Actually, those are the sorts of "Lessons Learned" you could pick up from your first IT job too. It doesn't have to be college. @=)
October 19, 2007 at 11:04 am
My first college experience was a Bachelor of Arts in Dramatic Arts, followed by a near-Bachelor Degree in History (just 1 term paper / class short when I moved out...
October 19, 2007 at 8:53 am
Unfortunately, only one of my servers is 2005 (the destination). The other server (the source) is 2000 and we can't upgrade yet because of an app that currently doesn't...
October 19, 2007 at 8:15 am
I agree that if you're using databases on the same server that a view definitely seems to be the way to go, but...
Even if you use a view to query...
October 19, 2007 at 7:50 am
Gregg,
You might want to re-read the article. Step 1. It actually does say "If the user is not a member of the local Administrators group, add the user...
October 10, 2007 at 8:26 am
IMHO, If datatypes are used correctly, no one should ever have to SUM() on a bit datatype. After all, it's supposed to be indicative of a true/false status, right?
For...
October 8, 2007 at 4:26 am
We've actually already started the re-write and we've gotten complete buy in from upper management on the issue. Especially when we told them what we were going to be...
October 5, 2007 at 1:28 pm
Perhaps, but the biggest "term" we have is 7 years. Plus, we already have plans to get off the current system in the next five years anyway.
And...
October 5, 2007 at 12:59 pm
Ha! I think I found it. Looks like a SUM( ) was probably the issue. And SQL Server didn't implictly convert it up to a smallint or...
October 5, 2007 at 12:40 pm
Viewing 15 posts - 9,361 through 9,375 (of 9,720 total)