replication is not a bad idea. I'll check with the person coordinating the vendors and see if it might be an issue. This will be coming to fruition...

Jeff--

That is still a topic of discussion with the hardware folks and the checkbook folks. 🙂 I suspect that the answer will be no and that's why I'm...

Hey guys--

Thanks for the links and aadvice. I was able to find a way to do this, but it seems like a fairly large 'kludge' that we'll have to...

I think that the first thing that you need to do is get your data into the correct format:

If you have a date variable, CONVERT or CAST it to DATETIME...

Our end users require data to be grouped by calendar week resulting in a similar predickerment. Our implemented solution is nearly the same as that provided by michael_darrow's response...

I would have to agree that No. 3 is correct also.

IMHO one of the better single books on T-SQL and a couple of other flavors is :

"SQL CookBook" by Anthony Moliaro and published by O'Reilly.

It has good real world examples...

I find a certain shortcoming in the logic of the answer -- its the logic of an attorney not of a mathematician. 😉 I seldom reply to the QOD...

Nita--

This is what we use:

USE your_database

GO

CHECKPOINT

GO

BACKUP LOG your_database WITH TRUNCATE_ONLY

GO

DBCC SHRINKFILE (your_database_log, 2) -- this needs to be the name of the log_file from EM

Thx --Jim

Some interesting backgrounds! I started college in 1969 as a physics major with an interest in astronomy. Programming was included -- Fortran on punch cards! By 1972...

Sergiy--

Thank you for this solution. I will try this in our dev system today. Thanks all for your helpfulness on this issue. This is a very worthwhile...

Phil--

Good assumptions! This is a solution that will work for us. We can't always control the formatting of the barcodes because some come from outside vendors. This...

That could be the answer! In the real world, these numbers are barcoded on envelopes and we send and receive a couple hundred thousand a month. In light...

I'd also like to add that in the real world it is seldom as easy as filtering on a date for a single table. You'll need to know whether or...

Check this link:

http://www.sommarskog.se/sqlutil/aba_lockinfo.html

We compile this against the master datbase and it gives us a good picture of what is happening.