    SELECT @variable1 = col1, @variable2 = col2
    FROM table1



    SELECT @var = col1,
           @var2 = col2
    FROM   Table

Here is some interesting information about SET / SELECT

&gt; - SET is the ANSI standard for variable assignment, SELECT is not. 
&gt; - SET can only assign one variable at a time, SELECT can make multiple
&gt; assignments at once. 
&gt; - If assigning from a query, SET can only assign a scalar value. If the
&gt; query returns multiple values/rows
&gt; then SET will raise an error. SELECT
&gt; will assign one of the values to the
&gt; variable and hide the fact that
&gt; multiple values were returned (so
&gt; you&#39;d likely never know why something
&gt; was going wrong elsewhere - have fun
&gt; troubleshooting that one) 
&gt; - When assigning from a query if there is no value returned then SET will
&gt; assign NULL, where SELECT will not
&gt; make the assignment at all (so the
&gt; variable will not be changed from it&#39;s
&gt; previous value) 
&gt; - As far as speed differences - there are no direct differences between SET
&gt; and SELECT. However SELECT&#39;s ability
&gt; to make multiple assignments in one
&gt; shot does give it a slight speed
&gt; advantage over SET.

I was wondering if when using the datagridview control you can remove the thing that looks like a column before the 1st column. I think its used to select rows but not sure what its called. 

Datagridview - remove part before the first column

I&#39;ve got several annotations I want to add to my MKMapView (it could 0-n items, where n is generally around 5). I can add the annotations fine, but I want to resize the map to fit all annotations onscreen at once, and I&#39;m not sure how to do this.

I&#39;ve been looking at `-regionThatFits:` but I&#39;m not quite sure what to do with it. I&#39;ll post some code to show what I&#39;ve got so far. I think this should be a generally straightforward task but I&#39;m feeling a bit overwhelmed with MapKit so far.

    - (void)locationManager:(CLLocationManager *)manager didUpdateToLocation:(CLLocation *)newLocation fromLocation:(CLLocation *)oldLocation{
	
    location = newLocation.coordinate;
    //One location is obtained.. just zoom to that location
	
    MKCoordinateRegion region;
    region.center = location;
	
    //Set Zoom level using Span
    MKCoordinateSpan span;
    span.latitudeDelta = 0.015;
    span.longitudeDelta = 0.015;
    region.span = span;
    // Set the region here... but I want this to be a dynamic size
    // Obviously this should be set after I&#39;ve added my annotations
    [mapView setRegion:region animated:YES];

    // Test data, using these as annotations for now
    NSArray *arr = [NSArray arrayWithObjects:@&quot;one&quot;, @&quot;two&quot;, @&quot;three&quot;, @&quot;four&quot;, nil];
    float ex = 0.01;
    for (NSString *s in arr) {
	    JBAnnotation *placemark = [[JBAnnotation alloc] initWithLat:(location.latitude + ex) lon:location.longitude];
		[mapView addAnnotation:placemark];
		ex = ex + 0.005;
	}
        // What do I do here?
        [mapView setRegion:[mapView regionThatFits:region] animated:YES];
    }

Notice, this all happens as I receive a location update... I don&#39;t know if that&#39;s an appropriate place to do this. If not, where would be a better place? `-viewDidLoad`?

Thanks in advance.

Positioning MKMapView to show multiple annotations at once

I&#39;m converting SQL from Teradata to SQL Server

in Teradata, they have the format 

    SELECT col1, col2
    FROM table1
    INTO @variable1, @variable2

In SQL Server, I found 

    SET @variable1 = (
    SELECT col1 
    FROM table1
    );

That only allows a single column/variable per statement. How to assign 2 or more variables using a single SELECT statement?

SQL SELECT multi-columns INTO multi-variable

I'm converting SQL from Teradata to SQL Server
in Teradata, they have the format
<pre><code class="hljs language-sql">SELECT col1, col2
FROM table1
INTO @variable1, @variable2
</code></pre>
In SQL Server, I found
<pre><code class="hljs language-sql">SET @variable1 = (
SELECT col1 
FROM table1
);
</code></pre>
That only allows a single column/variable per statement. How to assign 2 or more variables using a single SELECT statement?

I have a table like this...

    CustomerID   DBColumnName	Data
    --------------------------------------
    1	         FirstName      Joe
    1	         MiddleName     S
    1	         LastName       Smith
    1	         Date           12/12/2009
    2	         FirstName      Sam
    2	         MiddleName     S
    2	         LastName       Freddrick
    2	         Date           1/12/2009
    3	         FirstName      Jaime
    3	         MiddleName     S
    3	         LastName       Carol
    3	         Date           12/1/2009

 
And I want this...

Is this possible using PIVOT?

    CustomerID  FirstName   MiddleName          LastName        Date
    ----------------------------------------------------------------------
    1           Joe             S               Smith           12/12/2009
    2           Sam             S               Freddrick       1/12/2009
    3           Jaime           S               Carol           12/1/2009



TSQL Pivot without aggregate function

I would like to see the SQL statement that a given ActiveRecord Query will generate.  I recognize I can get this information from the log after the query has been issued, but I&#39;m wondering if there is a method that can be called on and ActiveRecord Query.

For example:

    SampleModel.find(:all, :select =&gt; &quot;DISTINCT(*)&quot;, :conditions =&gt; [&quot;`date` &gt; #{self.date}&quot;], :limit =&gt; 1, :order =&gt; &#39;`date`&#39;, :group =&gt; &quot;`date`&quot;)

I would like to open the irb console and tack a method on the end that would show the SQL that this query will generate, but not necessarily execute the query.

How can I see the SQL that will be generated by a given ActiveRecord query in Ruby on Rails

I have a `DataTable` that is filled in from an SQL query to a local database, but I don&#39;t know how to extract data from it.
Main method (in test program):

&lt;!-- language: csharp --&gt;

    static void Main(string[] args)
    {
        const string connectionString = &quot;server=localhost\\SQLExpress;database=master;integrated Security=SSPI;&quot;;
        DataTable table = new DataTable(&quot;allPrograms&quot;);

        using (var conn = new SqlConnection(connectionString))
        {
            Console.WriteLine(&quot;connection created successfuly&quot;);

            string command = &quot;SELECT * FROM Programs&quot;;

            using (var cmd = new SqlCommand(command, conn))
            {
                Console.WriteLine(&quot;command created successfuly&quot;);

                SqlDataAdapter adapt = new SqlDataAdapter(cmd);

                conn.Open(); 
                Console.WriteLine(&quot;connection opened successfuly&quot;);
                adapt.Fill(table);
                conn.Close();
                Console.WriteLine(&quot;connection closed successfuly&quot;);
            }
        }

        Console.Read();
    }

The command I used to create the tables in my database:

&lt;!-- language: sql --&gt;

    create table programs
    (
    	progid int primary key identity(1,1),
    	name nvarchar(255),
    	description nvarchar(500),
    	iconFile nvarchar(255),
    	installScript nvarchar(255)
    )

How can I extract data from the `DataTable` into a form meaningful to use?

How do I extract data from a DataTable?

I keep getting MySQL error #1054, when trying to perform this update query:

    UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH
    SET MASTER_USER_PROFILE.fellow=`y`
    WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID
    AND TRAN_USER_BRANCH.BRANCH_ID = 17

It&#39;s probably some syntax error, but I&#39;ve tried using an inner join instead and other alterations, but I keep getting the same message:

    Unknown column &#39;y&#39; in &#39;field list&#39; 


Unknown column in &#39;field list&#39; error on MySQL Update query

I am trying to find a MySQL query that will find DISTINCT values in a particular field, count the number of occurrences of that value and then order the results by the count.

example db

    id         name
    -----      ------
    1          Mark
    2          Mike
    3          Paul
    4          Mike
    5          Mike
    6          John
    7          Mark

expected result

    name       count
    -----      -----
    Mike       3
    Mark       2
    Paul       1
    John       1



Count the occurrences of DISTINCT values

According to [MSDN][1], Median is not available as an aggregate function in Transact-SQL. However, I would like to find out whether it is possible to create this functionality (using the [Create Aggregate][2] function, user defined function, or some other method). 

What would be the best way (if possible) to do this - allow for the calculation of a median value (assuming a numeric data type) in an aggregate query?

  [1]: http://msdn.microsoft.com/en-us/library/ms173454.aspx
  [2]: http://msdn.microsoft.com/en-us/library/ms182741.aspx


Function to Calculate Median in SQL Server

I am attempting to create a `Stored Procedure` for a newly created database. However the `SSMS` intellisense does not recognize more than half of the tables which have been created. 

For example whilst in the left hand column under tables I have a table `dbo.Room`, when I type &quot;`dbo.`&quot; in the new query window, that table is not listed, in fact only 17 out of 37 tables are listed. 

I can see no difference between the tables listed by intellisense and those not. If I manually type dbo.Room, it is underlined, with an error of 

&gt; Invalid Object Name &#39;dbo.Room&#39;..


Have I missed something in setting up the tables? 


UPDATE: I have tried refresh of the tables list (several times)

sql server invalid object name - but tables are listed in SSMS tables list

I&#39;m trying to update one value of a compound primary key from within the entity framework and I&#39;m getting this error: &quot;The property &#39;CustomerID&#39; is part of the object&#39;s key information and cannot be modified. &quot;

Here is my code: 

    Dim customer As Customer = (From c In db.Customer Where c.CustomerID = &quot;xxx&quot; AndAlso c.SiteKey = siteKey).FirstOrDefault
    customer.CustomerID = &quot;fasdfasdf&quot;
    db.SaveChanges()

It seems too simple. Is it true you can&#39;t update a primary key within the entity framework? I can&#39;t find any documentation on the topic. Thanks!

Update primary key value using entity framework

Is there a command I can run inside my SQL script so that it stops outputing information about each operation that gets run?

ie I don&#39;t want to see this:

    (1 row(s) affected)
    
    (1 row(s) affected)
    
    (1 row(s) affected)
    

How to stop SQLServer writing extraneous stuff eg (1 rows affected)

I am just starting on Teradata and I have come across an Ordered Analytical Function called &quot;Rows unbounded preceding&quot; in Teradata. I tried several sites to learn about the function but all of them uses a complicated example explaining the same. 
Could you please provide me with a naive example so that I can get the basics clear? 


Content Type	Original Author	Original Content on Stackoverflow
Question	ala	View Question on Stackoverflow
Solution 1 - Sql	David M	View Answer on Stackoverflow
Solution 2 - Sql	Svetlozar Angelov	View Answer on Stackoverflow

SQL SELECT multi-columns INTO multi-variable

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Positioning MKMapView to show multiple annotations at once

Datagridview - remove part before the first column

Attributions