Here is an example to get rid of everything after the first "." and before the third "\". You provided very little info, so I don't know if that's...

Again, you're making this way harder than it needs to be. Using triggers to hard code the table when you can simply use the capabilities of T-SQL to query...

Also, something to consider if you have a lot of servers would be to keep your updated list in the 'Registered Servers' tab. I started doing that with my...

shane94 (5/7/2010)

---

so I'll have to see if there's a way to inject Max(ClientNum) + 1 into the generated SQL but I'm thinking there isn't

I'll probably just use an after insert...

What you're describing is bad design ... it's not normalized and it's going to be confusing and have performance issues for the life of the database. You should have...

Generally it's bad form to use *. Specify the column names so you don't end up having issues in the future.

This article[/url] indicates that the bug with SQL Server 2000 that required the Outlook client to be installed for the missing dll's was corrected with Service Pack 1.

It's been years...

I don't see a problem with the IsActive bit field. Why do you think that's where the problem lies and how sure are you of that?

It's a little hard...

Sounds like you just want to use an IDENTITY. Take a look in Books Online.

declare @t_temp table

(

[lngReservationId] [int] IDENTITY(1000,1) NOT NULL PRIMARY KEY,

[intRoom] [nvarchar](15) NOT NULL,

[dteArrivalDate] [datetime] NOT NULL,

[dteDepartureDate] [datetime] NULL

)

insert into @t_temp (intRoom, dteArrivalDate, dteDepartureDate)

select 2501, '4/15/10', '4/25/10' union

select 2501, '4/25/10', '4/25/10' union

select...

Lynn Pettis (4/26/2010)

---

Why would we want to do...

He said he wanted a

but yes, without that stipulation the CTE would be plenty easy.

SELECT t1.*,

t2.SOMEVALUE

FROM

(SELECT KEY1,

MAX(VAL1) MAX1,

SUM(VAL2) SUM2

FROM @TableVar

GROUP BY KEY1) t1

JOIN @TableVar t2

ON t2.Key1 = t1.Key1 and

t2.VAL1 = t1.MAX1

Be easier to use a true subquery though IMO.

Isn't that just a parse error that simply won't allow it to run because it's a non-existent object being referenced?

You can get around it with dynamic sql, but there may...

How many IO channels do you have?

What kind of database are you expecting to run (OLTP/OLAP/hybrid)?

How many transactions per second?

How critical is your data ... how many seconds/minutes/hours can you...