if this did not work

WHERE c.OrderDate between '2004/11/11' and '2004/11/30'

try this

WHERE c.OrderDate between '2004-11-11' and '2004-11-30'

goto to the control panel on the reporting services server and to the regional and language options. apply the format that you want

change the where part to this

WHERE c.OrderDate between '2004/11/11' and '2004/11/30'

it would help us all if your repond to the forum so that we know if something worked

it would also...

needless to say that know your stuff very well because the test is very [should i say] trying.

and you need to know different angles of attack for stated problems

i use IDENT_CURRENT('table_name') because i get the last identity value generated for a specific table in any session and any scope

i did use the BOL syntaxt and it worked

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\book1.xls', [Sheet1$])

the problem with the first query you are doubting is that it has single quotes around the...

if you look at BOL both of the solutions should work

Syntax

OPENROWSET ( 'provider_name'

, { 'datasource' ; 'user_id' ; 'password'

...

--using the dateformat yyyy-mm-dd

select * from class cc

where cc.number in

(

select aa.number from

class aa

full outer join

class bb on aa.number = bb.number and ABS(datediff(dd,aa.date, bb.date))< 365

where bb.date between '2005-7-1' and '2006-6-30'...

the debate is mainly a perfomance issue thing.when i switched a cursor based process to set based process it wittled the processing time by a very big margin.

use cursors...

i don't know if this will help

http://msdn.microsoft.com/msdnmag/issues/06/01/SecurityBriefs/default.aspx

stored procs are my prefered method. and if i were you i would desist from using select * and actually include the columns that i want to see in the...

but if you make it clear what you really want, we can have a look at it

i think a work around is to include the parameters in a select statement in a stored proc i presume and then just display like you would normally do other...

it gets it from the reports server

goto

http://msdn2.microsoft.com/en-us/library/ms251693.aspx

I tried to copied your stored proc and tested on my server. I did not get any error when I invoked the job by running it from enterprise manager.

If you...