Philip Horan (11/27/2007)

---

Tremendous response, many thanks.

I was leaning towards a 2 node cluster (as SQL 2005 standard supports).

I have requested a SQL consultant configure due to my inexperience,...

alain_smithers (11/27/2007)If we're talking about referencing "lookup" or "type" tables, where the number of records is in the tens or even hundreds, DRI should be a no brainer. On the...

If you were on 2005, I'd suggest the EXCEPT clause:

select * from 1

EXCEPT

select * from 2

of course - you're going to have to do...

Larry Huisingh (11/27/2007)

---

Maybe you could comment on how to set off the code snippets with formatting like you used that allows scrolling. I haven't posted code on this forum...

Jeff Moden (11/27/2007)

---

Doug Wittich (11/27/2007)

---

My pet peeve besides those given already: Poor choice of subject. So many "Newbie needs help" and "help me" threads abound. I'd much rather see a...

Michael Earl (11/27/2007)

Clustering is generally more expensive. The OS and SQL licensing requirements are higher. Mirroring allows you to use a lesser server for your failover server (if...

TheSQLGuru (11/26/2007)

---

I had wondered about that too. Bet Itzik has something up his immense sleeve to super-charge this particular puzzle. 🙂

Hey, what the heck are you doing playing on...

Jeff Moden (11/22/2007)

---

Output should be:

'80 98439 9991 997 -50.000' should be Type = 80 Code = 98439

'0000058916 00000074000039708' should be Type = NULL Code = NULL

'0000058916 00000074000039708' should...

...to which...

Jeff Moden (11/22/2007)

---

Man, you're on a role with all these questions... and most of them are so general in nature that it's not possible to give a decent answer. ...

Agreed. while it might be okay to occasionally shrink the log files if something...

.NET syntax for replace is

<name of string object>.REPLACE("old value", "new value")

So you want

Dim strS As String

strS = txtName.Text.Trim.ToUpper

strS.Replace("'", "''")

pvt, unpvt, p and p2 are (admittedly) ugly, but short, aliases for the various sub-queries that syntax creates. It does make it a bit harder to read, but I...

Jeff Moden (11/26/2007)

---

Both... you cannot...

if you replace this line in the ORIGINAL code I posted

SELECT @SQLBody = ISNULL(@SQLBody+'],[','[') +rtrim(convert(varchar,[run date],112))

FROM testsvcs --also replace here with your table name

with....

SELECT @SQLBody = ISNULL(@SQLBody+'],[','[') +rtrim(convert(varchar,[run...