Viewing 15 posts - 53,176 through 53,190 (of 59,068 total)
Heh... thanks for the feedback, Donald. I'm right there with ya on the 10 tries. 😀
Like Colin was kind enough to point out, if folks think they can...
January 2, 2008 at 7:48 am
As long as database owner is a sysadmin all objects created by database owner will automatically be owned by dbo.
Now, there's a decent tip... 🙂
January 2, 2008 at 7:20 am
It just checks that your values are in the format of nnnn-nnnnn and the first 4 are a viable year. Please see "Like comparisons, Pattern Matching in Search Conditions"...
January 2, 2008 at 7:15 am
First, recurrsion is nothing more than RBAR on steriods, only it's a bit more difficult to troubleshoot if something goes wrong. 😛
Second, this is an SQL Server 2000 forum...
January 2, 2008 at 6:59 am
No, no... no need to convert to a proc... when your code detects that something is wrong, just do a SELECT 1/0 and, trust me, an error will be raised...
January 2, 2008 at 6:47 am
You bet... easiest thing to see what I'm talking about is to simply run the code and compare to what's in the #yourtable to the results...
January 2, 2008 at 6:41 am
Well, kind'a... haven't taken the time to CTE this puppy, yet... if you do, would you mind sharing it, please? Thanks...
The "key" is that at least one of the...
January 2, 2008 at 6:18 am
Thanks for the feedback, Martin. Yeah, I have a grand love for such 3rd party shenanigan's myself... my favorite is loading data from a table into a Temp Table,...
January 2, 2008 at 4:48 am
From what you've posted, I'd say just change the delimiter.
January 2, 2008 at 4:13 am
Heh... considering that the OP said...
My friend faced the above questions in his recent interview.
... I'd have to agree 😉
January 2, 2008 at 3:30 am
My bad... didn't say it correctly...
We don't allow individuals to create their own databases... just the DBA's. They're logged in with SA privs so no problems there.
We also require...
January 2, 2008 at 3:24 am
Viewing 15 posts - 53,176 through 53,190 (of 59,068 total)