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)

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...

YAY for people who still allow SQL Injection on their servers! (NOT!)

http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D

Yay! That will certainly help you out.

That is a very good point, Gazareth. Even my query won't run very well if the table is a heap.

Note...

Do you have a question or are you just reporting something you ran across and fixed?

Instead of doing all your processing in the CASE statement, try using subqueries. I was going to do this using CTEs, but decided to go with the multiple join method.

SELECT...

There is no backup designed for indexes only. You could script them out as a DROP - CREATE series of statements by going to the GUI though, right-clicking the database...