This is one approach (assuming you posted on the correct forum).

WITH CTE AS(

SELECT

ProductID,

...

If you're trying to format a textbox, use the format property with the following value.

MMMM dd, yyyy

If you're trying to format a parameter, just don't. Use the date/time type.

SQLPain (4/14/2016)

---

I am unable to get rows where ad.StatusAppDetail IS NULL. I am using the following code.

SELECT DISTINCT

ISNULL(Other, 0) AS Other

FROM Chain AS C

LEFT JOIN (SELECT

Count(ad.AppID) as Other,

C.DealerID

...

Like this?

=DateAdd("d",-Day(Today()), Today())

Ed Wagner (4/14/2016)

---

Luis Cazares (4/14/2016)

---

Ed Wagner (4/14/2016)

---

SQLRNNR (4/14/2016)

---

Luis Cazares (4/14/2016)

---

Is this guy for real?

How is it possible that he can't work out a basic DML statement and still have a...

Phil Parkin (4/14/2016)

---

Steve Jones - SSC Editor (4/14/2016)

---

Well, apparently I don't write good questions to teach these people things.

Maybe some of you should write some questions to help people learn...

Ed Wagner (4/14/2016)

---

SQLRNNR (4/14/2016)

---

Hopefully Hugo has him...

A different option.

SELECT YourDate,

CASE WHEN MONTH(YourDate) <> MONTH(DATEADD(day, 1, YourDate)) THEN 'True' ELSE 'False' END,

CASE WHEN YourDate = DATEADD( MM, DATEDIFF( MM,...

Fixed That For You

I feel that many of these standards to certify processes are simply created to make money.

drew.allen (4/14/2016)

---

You need to be VERY CAREFUL with the quirky update. It is undocumented, not guaranteed, and requires a clustered index on the sort order. If you DO...

Is this guy for real?

How is it possible that he can't work out a basic DML statement and still have a job?

I honestly don't know why it does that.

I know however, that you can change the format file and set the column as SQLCHAR (leaving your table intact) and let it...

INSERT INTO goes before the whole statement, not before the SELECT from the derived table.

Do you mean like using INSERT INTO YourTable SELECT ....?