What kind of developer are we talking about? Will she actually be doing database development or does she just need access to view data and code and what not?

There's...

There are limits on how many addresses you can send how quickly to the USPS webservice validation tool, so no they do not want you using it for doing bulk...

SELECT CAST(0 AS DATETIME)

Will give you 1/1/1900, the RAND(CHECKSUM(NEWID()))*3653.0 basically give you a 10 year date range from that so between1/1/1900 and 1/2/1910, then adding 36524 adds 100 years to...

Evil Kraig F (12/5/2014)

ZZartin (12/5/2014)

Alexander Suprun (12/5/2014)

Eric M Russell (12/5/2014)

Jeff Moden (12/5/2014)

Ed Wagner (12/5/2014)

Eric M Russell (12/5/2014)

The input should be properly parsed and formatted prior to inserting the database table....

Alexander Suprun (12/5/2014)

Eric M Russell (12/5/2014)

Jeff Moden (12/5/2014)

Ed Wagner (12/5/2014)

Eric M Russell (12/5/2014)

The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to...

I told you yesterday you need to put the manager name parts in ( )

AND ([TSR_MGR_NAME] IN(@MGR_NAME) OR [EI_TSR_MGR_NAME] IN(@MGR_NAME))

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