Viewing 15 posts - 19,066 through 19,080 (of 22,202 total)
It's a pretty standard lookup table design:
LookupTable
LookupID Year Desc
1 1999 'Some important value'
2 ...
December 14, 2008 at 8:02 am
Jeff Moden (12/13/2008)
I'm old... for me it's "may the farts be with you". Gives new meaning to the phrase, "It Depends". :hehe:
Oh no!
Mr. Bill!
December 14, 2008 at 7:44 am
jcrawf02 (12/12/2008)
December 14, 2008 at 7:41 am
Thinking about it some more... how do you write a procedure...
Well, I assume that you know what you want to get, what data set you're looking for, first. Armed with...
December 12, 2008 at 4:45 am
If I understand the question, I guess it's something I do every day (all day sometimes). First, I need to have a set of working parameters. Preferably, I have some...
December 12, 2008 at 4:43 am
You have a single transaction where you are mixing INSERT/UPDATE and SELECT? Be very careful that you're performing these actions in the same order or you'll be getting deadlocks all...
December 12, 2008 at 4:31 am
Don't use transactions on the read statement. There's no need for them anyway.
December 12, 2008 at 4:28 am
The statement you have there is an extended property. It doesn't create functions. Instead it is used to document and describe objects already created within the database. You can lookup...
December 12, 2008 at 4:27 am
You can check the @@rowcount to verify how many, if any, records were deleted. Or you can use the OUTPUT clause to capture specifically which records were deleted.
December 12, 2008 at 4:22 am
As Jack explained to you, without some specifics, there's almost no way to address your issue.
Speaking in general terms, using a cursor to select records is almost always a mistake....
December 12, 2008 at 4:19 am
I'm actually not entirely sure what you're asking. Do you mean something like: Always join on the key, the whole key. Or are you looking for tricks with XML execution...
December 12, 2008 at 4:02 am
jeffrey_bryant (12/11/2008)
Unfortunately the Dev...
December 11, 2008 at 1:38 pm
Got me beat. I've only been driving for 31 years. I've got the scars from the one major accident on the bike.
December 11, 2008 at 1:00 pm
And even as you hit the limitations on a single table inside a single database on a single server, you can start to look at partitioning and parallel processing using...
December 11, 2008 at 12:52 pm
It depends.
Is there going to be a lookup value:
08 A
As well as the value:
07 A
If so, then the year should probably be part of the PK of the lookup table...
December 11, 2008 at 11:59 am
Viewing 15 posts - 19,066 through 19,080 (of 22,202 total)