Lynn Pettis (3/29/2012)

---

And then when you select from the table be sure to use an ORDER BY clause...

You may want to double check what you need to keep track of. In the scenarios where I've had to implement this type of tracking, you need VERY specific...

Jeff Moden (3/26/2012)

---

Matt Miller (#4) (3/26/2012)

---

sknox (3/26/2012)

---

For testing purposes (both scientific and software) pseudo-random numbers are preferable to truly random numbers*, because you want to see how the system responds...

sknox (3/26/2012)

---

For testing purposes (both scientific and software) pseudo-random numbers are preferable to truly random numbers*, because you want to see how the system responds to the entire range of...

By rounding it, BEFORE the sum, you're essentially signifying that only 2 decimal places are "significant". With that in mind, both numbers are accurate descriptions of the result.

Remember in...

ROUND() doesn't change the data type in this case. The result is still a FLOAT.

http://msdn.microsoft.com/en-us/library/ms175003.aspx

If you want it to be a decimal when you all done, CAST it to...

From my experience, the CLR itself is always going to be disadvantaged when trying to write to the DB (the CLr best practices advocate avoiding writebacks for this reason). The...

Two aspects to look at:

- most of my tables are accessed in some fashion. That said - very little of the data older than a year is ever...

You're hitting two different kinds of fragmentation. One is physical file fragmentation (how many parts are scattered across the various physical disk strcutures), and the other is logical (within...

I am not...

SQL Server per se isn't going to care which card is used to access the drive. It frankly doesn't actually care whether the drive being used is local or...

farmkittie (3/12/2012)

---

OK, I'll just reply next time. Do you think there is more to the select statement that i didn't add? I'm having a difficult time trying to find...

Also - If you fire the trigger after UPDATE, your taxid ID will never be anything other than 1.if you were to update the taxID from the UI, the trigger...

As an FYI - you can also do this from a client machine with visual studio. From within an Integration Services project you can "Add Existing Package" which will...

keep in mind that calvo's fix is a machine-specific fix. If you post from multiple PC's, you need to do that from EACH machine.

You can change your notifications on...