If I'm reading it correctly, it's pretty much just a "Where in (values)" statement with as close to unlimited number of allowed values as they felt they could get. ...

You'll need to add both. First the data flow to export to Excel, then the send mail to ship it. You might also need a file system task...

arun1_m1 (12/27/2011)

---

Hi ,

To get data from 'n' number of tables you can use the JOIN predicate. But personally I feel joining more tables will always hinder the process and data...

Can you check execution plans on each of those servers? Locally to each, I mean, not the linked plan.

In that case, it's going to be some setting or O/S incompatibility. Windows versions that are out-of-date, that kind of thing, is where I'd start looking. China is...

Jeff Moden (12/28/2011)

---

My most sincere apologies folks. Hugo and Paul are correct. I missed my own NOT NULL constraint on the StartDate column. I'm sending an email...

Is "Y" something that can be calculated from an input value, or does it vary based on values in the column, or something else? I'm not getting a clear...

If the third party backup software isn't updating the backup tables in msdb (system database), then you need to test restoring from those backups. Windows file-level backups generally don't...

Good idea. Wouldn't have thought of that myself.

For the original question, I recommend getting a copy of RedGate's Data Generator (http://www.red-gate.com/products/sql-development/sql-data-generator/), and using that for the rows you need.

Building 400k rows of test data for a table...

Jeff Moden (12/27/2011)

---

1Ankit1 (12/27/2011)

---

Jeff and Dev,

It was intended to present one more possible way 😛 . You got that right, with just 400K rows, it might be calling for more...

There's an article on running totals in SQL Server at: http://www.sqlservercentral.com/articles/T-SQL/68467/

Sorry. Forgot they added that one in 2008. And MSDN doesn't have the 2005 documentation on the DDL events available any more.

Looks like you're out of luck on...

ADD_ROLE_MEMBER and DROP_ROLE_MEMBER are capturable events at the server or database level, in DDL triggers.

I've worked at quite a few places over the last 24 years, and only one of them has offered to help pay for any sort of continuing education. That...