Lynn Pettis (8/17/2012)

---

Stylez (8/17/2012)

---

Hi Lynn. Yes, I was trying to Set All The Dates To January 1 (For Data Scrubbing Purposes). i am also thinking if a trigger is causing...

Can you post ddl and sample along with desired output? Take a look at the first link in my signature for best practices when posting questions.

Can you elaborate on "It is not working"? What does that mean? Did you get an error message? Did it...

dwain.c (8/17/2012)

---

ChrisM@Work (8/17/2012)

---

dwain.c (8/16/2012)

---

The quality of the hires will be roughly proportional...

Lynn Pettis (8/16/2012)

---

Something about using the right tool for the...

I was just about to suggest using SSIS instead but it looks like Lynn beat me to it. 😀

Ken Davis (8/16/2012)

---

Sure. A client wants it that way. They want a CSV file with the contents of a view and they say they need the first row...

Quite an odd requirement but it is going to take some work on your end.

Something like this should work.

select 'Col_1' as Col_1, 'Col_2' as Col_2, 'Col_3' as Col_3, 0 as...

Pretty sparse on details but I think you want to use a left join instead of a union.

So if you totally remove the date check then it runs fast again? That sounds like indexing to me.

ChrisM@Work (8/16/2012)

---

pwalter83 (8/16/2012)

---

Hi,

The query I am working on runs very slow due to a piece of code -

CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1

Could someone please suggest...

Definitely do not need a cursor for this.

declare @ProcessingDate date = '17-May-2012'

PROCESSING_DATE > dateadd(d, @ProcessingDate, -1)

and PROCESSING_DATE <= @ProcessingDate

If that doesn't point you in the right direction, take...

scottichrosaviakosmos (8/10/2012)

---

For those of you who have not understood my question. In one line , I have to do a data migration and have to find the child who have...

Borrowing from the fine example Luis provided this produces the results you are looking at least with the sample data.

SELECT child.LotID,

child.Parent,

isnull(CASE WHEN LEN( child.VBS) > 0 OR LEN( child.MOL)...

Woohoo!!! Vacation starts in about 7 minutes. Meeting my wife's parents, her brother and another close family friend for a long weekend in Chicago. 16 people in all. If you...