Thanks for your solution.

But it does not works with string logical expression like below

'FirstName=FirstName AND LastName=LastName'

Please provide me a solution that works with with varchar values as well...

without adding single...

But there is no need to add a from clause as it was working fine.

See the code below:

--my table payment_details structure is

DECLARE @payment_details TABLE

(

payment_id ...

Dear Friend,

Your Sql query seems good, Try to fill dataset like below:

Update Your VB code::

SqlDataAdapter da=new SqlDataAdapter("<Query here>",Connection Object);

DataSet ds;

da.fill(ds.Tables[0]);

may this will help you..

Thanks alot!!

Thanks Gail!!

Thanks Lowell!!

Agreed, i was doing something wrong but use of CLR is the best option.

Lowell, given link was too much helpful.

Thanks a lot!:-)

I Want to store image as in image datatype with compression of byte using a function

like fn_compress(@imagebyte image) also need to decompress the same.

could you help me to create...

Hi Friend,

But I am working on SQL Azure and in that portal i am not able to generate script

it shows following error

TITLE: Microsoft SQL Server Management Studio

------------------------------

Script failed for Server...

Hi Friend,

Thank You Sooooooooo Much...:-)

Dear friend,

plz tell me how to drop primary key 'IND_HIM8' on table City_Master CITY_ID Column..

Plz send me Script to drop primary key..

Thanks

but union works 40 times i test it..

run the statement...

declare @i int

set @i=0

declare @v-2 varchar(max)

set @v-2=''

while (@i<40)

begin

if (@i=39)

begin

set @v-2=@v+'select '+cast(@i as varchar)

break

end

else

set

Thanks m allmost satisfied with you..:-)

Hello Dear,

I am using tool SSMA But it takes a lots of time and consuming lots of space

in comparision to oracle.is there any other tool to migrate our oracle data...

Your query is perfect and I got the perfect result..

But How I am not getting:

You have written that

X.abc=Y.abc(+) (side with nulls) => X LEFT JOIN Y ON X.ABC=Y.ABC

X.abc(+)=Y.abc => X...

Dear All Friends,

I have found a tool names "SQL SERVER MIGRATION ASSITENCE FOR ORACLE" that completely resolved my problem..

Thanks 4 sharing my problem !!:-)

:crazy: ... That is what I want to convey...

Plz send me sample sql statement about this...