mjakachira (1/27/2016)

---

I'm not sure I understand why but my IND_Desc does not seem to be grouping between the union. An example would be I have a IND_DESC in both tables...

How long does that query take? There are so many nonSARGable predicates in that view alone it is frightening!!! Then you have several more in your query.

I gave you the...

What I am dealing with now is why...

SQLisAwE5OmE (1/25/2016)

---

INNER join is fine at the parent info....

I am confused whats the exact syntax to use under group by clause.

Basically I need to find out if a student is...

SQLisAwE5OmE (1/25/2016)

---

Sean Lange (1/25/2016)

---

SQLisAwE5OmE (1/25/2016)

---

Hi Sean, Thanks for the feedback.

Sorry for the messy query....I didn't actually write it.....I wish I could write query like that....but thanks for cleaning it up.

Anyway,...

SQLisAwE5OmE (1/25/2016)

---

Hi Sean, Thanks for the feedback.

Sorry for the messy query....I didn't actually write it.....I wish I could write query like that....but thanks for cleaning it up.

Anyway, I use crystal...

btsserv13 (1/25/2016)

---

Thanks for the response Sean.

I did try using SSIS transaction and it takes more than 20 X times to execute the package than it would if I use without...

Using aliases is a great idea. However when you name your alias the same as the original table name it kind of defeats the purpose. Also, you should avoid using...

btsserv13 (1/25/2016)

---

I need to refresh a table with new / updated records so I have created a SSIS package for that

In SSIS, I am

Deleting records from the table for a...

Ed Wagner (1/22/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Eirikur Eiriksson (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot to...

Hugo Kornelis (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot to cook it in.

But refuses...

This is my last attempt at trying. Can you...

joeshu26 (1/21/2016)

---

I have a table of dates, companyIDs, and industry.

CREATE TABLE #mytable

(

...

Meaning you want them returned? Do you need any other information? This would be a LOT simpler if you would tell us what you want instead of...

This isn't very clear what you want here. Are you wanting to write...