Every table.

It's an "end of command" marker. Currently, it's voluntary, but as Matt mentioned, it's supposed to be mandatory at some point.

If you search for "SSIS variable" in Books Online, it has data on how to set variable values programmatically, and so on.

That's a good idea, Steve. Remove the name/user ID from it, so it's not a "blamethrower" log, just a billable hours log.

David Reed (1/14/2009)

---

If it's back2basics time, why is everybody focused on when The Economy™ will get back to its previous highs? Of course, by The Economy™ most people seem to...

Ross McMicken (1/14/2009)

---

GSquared (1/13/2009)

---

Forgetting to highlight the Where clause is just one example.

As a note, he had the production server and the dev server open in Management Studio at the...

You can make the last step of a job be something that logs completion, and the first step of the next job be something that checks for that, and waits...

Something like that would require a lookup table and some more complex rules, but it could certainly be done.

If you go that way, you might also want to add an...

How about:

select sum(UnitPrice), min(ProductOption)

from totalsum

Will that give you what you want?

Or, when you say "first", do you mean the lowest, or the one in the first row? What if...

You could, but there's no real reason for it. SQL Server will cache the data and such for you pretty efficiently.

If you really need to do that, use DBCC...

The other thing you can do is join the inserted data back to the source data, in a second query.

For example:

create table #T (

MyTableID int primary key);

insert into dbo.MyTable (columns)

output...

You can do direct math on datetime data.

Why not use:

workitem_created_on >= @StartDateTime and workitem_created_on < @EndDateTime

You just have to make sure that @StartDateTime is the date, and time, you want...

I would add a flag to the data for "IsApproved" or something like that. Defaults to 0, and can only be changed to 1 by a manager. Queries...

Management Studio won't do that for 2005 (even Management Studio 2008). You have to get a third party product for that, like the ones from RedGate and ApexSQL.

I haven't seen an option for that in the installer. Probably should be, and maybe I'm just missing it, but I haven't seen it.