Thank you for the link I did have a look at GeoNames but they seem to be giving a dump for cities - (Categorized based on city population), people and...

Hi I generally use concatenate function in excel to see how my insert statement builds up.

Hope this solves your problem.

=CONCATENATE("INSERT INTO stk_location "," (item_Code, Whouse_Code)"," Values","( '",J$3,"' ,","'","VN09","'"," )")

it is a simple insert statement

Insert into table

(

responsestring

)

values

(

@responsestring

)

BTW responsestring is declared as varchar(max)

For now I will go with the work around. Probably there is a bug somewhere that I...

Thanks Koen and Phil for your response.

I have implemented the workaround of replace string if it finds ascii(0).

However I was curious what was inserting this additional character. I checked...

Thanks everyone for your response.

I was of the opinion that adding pseduo records may result in unnecessary maintenance especially during reruns and data correction.

The psuedo records are constructed...

TommyH,

Thanks for your response and solution. I will test your solution with more data on the @x table and see if Cross Apply effects the performance.

Cheers

Aparna

I would have been fighting for Indian Independence.

There is nothing like liberty and freedom in this world.

Thanks for reminding me the issues with dynamic SQL.

I have learnt a new solution to use system views for rowcounts.

Thanks again..

You can pass table name. You can use dynamic sql in the stored procedure.

CREATE PROCEDURE test

@table_name varchar(50)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with...

Hi,

Not quite understand your requirement, but is this what you are trying to do:

[Code]

declare @numeric1 int

declare @numeric2 int

set @numeric1=3688992

set @numeric2 = 456

declare @x table

(

string varchar(255)

)

insert into @x(string)

select

'my invoice number...

Hi,

You can probably look at the system views (sys.columns). I have constructed a query using sys.columns. Hope this helps.

select o.object_id,

o.name,

t.name,

c.*

from sys.columns c

join

sys.objects o

on o.object_id = c.object_id

join

sys.types t

on t.system_type_id = c.system_type_id

The issue with the linked server was the windows authentication. When I changed the linked server's properties to use:

Be made using the security context using Remote Logn and password instead...

I googled without much luck.

If Anybody can provide some pointers as to what could be causing this issue

Rozema thanks for the pointers.

There is another article in sqlservercentral that talks about setting contexts and capturing the loggedinusers credentials (Mainly used for triggers). Hope this might help you.

I will test the suggestions posted by you and let you know what I think (Currently I am held up with some strict deadlines).

Just wondering if anyone else ran...