Sergiy,

And you still refuse to provide the citation in New Zealand Law that prohibits the use of BR.  What, are you having problems finding the facts to back up your...

David, Ignore who?

No, David is talking tolerances.  Depending on the scale, the tolerance is + OR - a specific % or weigt.  This tolerance will be dependent on the scales usage and...

In Object Explorer in SSMS, Right Click on the Database, and select Generate Scripts.  The wizard will walk you through generating what you are after.

I partly agree with that, but some else has heaped some fuel on it as well (not you, Jeff).  I got some good info that could come in handy.

And the flaming starts again.  I think the professionalism of this site is starting to wane.

(1000000 row(s) affected)

===== Rounding method 2 ======

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

373...

Looking back at my code, its semi-generic.  I can see a few more changes that would need to be fixed to make it more generic and useable for any three...

I see one possible problem using dayofyear; leapyears.  February 29 of a leapyear is the same dayofyear as March 1 of a non-leapyear year (confused?).

We don't have our QA/Production systems yet, but we have setup our SSIS Packages to dynamically configure the connections using information stored in a Configuration Database table.  The only fixed...

I guess it really comes down to the volume of data you have to process and your requirements.  It's always good to know different ways of accomplishing a task, so...

Some say it is faster than converting to/from varchar.  I have done some testing and it is sometimes faster but sometimes slower.

In our process we put *.txt in the arguments property as we have multiple files to zip.  This is where you may want to put the the name of your...

Also, I am reviewing all of our posts to make sure I know where we are, as I don't want to leave out a step.

I'll get back to you on the errors you are getting, I need to look at them a bit but it may be a bit before I can get back...