Start a new thread with all relevant details (including the answers to the questions on this thread). You'll get more hits that way....

SQLKnowItAll (7/16/2012)

---

Although I am not a fan of using *, how will eliminating that...

Unfortunately, you can't have both fast inserts and fast reads. You're going to have to pick one or the other, fast inserts and slow reads or slower inserts and faster...

I thought that was Bird Flu ... or...

Already happened once. We're still here.

A little singed, but still here.

Jeff Moden (7/16/2012)

---

Heh... their testing was...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

Is GAH a word? If so, that's my random word of the day.

GAH!

Don't have the packages kick off child packages. Have the SQL Job run each individual package (even the "child packages") as individual steps that only run if the "parent" package...

Is it just me or does the last bit of code have an extra single quote mark? Or maybe is missing one?

Also, please explain to me how @last_upload is not...

EDIT: changed question.

Why are you using LIKEs using wildcards on both sides of the keyword? You do it 3 times.

Also, you added a table to Scott's original query in the...

Arman Khan (7/11/2012)

---

Hi.

I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.

For Example:

=SUM(

IIF(Fields!rpt_date.Value = Parameters!RptDate.Value

And Fields!Mot.Value...

Post the code inside the window using the IFCodes please. Many of us don't open attachments. Also, post DDL with sample data so we can help you better.

More information.

When we call the webservices directly from the service, it doesn't timeout at the 15 minute mark. Only when we call it from the SSIS package does it timeout.

Does...

bitbucket-25253 (7/13/2012)

---

Revenant (7/13/2012)

---

I am...