yes i did change it to 0 , but can you explain me whats going on here, we run this report every moth and never had this problem but y...

ya i found it teh remote query timeout is 600

i didnt understand the path

SSMS-->prop-->connections-->remote qery timeout--> wats the value??

can you be more specific

i think the value is 0

Hi,

i am getting this error when i run a stored pro

i just updated the whole query this may help in fixing it

i just updated the whole query this may help in fixing it

i keep getting this error

i keep getting this error

should i use the same data parameters

so what sould i replace with where claus, there should be some clouse right

if yes , what is your approach

here are the data parameters

STARTDATE =CDate("01/01/" + Cstr(Year(Today)))

ENDDATE =Today

i tried using select but it didnt work i didnt get what you meen actualy

the code i have now gives me few items but i want all the items