Viewing 15 posts - 3,181 through 3,195 (of 9,707 total)
Oh good grief. I'm going to go bury my head in the sand now...
Thanks, David.
April 30, 2014 at 5:45 am
I have tried a couple of different versions of this and keep coming up with "ReadToEnd is not a member of System.IO.Stream". Google can't seem to find anything with that...
April 30, 2014 at 5:15 am
David Burrows (4/28/2014)
Brandie Tarvin (4/28/2014)
Anyone know what this...
April 28, 2014 at 12:26 pm
As I continue troubleshooting this I keep finding interesting things. Now I'm getting a message box back with this response (see attached picture).
Anyone know what this means?
April 28, 2014 at 9:34 am
Brandie Tarvin (4/25/2014)
A WebException has been caught.System.UriFormatException: Invalid URI: The URI scheme is not valid.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind...
April 28, 2014 at 7:21 am
ty 54262 (4/28/2014)
this command with the repair switch and then the repair allow data loss worked perfectly.
Ouch. You should be leery of ever using the "allow data loss" switch with...
April 28, 2014 at 4:39 am
Jeff Moden (4/25/2014)
Brandie Tarvin (4/25/2014)
--You only need one DECLARE statement
-- and you can assign the values within that statement too.
[font="Arial Black"]-- Saves on typing[/font]
"Sure you are? Dark Side...
April 28, 2014 at 4:22 am
RazorbackDBA (4/25/2014)
April 28, 2014 at 4:19 am
homebrew01 (4/25/2014)
Wouldn't the LEFT OUTER JOIN only work for new records, not changed records ?
Depends on what WHERE clause filters you use. I've done it before where I join on...
April 28, 2014 at 4:18 am
Troubleshooting I/O issues depends on the DBA. Everyone does the same set of checks, but different people do it in different orders. Me, I prefer to verify SQL Server first....
April 28, 2014 at 4:15 am
Trying Cadavre's script I get the following error:
A WebException has been caught.System.UriFormatException: Invalid URI: The URI scheme is not valid.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)
...
April 25, 2014 at 12:29 pm
Ville-Pekka Vahteala (4/25/2014)
Brandie Tarvin (4/25/2014)
April 25, 2014 at 11:28 am
Cadavre (4/25/2014)
April 25, 2014 at 11:27 am
If you throw a DISTINCT into the code I provided, it solves your problem.
But as Lynn said, we can't provide you with a definite answer without some DDL, sample data,...
April 25, 2014 at 10:53 am
The misconception would be mine, then. This is sample code supplied to me by the vendor receiving the file. It seems pretty generic and the person who gave it to...
April 25, 2014 at 10:49 am
Viewing 15 posts - 3,181 through 3,195 (of 9,707 total)