I want to populate the pdf form using large sql data

Any way to convert the above vb code to sql

Thanks your code works . But my notes field is type ntext when i run the code i get

The data types ntext and char are incompatible in the add operator.

if...

Any Luck ?

The realtionship is defined using three fields RefModule, RefNum, RefLine.

The RefModule field is in all the tables , thats how it determines which table to look for.

FYI :

The actual...

Here is the Data Defination and Data and how the tree should look like. What format the stored procedure should give the output data so it can be used in...

Its going to be ondemand . I am going to create a stored procedure for it and the select statement will have a where clause (Parameters).

I am guessing that what you have is just the file name stored in the database and you want to make a physical copy of the existing file in the...

That was great. Worked out perfect.

SQL 2005. Our Database Server is 2005 . Is there a way to use -d option with 2005 server ?

got error

output

bcp: unknown option d

usage: bcp {dbtable | query} {in | out | queryout | format} datafile

[-m maxerrors] ...

Thanks it does work with the solution.

But we have hundred's of procedure provided by our ERP vendor which we can not change technically.

Is there a work arounnd for

IF OBJECT_ID(N'extgen_ki_TestLoop1')...

There is a code in the calling procedure which checks if object 'dbo.EXTGEN_InitSessionContextSp' exists. And it does not exist.

IF OBJECT_ID(N'dbo.EXTGEN_InitSessionContextSp') IS NOT NULL

BEGIN

...

Here is the small example i created and gives me same results.

Here i am running procedure ki_TestLoop2 which is calling ki_TestLoop1.

In ki_TestLoop1 i have a code which checks...

i get the desired output.

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

(12932 row(s) affected)

then all the records are displayed.