USB...

Here's a slightly different approach using a in-line table-valued function (itvf).

I don't know if it will even compile since I have nothing to test against (your sample data require a...

You could try to run the two statements in reverse order.

I'm confident "all of a sudden" the query running "fast" in the beginning will be the "slow" one.

What is the...

Depending on the layout of your SAN it might be an option to move tempdb to a LUN based on more than one spindle dedicated to tempdb only. Or maybe...

I'm not sure if I understand correctly what you're looking for.

If it's just to avoid to display the data in SSMS, you could use the following approach:

open a new query...

As per my knowledge there's no way to "ensure data are secure". You could allow dev to only access views instead of tables and use "TOP x" inthe view definition....

Something like this?

Update mytable

Set [A-Name]=CASE WHEN [A-ID] IS Null THEN null ELSE [A-Name] END,

[B-Name]=CASE WHEN [B-ID] IS Null THEN null ELSE [B-Name] END

...

As a side note: Ihope the column names...

Koen Verbeeck (2/7/2012)

---

Evil Kraig F (2/7/2012)

---

Koen Verbeeck (2/7/2012)

---

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday...

First of all, I'm very sorry it took me so long to understand what you're looking for. :blush:

I guess I got it now.

the adjustment I made to my previous code...

I'm still not sure how the expected results can be calculated (e.g. 07/01/2012 WC 1).

So I post what I have so far:

;

WITH cte_range AS

(

SELECT

CAST (MIN(datewardchange_dte) AS date) min_datewardchange_dte,

DATEDIFF(dd,MIN(datewardchange_dte),Max(datewardchange_dte))...

Why does CCU has a count of 1 for Jan'08 but WC doesn't show 1 for Jan'06?

Can you please verify that your expected results are based on the sample data?

Example:

I find only one row for ward='BB' that would match Jan'06. Why does your expected result needs...

Would you mind sharing your solution so others may benefit?

Duplicate post. No replies please.

Original post: http://www.sqlservercentral.com/Forums/FindPost1245459.aspx

@deepikamm: Is there any specific reason for starting a new thread with the very same question?

What would be your expected result based on the sample data?

What do you want to achieve by "fetching" the ProdId?