Ummm... you're probably not getting any answers because there's not really enough data for folks to go on.... and a lot of them (me included) want to see some other...

If you can run it, then the job needs the same privs as you.

Sorry Mike, I've never used either. Hopefully, someone that has will see this...

...yeah... I'm "bumping" Mike's post because he didn't get an answer and I'm curious as well... 😀

No need for a cursor or While loop here... makes the code too long and slow. Try this instead...

--===== This makes a little test table according to the post

...

The major point has been missed... Andras explained it. You need a date column or an IDENTITY column to figure out what the last row actually is. Adding...

I find it makes sex interesting :w00t: Oops... sorry... wrong forum 😛

I think the only thing concrete is what the minimum installation requirements/recommendations are and what the maximum is. The rest is up to you to figure out based on...

Just in case you don't know... you can combine the two in a single select...

SELECT MIN(ValidateFromDate) AS MinDate,

MAX(ValidateFromDate) AS MaxDate

...

If you try to join 32 tables with multiple aggregates and functions on columns in the ON or WHERE clauses, it'll likely be better to use "Divide'n'Conquer" methods in a...

Do you have a time zone column somewhere?

Stephanie Giovannini (6/23/2008)

---

Based on the schema fragments you've posted, I'm seeing the following situations:

- Different phone ids may represent the same phone number

- Customers may share phone numbers

- A customer...

So, write some dynamic SQL to do it...

Hey Mark! Nice avatar!!!! 😀

Hey folks... especially Jeff Williams and Peter Larson... thanks for the great help. Like I said, I'm kinda new at 2k5 and you just don't find the...

Clear proc cache and clear the free buffers using DBCC commands of a similar name. Then, recompile the stored procedure code.