Try this. Notice how the count is zero for the column containing all NULLs

IF OBJECT_ID('tempdb..#tmp', 'U') IS NOT NULL

DROP TABLE #tmp;

CREATE TABLE #tmp

(

...

SQL Code Guard[/url] may be of interest.

Repeatedly asking the same question is not going to speed up replies.

sindhupavani123 (11/4/2016)

---

I have the following data with client account decision and status

Clientfields value

111Decisionaccept

111Statusdeposited

112decisionaccept

113Decisionaccept

114Decisionaccept

114Statuscontract

115DecisionConditional Accept

115Statusdeposited

116DecisionConditional Accept

117DecisionConditional Accept

118Statuscontract

118DecisionConditional Accept

I would like to get

records...

The...

sgmunson (11/3/2016)

---

This is in the category of double-posting... and hoping for an answer that doesn't disagree...

whenriksen (10/31/2016)

---

Phil Parkin (10/30/2016)

---

in this case, for queues of SSIS packages waiting to be executed, within different ETL jobs.

The volumes I am dealing with are much lower than yours and...

philand3 (11/2/2016)

---

experts,

how to exclude the negative value in this OT calculation,

,CalcPart AS

(

SELECT

department,subdepartment,dutyhours,person_num, event_date, in_time, out_time, minutes,day,friday,saturday,

ROW_NUMBER() OVER (PARTITION BY event_date, person_num ORDER BY in_time) AS daypart

FROM Prep

)

,tmpResult as

(...

rjaye03 (11/2/2016)

---

We have just encountered what appears to be suspect data in a lot of our SQL databases that house backend data for internal and external websites. For the...

matej_grabnar (11/2/2016)

---

I have SSMS RELEASE 2016.5 installed. Tried reopen/reinastall - I even did format & reinstall Windows 10 (with like 1 month of great SQL working connections)

I have no...

hoseam (11/2/2016)

---

I have

which gives me INT value of 72226, and I want it to include the...

Is that because you have set...

GA_SQL (11/2/2016)

---

Adding space to the Database , when the db is 75% full

here i done some script for finding free space

select

s.FILEID AS...

matej_grabnar (11/2/2016)

---

After upgrading from Windows 7 to Windows 10 - and after some updates of windows a very slow connection (10 - 20s) to SQL server accrued.

Queries are executing...

Telling us that something is "not working" is most unhelpful. Please elucidate.