Databases
StackOverflow2013
Postsdbo
POHow to run multiple SQL queries whose values change?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to run multiple SQL queries whose values change?
    primarykey
    data
    text
    <p>Let's say I have a database of Amazon customers who made purchases in the last year. It is pretty detailed and has columns like name, age, zip code, income level, favorite color, food, music, etc. Now, let's say I run a query such that I return all Amazon customers who bought Book X.</p> <pre><code>SELECT NAME, AGE, ZIPCODE, INCOME, FAVECOLOR, FAVEFOOD, FAVEMUSIC FROM [Amazon].[dbo].[Customers] WHERE BOOK = "X" </code></pre> <p>This query will return a bunch of customers who bought Book X. Now, I want to iterate through each of those results (iterate through each customer) and create a query based on each customer's individual age, zipcode, and income. </p> <p>So if the first result is Bob, age 32, lives in zipcode 90210, makes $45,000 annually, create a query to find all others like Bob who share the same age, zipcode, and income. If the second result is Mary, age 41, lives in zipcode 10004, makes $55,000 annually, create a query to find all others like Mary who share the same age, zipcode, and income. </p> <p>How do I iterate through customers who bought Book X and run multiple queries whose values (age, zipcode, income) are changing? In terms of viewing the results, it'd be great if I could see Bob, followed by all customers who are like Bob, then Mary, and all customers who are like Mary. </p> <p>Is this even possible in SQL? I know how to do this in C# (for/next loops with if/then statements inside) but am new to SQL, and the data is in SQL.</p> <p>I use SQL Server 2008.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USphan
    1. USphan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to run multiple SQL queries whose values change?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSounds like you want a [CTE](http://msdn.microsoft.com/en-us/library/ms175972.aspx). You can do recursive operations without looping or cursors. Performance may be an issue.
      singulars
      1. POHow to run multiple SQL queries whose values change?
      1. USHABO
    2. CODo a google search on sql server cursers.
      singulars
      1. POHow to run multiple SQL queries whose values change?
      1. USDan Bracuk
    3. COWhile many people may vote for cursors here, I suggest against it as cursors can cause query execution time to be affected. I think you'll want to use a CTE on this one.
      singulars
      1. POHow to run multiple SQL queries whose values change?
      1. USKris Gruttemeyer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload