Thank you John, that looks very promising.

Steve

Not used table variables before, but they look good to me!

DECLARE @item TABLE (

itm_serial int NOT NULL IDENTITY(5000,1),

itm_item varchar(43) NOT NULL,

itm_desc varchar(100) NOT NULL)

INSERT INTO @item

SELECT itm_item, itm_desc

FROM (SELECT itm_item,...

Something like that, but for SQL 2000 🙂

CREATE TABLE #testitem (

itm_item varchar(43) NOT NULL,

itm_desc varchar(100) NOT NULL,

wsd_quantity int NOT NULL)

INSERT INTO #testitem

SELECT 'CHCWPSU10DMX','Chroma-Q Color Web Power Supply Unit For 160...

Maybe I am doing this wrong, but here is my test:

DECLARE @serverup int

SELECT @serverup = (SELECT TOP 1 1 FROM ACET.master.dbo.sysdatabases)

IF @@ERROR <> 0 SELECT @serverup = 0

IF @serverup =...

I have been using a similar script on a website I manage, but it needs an overhaul, maybe this is something you could bare in my mind for your script.

The...

GA Programmer (2/10/2009)

---

Wow.

In your editorial, you stated " but as I reread the second paragraph it struck me that this person is upset with the apparent decline of western...

Greed is what I blame it on. If there weren't greedy people wanting to get something for nothing then we wouldn't have people/companies being sued (sp?) over the smallest incidents....

I think I have it:

SELECT U.pbu_manid, dbo.tblManufacturer.web_manufacturer, U.pbu_div, U.pbu_url

FROM dbo.tblPricebookUpdates U INNER JOIN

...

Hi Seth,

That is making sense now, thank you for explaining it.

Now I just need to get SSMS to create insert data sql for to me to post sample data...

Seth, thank you, I did think you were nuts to begin with but I saw your error and was about to correct it. Due to different collations I added the...

Chris Morris (11/18/2008)

---

Dooza (11/18/2008)

---

We have a Hob Goblin too, its where I usually end up at the end of the night as its always open late and doesn't attract your...

We have a Hob Goblin too, its where I usually end up at the end of the night as its always open late and doesn't attract your usual townies. I...

Which pub in Reading? I visit every now and then, as I only live in High Wycombe.

Its nice seeing a post turn off-topic without being shut down immediately.

Jeff Moden (11/18/2008)

---

As a side bar, I just can't imagine someone doing that to a whole server. I can understand building some columns in a table as being case...