Hi Ryan,

A numeric(4,3) means that the total length of the value is 4 and the precision is 3. An example of this is 4.014.

With this in mind how would...

I'd use

O.Delivery_Date <= DATEADD(dd,7,O.Date_Order_Placed)

But both would work.

Good point on the SARG.

As an afterthought, if Date_Order_Placed is a datetime and delivery date just a date it should be:

O.Delivery_Date <= DATEADD(dd,1,O.Date_Order_Placed)

You'll obviously have to replace with your column names....

SELECT

*

FROM

Orders O

WHERE

DATEDIFF(dd,O.Date_Order_Placed,O.Delivery_Date) <= 1

I do have the same thing with one of my servers, but it's on a different domain and I choose to specify connection credentials on each new session. I'll...

I think the question here is picking the lesser of two evils. With the disk configuration you have I think you have two choices.

1) Install MSDTC and SQL into...

You haven't got a where clause on your cursor definition, so no matter what is inserted into the table, the first part of the IF will run and the second...

Would I be correct in assuming each client has a different first two digits?

Unless I've missed something there is a much more economical way of doing this and I would...

Your Quorum disk should belong to the Cluster group.

I'd then put any physical drives that are you are going to use for SQL in the SQL Cluster group. You...

I know you didn't specifically ask, but you may want to look into changing the compatibility level of the database once restored in order to take advantage of all of...

Hi Niyala,

When you connect to the server in question, are you prompted for login credentials?

Adam

No problem.

Yes, that is correct. Basically, specifying "SELECT *" is saying return all columns from all of the tables in the query. You can replace the * with...

I'd imagine it's only trying to read the registry in an attempt to gather information on the environment it's running in. I've seen a few similar posts in an...

Hi Fosco,

That is highly likely the reason. You can use LEFT JOIN to select all records from the first table (on the left) and any matched records from the...

Hi Mattie,

From the code you've posted, each execution of stp_SpotsExtractUpdatePermFiles will only perfom one insert into SpotsWarrantsErrors.

Are you sure the stp sproc isn't being executed more than once and that...