I am assuming the package(s) have enough time to run between each schedule and you have logs showing it has executed when expected each time.

if processing no data should never...

if i have understood your question, you have a table with three columns one contains forename and surname combined as a fullname and then you have a name and lastname...

Yegg

Canker

Kibitzer

looking at both queries i agree they are different.

If you imagine the first 100 records had been deleted and there were no other gaps in the TransactionID number...

nice one, glad to be of help.

before each load of data set a variable say (RowsLoaded) to -1 or some arbitrary value then use a rowcount and assign the value to the variable when loading your...

TriggerMan (12/20/2012)

---

These questions really are like individuals' SQL scripting styles... there are always 50 perspectives... I give you from BOL from SQL 2008 Express R2 (which many of you...

At the place where i used to work this was a method employed by the senior DBA until the length of time the backup took was deemed ridiculous and was...

i am sure i have seen a script on SSC for a dynamic pivot function; think this is the one : CLR Pivot[/url]

flowers

Frosty

cutty

Azido