If you want that result in query analyser result pane in the comma delimited format then you can do this by setting these option ...

Tool --> Options --> Results -- > "Result...

Look the artical.

http://msdn2.microsoft.com/en-us/library/ms189799.aspx

In a DELETE, INSERT, or UPDATE trigger, SQL Server does not allow text, ntext, or image column references in the inserted and deleted tables if the compatibility...

Hi,

1) It will not work.

2)It is not a right approach

It would be good to make a user defined function in place of stored proceduer and used it.

Hi,

You are using the return statement to return the value for the OUTPUT varaible @NpFlag... which is creating the problem as return statement only accept the Numeric values.

RETURN SATEMENT is...

select * from My_Table where show_name =  'My hunter''s journal'

If there are some record exists with the SPACE value then surely the answer will be No.

Please can you provide me the sample data u r trying, I don't think that there should be a problem you are mentioning that it will get one row extra.

why are...

No

The Empty String and SPACE are both valid value and there should not be compare as NULL....

Yes, But In this case you will face a problem if the concated string become more than your variable size

select @Body =  @Body + Invoice + ' ' + Contact ...

You can used a RETURN STATEMENT anywhere in your stored procedure to exits from SP.

There is a RAISEERROR statement to generate the error which you want to display like

RAISERROR ('Field not exists .', 16, 1)

You are always welcome.

cheers

Try this...

DECLARE @index SMALLINT,

@MATCH_Supplier_name varchar(500),

@Counter numeric,

@max-2 numeric

-- @sqlstring varchar(500)

SET @Counter = 1

SET @max-2 = (SELECT Max(DTect_Supplier_SRN) FROM SUPPLIER_TABLE_TEST)

WHILE @Counter <@Max

      BEGIN

           SET @MATCH_Supplier_name = (SELECT Match_Supplier_Name FROM SUPPLIER_TABLE_TEST WHERE...

HI,

The inner while should code should be replaced with this and it will work fine for you.

       WHILE @index > = 1

   begin

              SET @MATCH_Supplier_name = CASE

                 WHEN SUBSTRING(@MATCH_Supplier_name, @index,...

You have missed the Begin and End Block for the inner while loop.

You should need to put this after the while and end when you are subtract from the...

Try it.

select

case when count(customer_id) = 1

Then 'only one customer'

else Convert(varchar(15),count(kund_id)) end as no_of_customers,

salesperson_id

from customerdb

group by

salesperson_id

Cheers