Jeff Moden (8/21/2011)

---

lance.kentwell (8/21/2011)

---

As it happens I am populating a table with prebuilt info for reporting purposes. It's much faster than forcing users to wait an hour each time...

stewartc-708166 (8/19/2011)

---

Does the following assist:

CREATE TABLE #IPRanges (

IPFrom CHAR(15),

IPTo CHAR(15)

)

BULK INSERT #IPRanges

FROM '\\Server\Share\FileName'

WITH (

FIELDTerminator = ',')

SELECT TOP 20 scr_dim_site.site_name

FROM scr_dim_site

JOIN #IPRanges ON scr_dim_ipaddress.ipaddress >= IPFrom AND scr_dim_ipaddress.ipaddress <= IPTo

WHERE (NOT...

As it happens I am populating a table with prebuilt info for reporting purposes. It's much faster than forcing users to wait an hour each time they want to...

Perfect, works a treat.

Thanks.

stewartc-708166 (8/19/2011)

---

you could consider either using BCP or BULK INSERT to import the flat files into a #Temp table, then use the values from this table as part of your...

Jeff Moden (8/18/2011)

---

I have to admit that I'm confused. How are you reading from a CSV file with that code? Or is that a part of the problem...

OK I think i have it as streamlined as possible. One question however. Is the order of your conidtions important? e.g. there is one condition I could...

Duncan Pryde (5/5/2011)

---

lance.kentwell (5/4/2011)

---

Doh! knew thre would be a catch things cant be that easy. Unfortunately it is a big table. If I use = and put...

Doh! knew thre would be a catch things cant be that easy. Unfortunately it is a big table. If I use = and put the exact wording...

Hallelujah. You're my savior, man. My own personal Jesus Christ.

I was hoping this would work but didnt 🙁

However I dont think I gave all the info. When I said...

Dont worry i know why, its becuase there are some cases where a differnet user had the same IP adderss on that day and they would be 2 distinct matches.

OK I think we are almost there but I had some discrepency. In my original query to find distinact IPs that matched the site kcc.authoria.com I got 479 results.

If...

Thanks I dont care so much if its elegant, just as long a it works 🙂 I'll give it a try. Since im still a newbie I would...

OK let me explain. In query 1 I am looking for IP addresses for entries where (s.site_name LIKE '%kcc.authoria.com%')

The ultimate goal is to get the username that mapps...