Viewing 15 posts - 2,836 through 2,850 (of 3,232 total)
Sorry for the late post. I wrote this yesterday afternoon, but I was unable to post it due to a server outage.
Again, without knowing your table/index schema information, all...
May 25, 2006 at 8:35 am
This should get you started. You will have to add in all of the months and you will need to tweak it to handle the year.
create table monthgroup (RowID int...
May 24, 2006 at 3:26 pm
This query will not work as is. You have syntax errors in your joins, and SQL Server will not let you join the same table multiple times without defining table...
May 24, 2006 at 3:15 pm
This should return all rows from BL_IE and only rows from BL_D where the max_rev_flag = 'Y'.
SELECT BL_IE.key_no,
BL_IE.proc_date_time,
BL_IE.error_count,
BL_IE.origin_code,
BL_IE.excep_message
FROM BL_IE
LEFT...
May 24, 2006 at 2:51 pm
How many rows does your SELECT and DELETE statement process? You need to check your execution plans for these 2 statements. My guess is that the execution plan will not...
May 24, 2006 at 2:21 pm
"then I ONLY want those records returned from BL_D that have a max rev_no or max_rev_flag = 'Y'."
Should this read, max_rev_no or max_rev_flag = 'Y'? Are you looking for BL_D...
May 24, 2006 at 2:16 pm
Here's another recent post with similar info:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=282436
May 24, 2006 at 9:13 am
It sounds to me like you are wanting a way to populate NEW_TABLE and POSITIONS_TABLE from what you have in OLD_TABLE. If this is true, and from what you've shown...
May 23, 2006 at 4:08 pm
User1 needs to exist as a valid user in your second database. Moreover, User1 must have select permissions on whichever tables view1 touches.
May 23, 2006 at 3:59 pm
Where will you get the data for the Position_ID column? Will Position_ID in your New_Table be an IDENTITY column?
May 23, 2006 at 3:50 pm
"I tried using ROWLOCK on the DELETE, but I believe the DELETE's are too large. "
SQL Server may decide to escalate the lock method even when you use a...
May 23, 2006 at 12:30 pm
Yes, it could be a privelege/rights issue. If you are able to execute the package from the DTS designer, but cannot as a job, check the job owner. Make sure...
May 23, 2006 at 12:16 pm
I would recommend adding some error handling to the nested stored procedure call.
DECLARE @ReturnValue int
EXEC @ReturnValue = proc_Call_Some_StoredProcedure
SET @intSQLErrorNumber = COALESCE(NULLIF(@ReturnValue,0),@@ERROR,1001)
IF @intSQLErrorNumber <> 0 GOTO ErrorHandler
May 23, 2006 at 12:10 pm
All DELETES require locks, but keep in mind that deleting a large group of rows does not always mean that your whole table will be locked. SQL Server will determine...
May 23, 2006 at 12:05 pm
Viewing 15 posts - 2,836 through 2,850 (of 3,232 total)