Viewing 15 posts - 1 through 15 (of 16 total)
You've missed the select statement in scenario 1 after "INSERT INTO Seattle_Police_Department_911_Incident_Response" to put the data back in from the temp table.
Otherwise, interesting read!
November 10, 2016 at 2:24 am
Small correction required - UDFs came in as part of 2000 didn't they?
January 4, 2016 at 2:33 am
Hi,
I have this problem at moment. What do you mean when you say you placed "ORAOLEDB" in the provider string?
I've installed Oracle's Instant Client on my SQL box, and Oracle's...
July 26, 2007 at 2:23 am
Thanks for that - answered my question and very informative, cheers.
Out of interest though, when you say "it doesnt matter if two calls use the same connection if they are...
January 13, 2006 at 9:17 am
Wow. I'm quite surprised about that. I put our extranet together with a different authentication method (obvioulsy, can't use windows authentication across the web!) using a web server and separate...
July 13, 2005 at 10:43 am
No - there is no anonymous access whatsoever. It is disabled. Only Integrated Windows authentication is used.
It seems as if the security details of the person viewing the page is not being...
July 13, 2005 at 8:48 am
Acknowledged.
However, my ideal solution would be something that I can put into excel which I can then annotate with notes. To that end, I would like tyo be able to...
March 22, 2005 at 10:17 am
Acknowledged.
However, my ideal solution would be something that I can put into excel which I can then annotate with notes. To that end, I would like tyo be able to...
March 22, 2005 at 10:17 am
that's what i wanted to know too...
November 5, 2004 at 3:40 am
yeah - i got to this conclusion to. problem is, with that many sub queries it takes a very long time to run. the calls table has about 5000 lines...
August 27, 2004 at 7:32 am
thanks for the quick response!
how about if the first visit is not necessarily number 1? for example, some visits may be deleted which means what I'm actually looking for is...
August 27, 2004 at 7:01 am
yeah i was thinking of putting the second sql server on the LAN, but just wasn't sure of the most secure setup. Do I want to set up linked sql...
July 21, 2004 at 2:00 am
yep - i am going to use (and learn at the same time) .net for subsequent extranet applications. the main reason for sticking with asp is that I'm going to...
June 10, 2004 at 10:38 am
thanx - that's great advice. I think I'll do it you way!
June 10, 2004 at 4:41 am
Viewing 15 posts - 1 through 15 (of 16 total)