Hello, I'm completely new to SQL - and have a question on how to make a basic database. I want to make a database of receipts (credit card) and credit card statements.  My proposed receipts table (i'm not worried about syntax right now - although this specific syntax is PostgreSQL) is basically something like this: CREATE TABLE receipts ...

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 ...