Viewing 15 posts - 76 through 90 (of 126 total)
So a row_number function would work... That sounds like a plan.
March 17, 2009 at 4:50 pm
Ok, I messed up.. The table I sent has and identity spec, I thought it didn't.
Some of the tables I have don't use ident.
So take out the identity spec when...
March 17, 2009 at 4:48 pm
I will take the 5th on this one Bob before I am accused again of being insulting.
March 17, 2009 at 4:42 pm
Sorry that doesn't work,
gencategoryid is the primary key on the table.
Although nice try.
Let me make the following correction to my t-sql...
--delete from category where categorytypeid = 1
declare @sel cursor
declare @make...
March 17, 2009 at 4:33 pm
The following is a script that I use to partally populate one of our tables.
And the table is provided.
based on the distinct results (from any table you would like to...
March 17, 2009 at 4:09 pm
Well for you folks that are still here.
What I am speaking about is language, not about application.
It seems many have failed to grasp that simple concept, and appear too conceded...
March 17, 2009 at 10:45 am
Well, I am a programmer and I have sa in both test and production.
I guess it just depends on the programmer.
Our db's aren't part of the sarbanes oxly fold.
For those,...
March 14, 2009 at 11:02 pm
I guess I just don't get why everyone here is so walled up and can't think outside the box.
Stored procedures in sql result only in one language type, not many.
the...
March 14, 2009 at 10:27 pm
Do any of you know a language other than English? Spanish, as a second or German?
Because using English is dominant, I struggle with German as a second. I can use...
March 14, 2009 at 7:48 pm
Instead of having you guys try and figure out some problem without the use of cursors, I have already made my point without realizing that I had.
Simply because cursors are...
March 14, 2009 at 6:47 pm
Lynn Pettis (3/14/2009)
You all that use t-sql and don't code probably never know any difference.
You...
March 14, 2009 at 6:39 pm
The question is a problem. Update the product table given above with the correct descriptionID with out cursors.
March 14, 2009 at 5:01 pm
Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, and link the first results to the other set, and so...
March 14, 2009 at 4:18 pm
Actually we are forced to use t-sql when doing such things as storedprocedures. Unless of course we write clr functions.
Not having the ability to use non-cursored rowbased loops is a...
March 14, 2009 at 11:17 am
Viewing 15 posts - 76 through 90 (of 126 total)