I wouldn't call it a bug as the parser was designed to require the statement prior to WITH to be terminated with a ";" which is why most CTE examples...

Just for readability I prefer the WHERE, but it should also be mentioned that the ON, according to Inside Microsoft SQL server 2005: T-SQL Querying is applied before the WHERE,...

I'm not sure I actually understand what you are asking or trying to do, but the first issue is that your first Print is not within a BEGIN END under...

You really don't need a script task for this. You can do this with a ForEach loop container. You set the Enumerater to Foreach File Enumerator, set the...

For display purposes you can use CONVERT(varchar(15), date, 101 or 1). 101 is 4 digit year, 1 is 2 digit. For datetime, smalldatetime datatypes the format is...

You can specify folder to deploy to. By default it puts in the Project Name.

I've never used the File Watcher task, but couldn't you just schedule the job to run every 1 or 2 minutes? You'd get failures when the job was already...

What you put in the TargetServerURL is NOT the path to the report server. It is the http call you would make to display an ALREADY deployed report. ...

gardenlady (8/27/2008)

---

I forgot to mention (too much multitasking) that I found out this morning that the server we put the solution on, is on 2000, not SQL Server 2005. Could...

Hey Brandie,

You may want to try using the ISO date format (yyyymmdd) when building the date string that way the DATEFORMAT settings don't come into play.

Have you tried...

Are rendering the report on the web (intranet) first or going directly to excel?

How much formatting are you doing in the report?

I'm going to guess, not knowing the internals of...

I don't have anything done, but it shouldn't be too hard using the sys views. The interesting part would be adding the clustered key to non-clustered indexes and then...

I don't know anything about Lawson, but if you could post any errors you may getting when attempting to deploy someone may be able to help you out.

Okay, I am going to jump back into the thread. I was out of the office all day today otherwise I would have jumped in sooner.

Based on what has...

Nah, just cut and paste better.:P