I'd start by reading this entry in BOL.

Then I'd read this article on the FormatNumber Function which provides more options. The article is ofr VB, but all...

As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.

You can change it on...

That's always fun. I...

Just like Monty Python and the...

You could use a CASE statement:

SELECT

CASE

WHEN ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) 2 AND

ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) < 5 THEN 100

ELSE 75

END AS ROW,

P.PRODUCTID

FROM

PRODUCTION.PRODUCT P

I'd...

In my opinion you do not need the 3rd party backups as long as your SQL Backups are getting off the server and are originally on different drives than the...

Does the reporting services service account have rights to the location?

You would need to check the parameters for null values in the procedure and adjust your where clause accordingly. You can do this with IF statements and write...

What's the structure of dbo.ac_Orders? What does ac_Orders_ac_Shipments_FK1 point to? It doesn't look like this particular error is in your trigger. It looks like it is in...

The insane person is always the...

Odds are you have a value that is not an integer or is out of the range of integer values.

Or like one of my former employers decided, don't pay anyone.

I have to admit being disappointed you didn't say something like:

"Use the force well you did,...

Could be an error with the data type, a primary key or unique constraint, or a foreign key. Can you provide data types and values?

You may...

Are there any parameters following it that are filtered by it?