The size of the log file won't change unless you manually shrink it, so since it grew at some point to 367MB it'll stay that size even if most of...

Well were the file sizes you posted with or without the NO_TRUNCATE option set?

Take out the NO_TRUNCATE option, that's basically telling it not to mark the log entries it backs up as backed up and reusable which is why your log backups keep...

If you're really getting 90 files all in different formats then yes you would need to create 90 different flat file connects, how else is SSIS supposed to know how...

We'd need to see the data to see why it's returning more records than you want, but can you try including COUNTRY, SEGMENT, TSR_MGR_NAME and EI_TSR_MGR_NAME in the select?

Also do...

Well is that query returning 5 distinct names?

Agreed this should be handled at the web app level not the db level, not only would the web app constantly have to be checking the db for the active...

Is it really that hard to test the code out once before hitting submit?

The file attachment doesn't take wild cards so you'd need to know the exact file name somehow, there's a number of ways to get that.

As far as date formatting http://msdn.microsoft.com/en-us/library/ms187928.aspx...

Well if you're always going to get the data in that format.

DECLARE @input varchar(500)

SET @input = 'A petition for the winding-up of the above named company was presented on 09.09.2003...

ScottPletcher (12/1/2014)

---

GilaMonster (11/30/2014)

---

I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and you...

Would that approach really be worth it for what sounds like a one time job?

You phrased the question as what is the...

lshanahan (11/26/2014)

---

Markus (11/25/2014)

---

You guys must live in a perfect world of applications... However, the bulk of the SQL Server based apps are small companies and don't have the resources or...

It looks like you have mismatched else statements, try rebuilding it slowly one case statement at a time. Also a lot of those case statements look redundant which will...