Viewing 15 posts - 736 through 750 (of 1,183 total)
Lynn Pettis (11/27/2007)
Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse to water...😎
....You're lucky if...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 11:08 am
Todd Carrier (11/27/2007)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 11:07 am
Don't get me wrong Lynn, I agree with you. I just know how some people will take what you say literally and when it's not in context, it's easy to...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 10:12 am
Lynn Pettis (11/27/2007)
Doesn't make sense to write code that is backward compatible.😎
Watch it Lynn, this one might come back and bite you.... 😉
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 9:45 am
Loner (11/27/2007)
Sometimes it is hard to write a question, I read a question that is a page long...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 7:56 am
My fingers are crossed that people actually read this article!
Maybe get Steve to include something like this in the new user sign-up... 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 27, 2007 at 6:02 am
You probably want to use NOT IN rather than NOT EXISTS
And you can only return ONE field in the subquery for the NOT IN statement.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 26, 2007 at 11:37 am
Or you could download a smaller file from a faster source with fewer traffic from a system using a faster connection on the second Monday of the month. :w00t:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 26, 2007 at 9:51 am
Well, you never mentioned that it has to work on 2000 and 2005.
There may be a better way, but this works, as any database that isn't available will return a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 26, 2007 at 8:14 am
select * from sys.databases where [state] = 0
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 26, 2007 at 7:46 am
ehlinger,
Sorry but I'm going to be off of here until next Monday. It's a holiday weekend here in the US so I'm "checking out" for a few days of...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 21, 2007 at 1:18 pm
I learned it from watching these forums.
It's actually the keyword to parse out object names, and just happens to work with IP addresses.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 21, 2007 at 11:40 am
How about ...
DECLARE @ipList TABLE (ipAddress VARCHAR(15))
INSERT @ipList
SELECT '68.251.41.3' UNION SELECT '10.0.5.112' UNION SELECT '192.168.7.1' UNION SELECT '127.0.0.1'
SELECT
PARSENAME(ipAddress,4) AS firstOctet,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 21, 2007 at 11:25 am
Try this using the sample data you posted.
WITH raw_data
AS (
-- first we wrap a query to return the progressive totals in a...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 21, 2007 at 11:14 am
OK, the code below should get you what you've described.
First we use a correlated sub query to get the cumulative (progress) values and I put that into a CTE (common...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 21, 2007 at 11:00 am
Viewing 15 posts - 736 through 750 (of 1,183 total)