Thanks Rayan,

Thanks very much for help.

Regards,

Swapnil.

I think you are not getting my quetion.

My question is, How to define same parameter as input and output both.

for ex. Suppose I have a '@num int' parameter in my...

Friend, I had tried it but could not get the answer, that is why I have post question over here. If you know the answer please post it for me.

Thanks all of you,

Thanks for helping me out!

Regards,

Swapnil.

Hi Kenneth,

I have tried the way Venkat posted, and also I have change the columns names according to my table in database, but still it is giving me error of...

Yes I have tried the example posted by Venkat. But it is still giving me error. Following is the code posted by Venakat

Select b.Topic, c.CompanyName, cast(a.Rating as int) as 'Cumulative...

Hi Venkat,

I have tried this but it is giving me following error:

Column 'c.Company' is invalid in the select list because it is not contained in either an aggregate function or...

Hi,

Following is the sample data :

1. Company Table

CompanyID  CompanyName

   1                   Cipla

   2                   Dr. Reddy's

   3                   Infosys

2. Country Table

CountryID  CountryName

    1                   India

    2                   Japan

    3                   Singapore

3. Topic Table

TopicID     ProjectID        Topic

  ...

Thanks Karl Grambow

But there are 15 columns so I have to write all 15 column names. Is there any way that we don't need to write all column names.

Swapnil.

Thanks Ray,

But I am using vb.net windo application as my frontend. Please tell how to insert image in SQL table using vb.net.