Thanks Jay - my response was only a partial answer.

Guarddata-

There are many ways to do this - but not a built-in function that I know. I use

CONVERT( DATETIME, DATEDIFF( DAY, 0, <a Date> ) )

Guarddata-

Guess I was asleep when I looked last time. Chris, David, timingskey - thanks to each of you. Plenty of options now.

Guarddata-

When doing DTS transfers, scripts are generated for each step in the process. You should be able to just generate the SQL script for the database structure, then use...

Yes - this is a duplicate thread. I like to use

select ((1+datediff(d, <StartDate>, <EndDate>)+datepart( dw, <StartDate> ) ) / 7 )

- case when datepart( dw, <StartDate> ) > 6...

OK - So I attempted to create a function to perform this operation in order to select from a table and convert as part of a recordset output. The...

The trigger is only fired once for each update or insert statement so, yes, it must handle the processing of multiple rows. The phrase "different scenarios of multi-row transactions...

Notice that the article says two connections are generated when two "firehose" queries are used. Closing the recordset would assure that this would not be the case.

Guarddata-

Yeah - that's why I love these forums. Helps me open my mind to new ideas. If the individual offsets were stored in separate rows, I would probably...

Almost - but test that with July 10 - July 19 and the function fails to yield 2.

Try this one instead.

select ((1+datediff(d, <StartDate>, <EndDate>)+datepart( dw, <StartDate> ) ) / 7...

OK - so overcoming the nausia of having the output be different when put into dynamic SQL - which does, indeed, bother me still... How...

Thank you, gentlemen, for catching my mistake. Nice to have a second pair of eyes to keep out mistakes.

Guarddata-

I am sure what you are doing would work. Here is another option...

Since the value is really a bitmap, it is fine to store it as an integer rather...

Phew! I don't think I'm catching your vision. Set me straight - I am going for the concept more than the implementation. Do you have IDs that...

I'd be interested to see this one. When I use SELECT CONVERT( INT, CONVERT( VARBINARY, '0x8A' ) ) the answer comes 813185089 instead of the 138 I had hoped for....