Viewing 15 posts - 53,176 through 53,190 (of 59,064 total)
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
I happened to be doing a little research on different methods for finding "gaps" and ran across this article. Here's a much faster way to find gaps... and, it...
January 2, 2008 at 3:04 am
Now, I'm worried for you... the practice of "finding gaps" in a "sequence" column is usually accompanied by the insane idea that you'd ever reuse missing numbers. The INT...
January 2, 2008 at 2:03 am
Gail is 100% correct... if all you want to do is add a "sequence" number to the table, then just add an IDENTITY column as she described.
January 2, 2008 at 1:13 am
I always create them as "dbo" and grant privs... saves a lot of hassle...
January 1, 2008 at 8:39 pm
Viewing 15 posts - 53,176 through 53,190 (of 59,064 total)