Thank you Suresh.B for catching the other possible area.

[Quote]if(@history)<>''

Begin[/Quote]

Since @history is declared as varchar, the Not Equal To operator '<>' is having trouble evaluating it.

Jeff Moden (6/21/2008)

---

karthikeyan (6/20/2008)

---

sqldba,

first of all try yourself, otherwise you can't learn anything new. Try to write your own SP. Becuase it is a basic one, without knowing how to...

SQLDBA: You can use the substring function and the semicolon delimiter to "cut up" the string and read the values into an array.

Karthik: With all due respect, sometimes the tone...

Runs fine on mine with Master DB.

Although you have stated you do not wish to go through intermediate tables, the most suitable solution for you would be to select distinct rows from TAB into a TEMP...

Thanks, Matt for the nudge. I think I was one of the first members to read that article by Jeff in January but to be entirely honest, it did not...

Thanks, Tom; it looks like it is going to be a horrible challenge. But I would still be grateful to be shown how to code the first part of the...

[Quote]THood:

So say the moxt recent 30 buns cost 3 each, and the 30 before that cost 2. Total cost for all these is 30x3 + 30x2 = 150.

But you've only...

Maybe a script of the tables in question will help me get some answers:

[Code]CREATE TABLE [dbo].[MENU] (

[FOODID] [numeric](10, 0) NOT NULL ,

[DESC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

[COST] [numeric](15,...

Thanks again, Jo, I had a look at it.

I am still waiting for help on how to implement error handling in SQL Server 2000 and how to intercept those errors in VB6.

Please take a look at this:

Thank you for trying to help, Jo, but, no offence intended, I must confess that I am none the wiser after reading your post.

Asking as a Newbie, with no offence intended, wouldn't a function serve a better purpose to do the same thing?