Viewing 15 posts - 57,091 through 57,105 (of 59,066 total)
Actually... you've posted this nearly identical question 3 times on this forum and a couple of times on other forums. Folks have told you how to do this many ways......
December 23, 2006 at 7:45 am
Since the row is automatically deleted after 8 days, I'm thinking it's a combination of a computed column and trigger.... or the trigger just has an update/delete.
I'm thinking that deleting...
December 23, 2006 at 7:40 am
The date serial between Excel, VB, and SQL Server vary a bit (a day or two in some cases). And, Excel thinks that 1900 was a leap year... don't use...
December 23, 2006 at 7:31 am
Crud... copy and paste error on my part... I didn't include the exec. Glad you got it working and thanks for the feedback.
December 23, 2006 at 7:26 am
Sol,
Recommend you post the CREATE TABLE statement for the table with 2,000,000 rows in it and the proc that creates the report. Be sure to include the code for any...
December 23, 2006 at 7:17 am
My basic strategy is to avoid using a Clustered Index as a PK if the table suffers a large number of Inserts, Deletes, or Updates to the PK columns because...
December 22, 2006 at 11:33 am
Doesn't matter what YOU can see... what can the SERVER see? The server must be logged in as a "power user" that can see shares and machines. In Enterprise Manager,...
December 22, 2006 at 11:17 am
Anytime you try to put a row source or a table name in a FROM, you must (unfortunately) use dynamic SQL...
DECLARE @sql VARCHAR(8000)
December 22, 2006 at 11:09 am
The "app" cleaned it up... the number is still stored in the db with the inaccuracy.
December 22, 2006 at 9:46 am
Before you start using table variables... study Q3/A3 and Q4/A4 of the following link...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
...and, yes, there can be a huge difference in performance... because table variables do not use...
December 22, 2006 at 9:38 am
I agree with SQLBill on many of the points he made. You might just be viewing things differently or incorrectly... post the CREATE TABLE statement for the target table... if...
December 22, 2006 at 9:34 am
I agree with Vladan... spend some time with Books Online...
Although I think MONEY is the correct datatype to use here, using DECIMAL(10,2) won't kill you if you don't mind...
December 22, 2006 at 9:20 am
I think you're making a big design mistake but it's your funeral... ![]()
PROCEDURE dbo
December 21, 2006 at 11:35 pm
Rajesh,
What feeds the proc you just posted? A GUI, a batch job, another proc? or ???
December 21, 2006 at 11:22 pm
While I'm looking at this, gotta ask... did you run the SELECT through the Index Tuning Wizard, yet?
December 21, 2006 at 11:09 pm
Viewing 15 posts - 57,091 through 57,105 (of 59,066 total)