Hi Phil,

I am sorry if my question/code created a confusion. I am putting the entire code below. Could you please look at that:

***********************************************************************

DECLARE @db_name VARCHAR(100), @qry VARCHAR(500)

Declare...

• This reply was modified 4 years, 5 months ago by  Steve Jones - SSC Editor.

The problem with this is, it comes out of the cursor and do not continue Fetch statement.

Hi Phil,

Below is my code: @db_name is coming from the cursor which is fetching the db_name from master database.

SET @qry = 'SET NOCOUNT ON Declare @days INT BEGIN TRY select...

Hi Phil,

Thanks. But, it is still showing errors.

Hi Phir,

Thanks for the response. I will try your suggestion.

But, also want to check if there is a way to ignore the errors and stop showing error message?

I have to...

Yes first one worked for me.

Thanks alot for your help.

Thanks.

I will try these.

I am sorry actually it has one-to-many relationship between Sale and Exp.

The main problem I am facing is using group by with update statement.

I hope it make sense to you.

Thanks...

Thanks for your quick response.

Please find my answers:

Which table does the ordertype column live in? Exp

Are you summing the sale column from the sale table, or does Exp have a...

Thanks.

So, please let me the solution for this.

Thanks in advance.

Afreen

For example:

select sum(total) as NetTotal, NetTotal/100 * 3.2 Gross from abc group by a

I want to use the NetToal to calculate the other column