Lowell (12/16/2011)

---

at least for US data, Here's a copy of one of mine; 42K zip codes, mapped to Cty/County/State;

CITYDATA_INSERTS.txt

populating city/county/state if you know the zip is no problem, but

if...

If you are looking to delete (or truncate) all tables take a look at the undocumented stored procedure "sp_MSforeachtable". You should be able to plug that into your search engine...

You altered the column from varchar to int. 😛

You're welcome. Glad that worked for you.

--edit--

Of course a recursive cte is still row by row processing, it is just done behind the scenes. I don't think in your your...

Thanks for the ddl and such. You were so close!!! Just need to add the RootID to the original query so you can group by it at the end.

;WITH cte...

integritec (12/14/2011)

---

Agreed on SQL injection - needs to be guarded against. Doesn't make the solution bad - you just have to sanitise your inputs.

As to doing 10 JOINs - maybe...

Set based processing is paradigm shift in your thinking. You...

integritec (12/14/2011)

---

Sure, my solution isn't necessarily the best by any...

omalie24 (12/14/2011)

---

HEY....IT WORKS...BUT I NEEDED IT TO CYCLE THROUGH MULTIPLE ROWS OF DATA WHICH HAS DIFFERENT SERIAL NUMBERS.....I KINDA FIXED IT.....I KNOW U WOULDNT LIKE THIS BUT I WRAPPED...

Thanks for the ddl and sample data. It is totally unclear what your data is and what you are trying to do.

My problem is how will I get the query...

MothInTheMachine (12/13/2011)

---

Greetz!

I'm trying to use a uniqueidentifier in a where clause and I've been unable to get past this error

(Conversion failed when converting from a character string to uniqueidentifier.).

select...

Looking at this again I don't think between is your answer. The confusion lies in the way you posted this. It is very unclear what your table looks like, the...

between

Details...ddl (create table scripts), sample...

Learner1 (12/13/2011)

---

yeah the mainId is actually hard coded by me...

I think this is what I have to do but instead of @ChildID I will have to use Cursor to fetch...