Hi I found what the problem is

if i change the settings of my display from 1280*1024 pixels to 1280*960 pixels then horizontal scroll bar doesn't appear but it works...

Thank u Raunak. Perfect Answer 🙂

Thank u man. I will check with those links and revert you

Hi all,

I found the answer in some blog and here it is

"My answer was always "Set RetainSameConnection=TRUE on the connection manager and set DelayValidation=TRUE on all tasks that use the...

Sorry no messages it just turns out to red colour. 🙂

ssis task execute and then fails

Thank u coldcoffee and kingston

It worked fine. Such a simple mistake 🙂

Thank u both

sachin

Thank u coldcoffee. I will try with your first logic as it seems to be simple and smaller.

With Regards

sachin

declare @i int

set @i = 1984

while(@i <= year(getdate()))

begin

select @i

set @i = @i + 1

end

I have used the above query

Thank u all guys for your help.

I will try out your logic and revert back.

Thanks a lot. 🙂

Sachin

Hi,

I want to match supervisor id with employee id itself

Hi

Phil Parkin and da-zero

May b your second logic will be more effective than mine.

Thank you for solving my issues.

This is second time you both helping me...

Hi

All,

I used the below query and its working fine.

SELECT ID, SiteName, DRCNum, TypeID, Point, [Time], CardNumber, FormatName

FROM ...

Hi,

Phil Parkin, da-zero, skcadavre

Your query works fine but since Time column has datetime value if i use '=' operator it fetches only rows having time...

Thank u Elliott. It is Really good logic.

Thank u very much for reply. 🙂

Sachin