The same thing was running fine before.So i doubt its got anything to do with the code

Anyways here's the code

declare @mail_recepients varchar(max)

set @mail_recepients = 'vihitha.koyott@geodesic.com'

declare @profile sysname

set @profile =...

Hi,

Thanks a lot for the reply.

I tried using the above solution given by you.

But still not working 🙁

Phew !!! pls provide a sample code..can't help u much w/o that.

Btw the above code will work even if the number of columns are not equal.

What i meant was :

Eg...

The above code will work for that.

only u'll have to declare the temporary table variable with number of columns = maximum number of columns returned by ur three tables.

You'll get...

Hi,

Is you second procedure returning same number of columns for all the three tables ?

I have provided an example over here assuming that Storedprocedure B returns equal number of columns...

Hi,

1. In your procedure @p1 is not assigned any value so no matter what function you call,it'll always return a null...

(set @p1 = dbo.AddFltAmount(@p1,@Flt_Amount))

2.There is a better way than using...

You are not moving the cursor ahead.

WHILE (@@FETCH_STATUS=0)

BEGIN

if @TransCode='TR001'

BEGIN

SET @p1 = dbo.AddFltAmount(@p1,@Flt_Amount) --here where i am getting error

END

FETCH NEXT FROM Cur_Flt_Amt INTO @TransCode,...

Hi,

Do you mean that your query should work(give the same result) even if the string contains white spaces in it ??

If so then you can do this :

declare @order_branchcode varchar(50)

set...

Hi,

Do you want a query output in the above format or you want to populate your table(3rd column) ?

I created a table ABC with 2 columns .

col1 col2

abc1

abc2

abc3

fgh1

dft1

fgh2

abc4

Executed the...

Had your table been normalised ,u wouldn't have run into this problem.

One way that i can think of is by using a cursor on your table.

Create a cursor on your...

Hi,

How can u insert a NULL value in a NOT NULL column {BILL_ZIP} ??

If the NULL constraint was removed on the last column,is this the solution u require ?

select [ORD_NBR]...

Hi ,

You may synchronize the the two databases using any synchronizing tools.

I use the xSQL compare tool for data synchronization between two similar database.

Dunno any query as such for doing...

You may try using the openrowset() function .

http://technet.microsoft.com/en-us/library/ms190312.aspx

An example is provided in the blog below:

http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/

Thanks a lot !!