Heh... personally, I'm glad banks are over-cautious with changes to software.

select EMPLNO,[Full Name],[CCNAME],[CC] from HREMP where [Full Name] like '%" & REPLACE(strS,'''','''''') & "%' and [CC] like '01032%' and (EMPSTATUS <> 90 or EMPSTATUS is null) order by [Full NAME];"

Depends on what the maintenance plan is doing... DBCC REINDEX, can crush performance on very large tables that have large indexes or a CLUSTERED index that doesn't follow a chronilogical...

Vivien Xing (11/21/2007)

---

This is a question I was being asked during an interview a couple years ago. I think it is a pretty good open question. I keep...

Perfect...

EDIT: Actually, create a database on the new server with the same name as the database you're linking to on the old server. Create views which have the same name...

Why not just a Tally table driven split function, then?

Heh! If that's true, guess I need to give you a lawnmower...

Joe Contreras (11/20/2007)

---

Thanks for the information. I just found out that my boss is leaving the company and he's the only one that supports and buys into my design...

Heh... well said Robert and ALI...

Yeup... that's kinda the way I figure it but we're only guessing...

The bad part here is a huge opportunity was missed to help the users...

No, no... not a problem, Ramesh. And, the RowNumber Over Partition to...

Allen,

I'm not 100% sure because I don't have 2k5, but I don't believe that Ramesh's wonderfully easy to read code is going to do the trick for you because it...

Jim,

Is this in reference to the table variable function you created that calls itself?

I don't know what Celko's "Packing Join" is, but I think you're gonna need another column like a date/time or and IDENTITY column even if you were to use a...

"REVERSE" is pretty expensive performance-wise... PARSENAME still does the trick even with the modified list...

CREATE TABLE dbo.Hits (RowNum INT IDENTITY(1,1) PRIMARY KEY, Site VARCHAR(100))

INSERT INTO dbo.Hits (Site)

SELECT 'abc.support.microsoft.com' UNION ALL

SELECT...