Viewing 15 posts - 1 through 15 (of 64 total)
Your ingenious method returns the dataset I need.. but doesn't allow me to update any data in the resulting dataset. What info can I provide to help with...
January 17, 2014 at 12:36 pm
If I want to use another query in MSAccess as the target of the code you sent instead of pointing it at a table in the database... (query name "remaining".....
January 17, 2014 at 12:09 pm
Just ran this on a WIN2K Sql SERVER providing the UNC path to the backup shared network drivespace which I verified I have access to and received this error...
Server: Msg...
March 25, 2011 at 12:25 pm
There is no .net or any other app being used against the database yet.. I only have the tables right now and am using SQL2000 query analyzer or SQLK25 query...
March 18, 2011 at 10:38 am
Thanks for the advice... I've tried periodicially to find an add-on or tool to do just what you recommend here.. a file copy with error checking and delete of the...
March 12, 2011 at 7:13 pm
The output should be the record in the first line of the sampledata.. because it contains one of the keywords, and the date is yesterday flagging it as the...
January 26, 2011 at 7:45 am
I'm running SQL2005, and yes.. you hit the nail on the head.. the bottom line question... how to return a small set of the full table #URLTbl (ideally the records...
January 26, 2011 at 7:43 am
Thanks... .. data posted in original message per your request. The first line of the #URLTbl contains the "today" record.. the other records are older. I...
January 25, 2011 at 10:15 pm
Forgot to quote the source code when I replied to you.. but when I run this I get the error below...
Msg 536, Level 16, State 5, Line 1
Invalid length parameter...
January 20, 2011 at 9:45 am
Just got back to work where I could try this, and I get the error
Msg 536, Level 16, State 5, Line 1
Invalid length parameter passed to the SUBSTRING function.
When I...
January 18, 2011 at 3:59 pm
Only 60 million records as of today ... should be fine eh?
January 13, 2011 at 11:34 pm
Yes... I am using Enterprise edition.. so I'll look at the indexed view suggestion.. and as this is the output from a webfilter, there are HTTPS entries, but we block...
January 13, 2011 at 1:06 pm
Thanks.. it seems to work and returns results, but upon completion also displays the error message...
Msg 536, Level 16, State 5, Line 1
Invalid length parameter passed to the SUBSTRING function.
Elliott...
January 13, 2011 at 10:23 am
Viewing 15 posts - 1 through 15 (of 64 total)