I feel for you Lynn. It's like pulling teeth in there... 🙁

lmu92 (5/6/2010)

---

WayneS (5/5/2010)

---

Yes, it would. Which reminds me... are you writing one based upon that post last year where you...

If anyone would care to comment on this SQL 2008 Upgrade Advisor message, I would really appreciate it!

This might help you somewhat.

You might want to take a look into DDL triggers.

Yes, it would. Which reminds me... are you writing one based upon that post last year where you found something...

lmu92 (5/5/2010)

---

I would rather recommend you to modify the related sp's not to use DATEPART() anymore. Instead of using DATEPART(dw,...) you could use DATEDIFF(dd,'19000101',YourDate)%7. This will ALWAYS return 0 for...

First, thanks for the sample data.

In going with Lynn's suggestion, let's first load this stuff into a temp (aka staging) table.

IF OBJECT_ID('tempdb..#test') IS NOT NULL DROP TABLE...

:blush: it's the dev edition on my work laptop..... we're...

Paul White NZ (5/4/2010)

---

Thanks Wayne, that's very useful! My only remaining question is what versions of SQL Server (engine and SSMS) you are running. I guess they are...

Paul, this question has turned into a very interesting topic.

I also have isqlw / isql for SQL 2000 available,...

Paul White NZ (5/4/2010)

---

My objective would be to get close to Jeff's rocket code performance here, I don't think there's much chance of a win...but hey I am awesome so...

Glad you noticed......

Paul White NZ (5/3/2010)

---

Gianluca Sartori (5/3/2010)

---

I think Paul wants to join the "world's worst procedure" competition... :-P.

I would have put some more BREAK / CONTINUE in it and maybe...

mister.magoo (5/2/2010)

---

Here is a quick example (using WayneS sample code)

declare @test-2 TABLE (RowID int IDENTITY, Data varchar(200))

insert into @test-2

select 'some regular text' UNION ALL

select 'email: <bob.jones@domain.com>' UNION ALL

select 'Tom &...