ScottPletcher (3/17/2016)

---

Jeff Moden (3/16/2016)

---

Sergiy (3/16/2016)

---

Jeff Moden (3/16/2016)

---

I strongly agree. NULL is not NOTHING. ...

Lynn Pettis (3/17/2016)

---

rcooper 78099 (3/17/2016)

---

Solution Found:

;with cte as (select chppon, datediff(day,

case when chrcdt between 19000101 and 30000101 then

convert(date,cast(chrcdt as varchar(8)),112) end,

cast(CURRENT_TIMESTAMP as date)) as Age

from clmhdr

where chstat...

You're missing the closing parenthesis for your cte.

You also have an additional semi-colon at the start and a missing semi-colon at the end of your query.

The Danish Dynamo (3/17/2016)

---

This looks a bit heavy

AND Calendar.Datetime >= @StartOfWeek

...

Doors

For a single column, you could use COUNT(*) OVER(PARTITION BY Status)

If you want more accurate help, read this: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

That's a long procedure and optimizing it could take days, you won't get full help from forum posts, so either you break...

Jeff Moden (3/16/2016)

---

That's a serious matter of opinion. I think they flubbed it in two ways...

1....

dBase

The datetime and smalldatetime types allowed arithmetic calculations based on the way the values were stored.

The new data types don't allow these operations to allow better functionality.

The functionality is supported,...

You're welcome. Thank you for your feedback.

SSIS won't accept semi-colons with the Oracle drivers.

I'm not sure if you can make it work without the semi-colons removing BEGIN & END.

DON'T use dynamic SQL for this, it's a big risk for SQL injection in this case.

You can use a splitter to separate the values in order to use IN.

declare @Location...

SSMS is a client tool and does not have...

For multiple selections, you could use the DelimitedSplit8K to split the items. You can find it in here, along with the explanation to use it: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Here's an untested example on...