Viewing 14 posts - 16 through 29 (of 29 total)
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...
December 9, 2011 at 10:57 am
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...
October 13, 2011 at 11:25 am
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...
October 13, 2011 at 11:06 am
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...
October 7, 2011 at 2:42 pm
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...
September 1, 2011 at 9:22 am
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,...
September 1, 2011 at 8:53 am
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)')...
August 31, 2011 at 1:11 pm
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...
August 31, 2011 at 8:42 am
@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...
February 11, 2011 at 11:13 am
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...
February 11, 2011 at 10:43 am
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...
February 4, 2010 at 7:34 pm
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...
November 3, 2009 at 9:06 am
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...
November 2, 2009 at 6:35 pm
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...
January 28, 2009 at 11:05 pm
Viewing 14 posts - 16 through 29 (of 29 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy