Sorry about that - my brain is in a cloud trying to figure this one out --

How would I write this query? I have thought of using multiple aggregates...

I just tried to do this using a different user in my ODBC and I am getting the same error....

I feel like maybe it is an issue with the hops...

I agree - it must be a permission issue. I am just confused by it.

The SQL Server service is a domain account. It is the same account that...

I am using windows authentication via an AD group.

I need them to be able to read from 4 views, and read write to 2 tables.

Here is the kicker - I...

I also wanted to mention that - I rebuilt the indexes on the database yesterday - and it seemed to run successfully from 3pm until this morning - does that...

Attached are the definitions of the view(s). When I went and looked at the one, it seems that it pulls from 2 others, that at least one of which,...

Thank you for the reply..

The fnOrderDetailsXML takes order detail information as XML and returns this information as a table.

SELECT t.c.value('@GasSiteID','varchar(100)') GasSiteID,

t.c.value('@OrderStatus','int') OrderStatus,

t.c.value('@OrderDetailsID','varchar(100)') OrderDetailsID,

t.c.value('@NetGallons','varchar(100)') NetGallons,

t.c.value('@GrossGallons','varchar(100)') GrossGallons,

t.c.value('@PulledProduct','varchar(100)') PulledProduct,

t.c.value('@DroppedProduct','varchar(100)')...

File is attached - I renamed it to .txt from .xdl.

I was able to open the graph in SSMS - but I am not sure what it is...

@SSCrazy -- when you say the service account - you mean simply - the account the service is running under?

When the robocopy runs, and copies to the file...

Thank you for the reply..

I checked the effective permissions on the source and destination folder - both have full control.

There are only 2 machines involved in this process...

Strange thing...

I agree - I just was not sure about the Web edition.

If we were to get a standard SQL 2k8...

How many licenses would we need.

At the moment - the applications...

Thank you for your reply, I have read a little bit about dynamic SQL and the dangers of SQL Injection - and from what I have read, when using...

Thank you for the replies --

I understand this - about the inability to cache the execution plan - however, in my specific example, I am going to return a maximum...

Exactly,

I actually accomplished what I was trying to do using a variable of type XML.

I basically pass the XML to a inline table function, and include the xml in my...