GilaMonster (6/8/2009)

---

And...

Lowell (6/8/2009)

---

ok, it looks like two wrongs make a right...NOT combined with [^0-9] ALMOST looks like it works:

CREATE RULE [dbo].[NumericCharsOnly]

AS

@value NOT LIKE '%[^0-9,-+]%'

but the - and + ,...

First, can't cut, paste, and execute the...

Sounds like SQL Server went down hard initially. This means it has to recover the databases to a consistant state. have the database recoveries completed, or are they...

Tara (6/8/2009)

---

something like this where in all the Code column in one server is char(5) and the other is varchar(5)

select h3.code1,h3.code2,h3.code3,h6.code1,h6.code2,h6.code3

from hock3.obever.emp h3 inner join

hock6.obever.emp h6

where h3.code1h6.code1...

A mirror won't do this for you even if you did have a separate server to use, as you can't access the data on a mirror database directly.

Looks like replication...

Could you provide us with the DDL for the tables, sample data for the tables (in a readily consummable format that we can cut, paste, and execute in SSMS), the...

Eralper (6/8/2009)

---

Yes Recursive queries add a lot easiness to the t-sql development.

I had built a recursive split function, a numbers table, etc.

Or you can query on hierarchical data on a...

And send me screaming back to my...

DBASkippack (6/8/2009)

---

Is it possible to update more than 1 column from a 3 way table join?

the following update works when I remove , Col_D = S.Col_D

How can I accomplish...

Oh, great, our "PhD Candidate". Could have warned us on that one, Gail.

You can use Profiler to create the necessary sql commands to generate a server side trace that will not impact performance as much as a profiler trace. Since the...

Then perhaps...

But if he read the BOL entry for RESTORE FILELISTONLY, why ask the question? :w00t:

<>

Oh No. I can't read Books Online. SQL Gurus, tell me the answer please.