@ Ken

Please provide ready to use table def and sample data together with expected result as described in the first link in my signature.

@mrpolecat

What exactly is the difference of the...

And I say shame shame shame shame shame, SHAME ON ME! 😉

I should have spotted it right away...

Regarding your questions:

1 Can you reproduce this?

2 If yes, why would this happen?

3...

grevesz (7/6/2010)

---

Hello Lutz,

I was talking about the SELECT statement in this thread posted yesterday at 4:12:48 PM:

...

This statement, when I run it, returns case when ts_order.trans_type BUY_SELL, as the...

Glad I could help 😀

I don't quite understand.

What section or character...

grevesz (7/5/2010)

---

Hello Guys,

Thanks a lot for the explanations and ideas. This is a lot for me to digest, so please bare with me for a day (or two). I am...

bryan.duchesne (7/5/2010)

---

boy... that was fast... I didnt have a chance to edit my post before your replied but sadly that didn't seem to do the trick. I still...

Something like this?

INSERT target (field1, field2, field3,.....)

SELECT field1, field2, field3

FROM Source

WHERE NOT EXISTS (SELECT 1 FROM target t2 WHERE t2.field1 = Source.field1)

Lowell (7/5/2010)

---

well...this does what you wanted, but look at the results based on your sample data....it's appending a bunch of CASE WHEN statements and stuff....is that what you wanted?

this statemnts...

First of all: Thank your for providing ready to use sample data!! 🙂

Made it really easy to focus on the subject!

Here are a few items I run across while...

Regarding question #4: Did you try to right click on the function in question and select "Modify"? 😉

As a side note: It seems like all you want to do is get a comma separated list columns ofr a table specified by @an_export_id.

If so, there are concepts available...

rajendra prasad-377679 (7/3/2010)

---

...

now i am working in one organisation they ask me to write the program for that scenario using cursor..

that s y i ask help to the experts..like u...

Step one: Define a column to be used as a row/column identifer (either column Parameter or a new column using ROW_NUMBER())

Step two: UNPIVOT the data to get a table with...

I would precalculate the data per user and day using a CTE or subquery.

; WITH cte AS

(

SELECT ServiceID ,

COUNT(DISTINCT DATE) AS cnt,

SUM(numHours) AS subtotal

FROM @ServiceDates

GROUP BY ServiceID, UserName

)

SELECT L.ClientID, S.LocationID,...