Viewing 15 posts - 50,866 through 50,880 (of 59,078 total)
Do you have a database with a name like %customer%???
April 30, 2008 at 8:01 am
hb21l6 (4/30/2008)
I only needed a SQL line to run from an ASP page, I didn't want to do this through an SP as there is more going on...
April 30, 2008 at 7:49 am
It's not possible to help without knowing either the content of the various variables or you printing out the value of the variable you're trying to execute.
April 30, 2008 at 7:03 am
Sorry, Rajesh... didn't see the last line of your post... same idea.
April 29, 2008 at 11:57 pm
I wish all books came on a DVD... easy to search, easy to carry. Of course, a couple/three 1,400 page books make a pretty good anti-terrorist weapon on a...
April 29, 2008 at 11:56 pm
PhilPacha (4/25/2008)
If there are no foreign keys on the table, simply TRUNCATE TABLE [YourTableName]
Hey guys! Didn't you see PhilPacha's post? That's the way to do it... truncating a...
April 29, 2008 at 11:52 pm
Ummm, then why did you post that you wanted to process rows one at a time? We've all said that's a bad thing... what is it that you're trying...
April 29, 2008 at 11:46 pm
The other thing to be considered, it what the new rows are in the RecipeLine table are... you'll need to pass those ID's back to the GUI, won't you?
April 29, 2008 at 11:40 pm
Oh, crud... I just thought of this... If you're using it for that, it's possible that two people could conflict with each other and get the wrong rows...
We've gotta come...
April 29, 2008 at 11:35 pm
shalini_pdi (4/29/2008)
from one location to other location to reduce the time of dataentry
Perfect... that's what I was looking for. Thank you so much.
April 29, 2008 at 11:33 pm
Heh... Yeaup... I know that... what I want to know is why you need to clone rows like this...
April 29, 2008 at 11:20 pm
Rob Goddard (4/29/2008)
shalini_pdi (4/29/2008)
Hi,Could any explain how to fetch row by row with out using cursor.
Like everyone has said, you need to give at least demo table structures and...
April 29, 2008 at 11:16 pm
Oh... not what I was looking for... I wanted to know why you needed to do this, please...
April 29, 2008 at 11:14 pm
Say... do you happen to have the full test slab for that 16 second version?
April 29, 2008 at 11:13 pm
Matt Miller (4/29/2008)
(1000000 row(s) affected)
=====================
Jeff's Statistical Median Calc
=====================
(70266 row(s) affected)
SQL Server Execution Times:
CPU time = 70031 ms, elapsed time = 42039 ms.
========================
Matt's Mathematical Median...
April 29, 2008 at 11:11 pm
Viewing 15 posts - 50,866 through 50,880 (of 59,078 total)