There are some reconciliation systems that "require" that every number be identified. Check reconciliation caused us a number of problems this way. Identity columns will use the value...

Building on the suggestion of whoteegan -

We have found it useful to build a small application that accepts all the mail messages to be sent and queues them into a...

I agree with the DBCC CHECKDB. However, we had a similar problem recently and found the issue was really a bad disk in the array set. You probably...

You could also use a user-defined function to perform the work of selecting into a temporary table, then returning that table. I didn't run any statistics to see if...

For us to answer that question (DB or File system), we really ask different questions first. How will the image (PDF, or blob) be read and will there be...

No Antares - @@IDENTITY is safe as long as your own connection did not perform the insert into another table with an Identity column. @@IDENTITY is specific to the...

I prefer to keep all comparisons as DATETIME values because of the formatting problems related to CHAR or VARCHAR. That being true, I tend to use variables like @beginDate...

Are you creating this new database on the same server...or a server available to DTS? Would it be possible to perform a DTS export and just not copy the...

Actually - cursors were extremely bad in SQL 6.5 (I don't know about 7.0) but they perform very well in SQL 2000. At least in some of our routines,...

We have found it more convenient to separate the SELECT from the UPDATE in order to know if the failure was due to contention or end of queue. Also...

From the example, it seems like the dates have no time included.

If you are just interested in a single date:

declare @NortelTot INTEGER, @LucentTot INTEGER (check datatype)

SELECT @NortelTot = SUM(MOUs)

FROM...

My impression is that the first commands do not restrict the value to be a "money" data type at the time of rounding. The result of the mathematical...