Optimizer question

[groleau]

I need to standardize some fields in a staging table before selecting some of them to put in a permanent table.

Can I depend on the UPDATE happening before the SELECT or must I say GO between the two to ensure that non-standardized input fields are evaluated correctly in the SELECT ?

thanks

--
Wes Groleau

http://www.Parkview.com/

 

[RiverGuy]

If you execute multiple sql statements in sequence in a single command, they will not run concurrently.

 

[SQLDenis]

??
please show the query

is this a
update....
from
select query?

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[groleau]

please show the query"

Using the short names from another post:

UPDATE S
SET    A = 
       CASE  -- abbreviate name
       WHEN A LIKE '%subgroup%' THEN 'subgroup'
       WHEN (list of others)
       ELSE 'main' -- or use main if no subname present
       END

INSERT INTO K (C, D)
SELECT A, B
FROM   S
LEFT JOIN K
     ON   A = C
     AND ... WHERE ... etc.

--
Wes Groleau

http://www.Parkview.com/

 

[SQLDenis]

yes the update will happen before the insert put it into a transaction if you don't want anyone else updating the table between your update and your insert

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[groleau]

Thanks. Not worried about concurrency--(input S and update K) is a periodic automation and K is read-only for everyone else.

--
Wes Groleau

http://www.Parkview.com/