I recently posted about implimenting a zipcode to city state decoder and ip 2 lookup decoder. Well when i did i ended up createing the ip table which had almost...

Sounds like they're using entity framework and only use the views. Well another option is to create a table and populate it w/ the data u want then select from...

Thanks everyone

anyone have an opinion about http://www.zip-codes.com/ ?

If parametized dynamic sql will result in more cache hits then why would anyone write non parameterized dynamic sql?

picky picky. Your right. That's my shorthand and i really shouldn't assume his column data will never have a -1 as it's value.

just read this "sp_executesql can be used instead of stored procedures to execute a Transact-SQL statement many times when the change in parameter values to the statement is the only...

i use something called sql beautifier. i think it was like 20 dollars. It's very useful and formats sql into a standard readable manner. U can also manip[ulate the way...

or wrap in sinulls

also only the records who need to be update...removed left join

UPDATE t1 SET field1 = t2.field1

FROM Table1 t1 JOIN Table2 t2 ON

t2.id1 = t1.id1

AND t2.id2 = t1.id2...

also only the records who need to be update...removed left join

UPDATE t1 SET field1 = t2.field1

FROM Table1 t1 JOIN Table2 t2 ON

t2.id1 = t1.id1

AND t2.id2 = t1.id2

where t1.field1...

Cold Coffee. Nice work. I thought about this last night and had a fresh solution ready to bang out today. I wasnt going to use CTE however probably should have....

going to try and verbally explain this so bare w/ me. For each WebCategoryId i have multiple WebSubCategoryIds who have multiple WebOptionNames.

When a new category and sub category is found...

i've added the desired output as an excel. It appears not only was my formatting jacked up but my output was incorrect. The excel copy is correct. thanks guys

that didnt come out formatted like i had it. i need to fix it first.

you can also write vba i think it's called which is code behind the actual excel file to create a connection and insert the records into db. Probably wont help...