Thanks John.

Its perfectly working for me.

I appreciate for your quick response. Thank you so Much...

Regards,

Abhas.

Thanks John,

The data will be exported into flat file. Is it possible to do in using T-SQL only?

Abhas.

Thank you Anthony.

Thanks twin

i resolved the issue. Same your solution worked.

DECLARE @StartDate SMALLDATETIME = '1/11/2016'

declare @tempdat table(repdate smalldatetime)

insert into @tempdat values ('10/26/2015')

insert into @tempdat values ('10/29/2015')

insert into @tempdat values ('11/1/2015')

insert into...

Hi,

I am able to sort this issue. We need to add connection string in tnsnames.ora files.

sample is as below:

TEST =

(DESCRIPTION =

(ADDRESS_LIST =

...

Hi Wanger, Thanks for suggestion.

The format will be same.such case will not happen.

SELECT LEFT(FullName, charindex(' ', FullName) - 1) i am able to find before space.

Lokking now for...

Luis, There will be only one space, 🙂

Thanks.

Thanks Guys.

I want to go with MERGE.

I am thinking first to find max DATE_MODIFIES from target and trying to fetch data greater than DATE_MODIFIES from source and inserting into...

DATE_MODIFIED column is there.

Hi Lowell,

I will use this in crystal report which will display in pdf format.

Thanks

Thanx Lowell,

By the way any other option to do this? i need to display output as test1(checkbox)test2(checkbox). Client want just output,i can use any other methos as well.

Thanks

Abhas.

yes, Iamge is binary value like 0x0000A38C00BEB787....

Thanks,

Abhas

Thannks Lowell

Actually i want to display as test + Checkbox+ test1 +checkbox +test2.

here i have stored checkbox as image in the database. I am displaying as test , test1, test2...

Thanks Phil for your suggestion. I am able to split lastName as Pawar by using below code of stuff.

SUBSTRING(Name,1,FINDSTRING(Name,",",1) - 1)

but not able to identify FirstName as Ramesh. M trying...

Names are well formatted.

Thanks