I have another question regarding the same example. In addition to comma seperated products, I would like to select the number of products under each category, just the number. For...

I would like to do it in a single query, if its possible.

Thank you. I think I will keep it in the front end.

Thank you. I will try that.

Price Paid is the price from the orderproducts table. And Refund Issued is the total refund.

I followed the steps from this kb. http://support.microsoft.com/kb/224071/EN-US/. I was able to reattach all the user databases, model and msdb database. When I tried to detach and attach...

May be you can create a temp table @keywords with an id column and an accessfield column. Split the comma seperated accessfield string from the keywordtest table and insert...

I get timeout expired error once in a while from random stored procedures. Its been happening for a long time now. Could not figure out whats causing it.

Thank you. I will use the ISINTEGER function.

I am sorry, the sample code should be like this

IF ISNUMERIC('009282d2') = 1

SELECT 'It is a number'

And what happens if the t2 block is replaced with a seperate stored procedure and an error occurs inside the stored procedure?

CREATE PROCEDURE [dbo].[proc1]

AS

BEGIN TRAN t1

UPDATE table1 SET key =...

Thanks. Didn't know t-sql has case statements.

Like Ian mentioned, they want to be able to use quotes, return variations of the word, etc, just like a google search or close to it.

Thanks very much.

Hi,

What you suggested, it will have all the registrations followed by all the cancellations. I would like to have the registrations and cancellations number side by side. It will be...