Roland C (7/24/2014)

---

Certainly I missed something, but what about http://technet.microsoft.com/en-us/library/ms187638%28v=sql.105%29.aspx ?

In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer...

Learnt something new today, thanks for the question

Livingston, I took the logic What you have mentioned, I took the count of those days which are matching in both assgn_dtm and complet_dtm and then deducting those from sum...

I am sorry, Chris for not mentioning your name. Thanks for your support

Thank you J Livingston and David Burrows.

I appreciate your help and time

twin,

for count(*) --...

For that only I need logic to get the required output, but i am truly stuck what to provide now

select cs_id,USERID, SUM(datediff(dd, assign_dtm, complet_dtm))-(COUNT(repetitive_dates))

from temp_tbl

--if the same date...

twin,

we have two date columns like assgn_dtm and complet_dtm.

Need to calculate the difference of these two dates

for a given cs_id and userid

cs_id and userid can have multiple rows for...

select cs_id,USERID, SUM(days_of_diff)-(COUNT(dates) --if the same date is appearing both in assgn_dtm and complet_dtm)

from temp_tbl

like

select 1000090 'cs_id',1000031 'USERID', 22-11 total_pending_days

No help Yet !!!!! 🙁

Though, the answer is NO , still wanted to make sure that there no catch or new enhancement in sql server 2014 🙂

This is my understanding. primary key is a constraint not an index, but it creates an index automatically by default, but primary key is called a constraint not an index...

I also have no knowledge about powershell script. I have saved the script as.ps1 and executed it in command prompt like mentioned below.

powershell -ExecutionPolicy ByPass -File c:\Document1.ps1

(I could...

I have actually thought of this question yesterday :-), I am surprised to see it today.

(of course, I don't have plans to submit as QOTD)

I have searched all the deprecated / discontinued features in 2012 but could not find "compute", and got it wrong 🙁 :crying:

( I had to run the code in 2008...