Sergiy (3/3/2016)

---

drew.allen (3/3/2016)

---

I see no reason to join to a Tally table here. You have to calculate (ID_No-1)/6 anyhow, so just use that as your first group by expression.

You can...

It is a BAD IDEA to use a PAST date to represent an unknown FUTURE date. You're much better...

Sergiy (3/1/2016)

---

Only thing - for adding rows when you go over 6 ID's per Provider you're gonna need a tally table.

Here I used a Tally table with sequential numbers from...

oneteabag (3/2/2016)

---

To Clarify it is just One database we are talking about.

So the question is : would I create one SSIS with 4000 line of SQL code or I...

SQLisAwE5OmE (3/1/2016)

---

Hmm....don't really agree....I'm not...

If this is a third party app, writing a trigger on the table will almost certainly invalidate any maintenance agreement that you have with them.

Drew

Based on the UDF in your Biograph_Master_UDF, I'm assuming that this is a user-defined function that returns a table. Computed columns can only call user-defined functions that return a...

TomThomson (2/27/2016)

---

Jack Corbett (2/27/2016)

---

Ed Wagner (2/27/2016)

---

Having recently been on the interviewing end of dealing with recruiters I can say that modifying a resume is a common practice. ...

The first thing I notice is that you are calculating two ROW_NUMBERs that you never use.

You also have unbalanced parentheses.

If you want any more than that, I suggest that you...

This also performs well. I thought it would perform better than Gianluca's, because it doesn't need the RANK, but the plan seems to think that they have the same...

SQLisAwE5OmE (2/24/2016)

---

Even though the other queries were working, I had to export to excel and remove duplicates, etc to get the unique 49 results.

This query gives me the exact 49...

This sounds poorly thought out. Why would you want to arbitrarily change the breed of a dog?

That being said, I came up with something using NTILE() which splits a...

sharonsql2013 (2/23/2016)

---

How can I show last days for past 3 months say..

Jan 2016 (2016-01-31 23:59:59.000)

, Dec 2015

and Nov. 2015

Need to be dynamic as it will change with...

Based on what you've given us:

1) Your procedure is missing quotes.

2) Why are you using dynamic SQL when your queries are static?

If that isn't the issue, I suggest that you...

Use GROUPING SETS. Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS

SELECT Level1, Level2

, COUNT(CASE WHEN Result = 'PASS' THEN 1 ELSE 0...