I am a bit new at sql server and am trying to resolve a coding issue that I have come across. I hope there is someone out there that might be able to assist me. I am working with zip code +4 data and am trying to range the data to reduce the size of the database from the current ~65 million lines of data.  The trick is that I need to range ...

Thanks for the example and for attempting to answer my question, I've been posting it all over the place and have had minimal response, granted it's a small bit of business in Sql Server. My question might have been a bit vague, I'd hoped that by keeping it simple it might spark more conversation. So, to refine the issue using your example ...

I'm working with typed xml in Sql server '05 and haven't been able to resolve a couple questions through the documentation or any of my searches so far - so fanfare aside here is the most immediate question: If I have an XML Schema Collection with multiple namespaces how can I specify an xml column or variable that only targets one of ...

Hello guys, I have to write business solution for shortterm and new term. Scenario like this. There are two companies one is in JAPAN and other one is in UK they both making bikes. Now they merger togather, CEO is asking  the HRM department to have data of employees. Now company 1 is having won XP workstation with IBM DB2 ...