In that case, I would really recommend setting up SQL mail. We are sending almost 100 different alerts and infomessages with it (many of them daily), covering just about anything that...

I just read a long and detailed description of how to solve similar problems with query criteria on http://www.sommarskog.se/index.html - I'm almost sure you will find your answer there - articles...

I just re-read your original post and explanation... maybe your only problem is to get the number of people to be contacted into the text? Well, then I would first...

Well, it is rather complicated to explain anything, not knowing your database, but hopefully this will set you on the right track:

CREATE PROCEDURE mail_alert_contact AS

DECLARE @Email Varchar(1024)

EXECUTE GetEmailList 'mail_alert_contact', @Email...

No, I never heard that there would be something like that in SQL Server. IMO this is presentational issue that should be done in the frontend, not through SQL Server. What do you...

I agree that the design is much too complicated, but we know too little about the underlying logic to clearly state what would be the best solution (at least I do)... Why did...

There could be one serious flaw in this query... it depends on one assumption, that was not mentioned: No duplicities and no overlapping in range attribute values. That is, it...

Let's see if this helps... I will use David's SQL and only modify it to exclude the ItemID:

--temp table

create table #temp (attrID int, value varchar(20))

insert into #temp values...

Hmmm... so in the RFloat table there are always 2 records for each item/attribute combination, meaning maximum and minimum value? Or does this table have 2 columns for min and...

It should be possible to do such things with dynamic SQL, however, I don't understand your description well enough to be more specific... Is it so that certain field in...

As far as I know, SQLServer 2000 keeps track of running transactions during a backup, and results of all transactions, committed before the backup ends, are written to the file.

So, if...

Joe,

yes I know how rare. Three years ago we had about 50 titles (out of 25.000) that either had a duplicity in EAN or didn't have EAN at all. Since...

Jon,

I'm working in a company that publishes and distributes books and I can assure you that although it would seem so, ISBN is not always unique. There are rare cases...

Thanks for your replies, I'll try to explain that to the author of the code and get him to modify it so that it uses REPLACE at all vital points (problem...

Hi,

did you copy the SQL from stored procedure? If so, then probably the problem is here:

@qyery = 'Select * from ##DueListing',

Just a typo... qyery instead of query. Hope this helps... if...