Viewing 15 posts - 3,391 through 3,405 (of 7,636 total)
Jeff Moden (3/14/2009)
RBarryYoung (3/14/2009)
I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.
It might... but Nah... "we don need no...
March 14, 2009 at 11:07 pm
Lynn Pettis (3/14/2009)
Finally got to it by cutting and pasting the url while writing the above post.
That's odd. It works fine for me.
Could your chill come from the mention...
March 14, 2009 at 11:05 pm
I would suggest passing the database connection string and table name in through an environment configuration variable.
March 14, 2009 at 10:55 pm
Rob Fisk (3/13/2009)[hr...Tally table example would be great. PM me since we have already crowded this topic somewhat...
Please do not derail threads by PM'ing stuff like this. Crowded threads...
March 14, 2009 at 10:51 pm
I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.
March 14, 2009 at 10:42 pm
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
March 14, 2009 at 9:24 pm
foxjazz (3/14/2009)
Because using English is dominant, I struggle with German as a second. I can...
March 14, 2009 at 8:56 pm
foxjazz (3/14/2009)
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.
No, you...
March 14, 2009 at 7:42 pm
OK, foxjazz, now I have a question for you:
foxjazz (3/14/2009)
March 14, 2009 at 7:34 pm
foxjazz (3/14/2009)
Lets say you have a "product table with a descriptionID that links to a description table.
In another database, there is a product and description table.
This product table...
March 14, 2009 at 7:23 pm
I am still waiting for you to actually ask a question. These incoherent ramblings do not constitute a question. You don't even bother to indicate which previous post...
March 14, 2009 at 4:43 pm
Jeff Moden (3/14/2009)
foxjazz (3/13/2009)
select name from mynametable where changedate > @yesterdayfetch from @sel into @name
while (@@fetch_status = 0)
begin
insert into nameother (name,changeddate) values (@name,getdate())
end
Do this without a cursor!
Heh... rant complete... regard...
March 14, 2009 at 12:57 pm
foxjazz (3/14/2009)
I have a table catagory fields are description, catID, typeID. parentID
another tables queryed with (make, model, yr, engine).
in the category table makes are typeid...
March 14, 2009 at 11:27 am
Amit Lohia (3/13/2009)
RBarryYoung (5/10/2008)
I call this "Presidential Campaign, 2008":[font="Courier New"]WAITFOR PRIMARYSELECT
RIGHT IDENTITYPRECISION IS ALL[/font]I think this is the best so far.
Thanks, Amit!
March 13, 2009 at 8:30 pm
foxjazz (3/13/2009)
Why can't t-sql accomadate that flavor of language just like the IDL...
March 13, 2009 at 4:02 pm
Viewing 15 posts - 3,391 through 3,405 (of 7,636 total)