To make sure first day of the week is Monday so you can assume that, to get the next Monday, just add 8 minus the current day of the week....

How about this?

set datefirst 1

declare @basedate as datetime

set @basedate = '20130808'

select

Today = @basedate,

NextMonday = dateadd(dd, 8-datepart(dw, @basedate), @basedate),

MondayAfterNext = dateadd(dd, 15-datepart(dw, @basedate), @basedate)

Happy Coding!!!

~~ CK

Try...Catch... is not a transaction controlling statement. It's more of an error handling in SQL Server. If you do not have a transaction block anywhere, every successful update will be...

I agree.

I made the INSERT/EXEC recommendation with the assumption that the he does not have any control on the SP aside from executing it.

Couple of questions:

1. Will it always have, at most, 2 pair of record?

2. Will the resulting record have the period + 1 of the paired records? Will there be...

How about this?

declare @spWhoTable as table

(

col_spid int,

col_ecid int,

col_status varchar(20),

col_loginame varchar(20),

col_hostname varchar(20),

col_blk varchar(20),

...

How about something with no CTE nor subquery...

I'll borrow the population of test data...

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

VendID char(3),

Type int

)

insert #Something

select 'ABC', 1 union all

select 'ABC',...

How about this?

To change the number of batch, change the value of @batch variable.

declare @batch as smallint

set @batch = 6

if object_id('tempdb..#sample') is not null

drop table #sample

SELECT...

I believe INFORMATION_SCHEMA views is already existing in sql 2000. You might be able to start from there.

Happy Coding!!!

~~ CK

That hit me, too...:angry:

Build a dynamic query for your BULK INSERT

exec ('BULK INSERT slave_tab

FROM ''' + @YourFileName + '''

WITH

( FIELDTERMINATOR =''^'',

...

Could you post too 10 rows from each table and your desired results?

-- CK

Would JOIN not be enough?

-- CK

You can try using format files.

For more on that, read here

-- CK

I got a similar article on my blog.

Read it here

-- CK