Yes it does return it when I add it into the query, but the issue is that I need to close the tag.

Hi thats great, I was on the right tracks to figuring it out and your examples filled in the gaps, so many thanks.

However, lets say that for each order date...

Thanks for you help,

Jackal.

Yep, your right.

I suppose when I populate the table variable, it's at that point any isolation level who be applied, then it becomes a parameter, and as you point out,...

Hi,

They may well be, but surely if the pointer goes to the data, if a change is being made to the data then will the pointer have to wait for...

No, dont say sorry.

The more discussion the better in my view. 🙂

Thank you,

I've spotted my mistakes now, thanks for posting up your select, i'd of spent weeks looking at mine if I didnt have something to compare it to.

Thanks again,

Jackal.

Thanks for that.

It all makes sense now. Got to plenty to think about, but I guess like you said the golden rule for now is to keep things as...

So assuming the same databases A,B,C,D and E.

If I could set up 3 nodes, 2 active 1 passive, then I could spread the databases over the two instances.

*although, pointed noted...

Hi thank you both for the response.

It makes sense now, it is as you put it, effectively 2 active clusters, sharing a passive box. Where I was thinking of...

No, your right it is a quick solution and meets my needs.

I'll stick with it, but I was just wondering if it was possible to do it with just a...

Sorry, I'm being a clown, I skimmed over the article to quickly.

I see now the usage of the replace, however this is done in a while loop.

I was wondering...

Hi Chris,

Thanks for that, I've had a look at that. Is it not possible to do this using a replace then?

Hi,

it basically means the value is NOT IN the range.

I.E

ColumnA IS NOT IN (1,2,3)

This would mean ColumnA is not equal to either 1,2 or 3.

http://msdn.microsoft.com/en-us/library/ms177682.aspx

Hope this helps.

Figured it out.

The connection was being made using the correctly restricted account, however there was another user group in the database (not on the server logins) that was allowing access....