SELECT

'20130701' AS Date, Year,

6 AS JulyMaxhours,

SUM(6) AS Total_Hours,

KindOfDay, Month

FROM Auxiliary.Calendar

WHERE (KindOfDay =...

It's easy enough to generate the code for 00 to 99 based on the pattern for 00, so it's not really "manual" coding.

I figured on a (very broad) average of...

Not sure I fully understand, but maybe:

SELECT Date, Year, CASE DATEPART(mm, date) WHEN 07 THEN 6 END AS JulyMaxhours, KindOfDay, Month,

SUM(CASE WHEN DATEPART(mm, date) = 07 THEN 6 ELSE 0...

CREATE PROCEDURE [dbo].[GetExtractSiteExtractFileBatchPreviousSuccessInd]

@BatchStatusCd NVARCHAR(5)

,@ExtractSiteCd NVARCHAR(10)

,@ExtractAsOfDate DATETIME

AS

RETURN (

SELECT CASE

...

Maybe consider records to "match" if the SSN, first name and birth date all match. My reasoning: last name can change (marriage, etc.), and middle name may not be...

Or, depending on your specific needs, you could add your own logging/pseudotrace code to the proc itself, and trigger it with an optional parameter:

CREATE PROCEDURE dbo.proc_name

@...,

...

You don't really need SSMS to generate the statement. [And of course you don't try to make the change using SSMS, as SSMS will rebuild the entire table foe...

winmansoft, you should also be aware of the 14-byte-per-row overhead that READ_COMMITTED_SNAPSHOT requires. Anytime a row is updated, or a new row is inserted, the 14 bytes will be...

brettstahlman (3/18/2013)

---

Lynn Pettis (3/16/2013)

---

brettstahlman (3/16/2013)

---

Lynn Pettis (3/16/2013)

---

brettstahlman (3/16/2013)

---

opc.three (3/16/2013)

---

The reason why I disagree is because of the behavior of the after trigger when it is the instead trigger that is...

Could you go to NUMERIC(19,6)? That should work fine, and I think it will be just a metadata change.

This is off the wall, but did "AUTO_CLOSE" somehow get set on for that db?

That's a longshot, since even if it did it should auto_open when you reference it, but...

Interesting.

SSMS is probably internally running a query / stored proc to get the list of databases. Obviously the "SET ROWCOUNT" is affecting the code it uses as well.

I guess...

For certain UPDATE statements, SQL must instead actually do a DELETE and an INSERT instead of an UPDATE. So, the result is normal for SQL.

If you need to see...

Or, another possibility (with no character conversions/manipulation):

SELECT

ColA, ColB,

DATEADD(SECOND, ColB % 100, DATEADD(MINUTE, ColB % 10000 / 100, DATEADD(HOUR, ColB /...

I thought my query might meet the stated requirement while knocking out the second table scan :-).

If OP does need to list the alternate supplier(s), then yes, I think some...