A UNION tells SQL Server to exclude any duplicate rows, which in turn requires grouping internally.

If you are 100% sure no duplicates will occur, then use UNION ALL.

tacy.highland (12/1/2011)

---

I'm using an expression for the dataset in a SSRS report so that I can parameterize a variable. It worked for an older report in our repository so...

GilaMonster (12/1/2011)

---

Tables, by definition, don't have an order. The only thing that order by on an insert will do is control how identity values are assigned. If you want a...

This might help. 🙂

http://www.sqlservercentral.com/articles/Development/2824/

SQL doesn't store the data in any "ORDER". The engine determines the best place/way to store the data on it's own. Regardless of how you insert it.

It would only...

Also, you could have an SSIS package set to handle the synching run nightly. Setting up linked servers and jobs to synch them. There are many possibile approaches. 🙂

bumping this thread. I made an edit after your post and not sure if you'd be notified. 🙂

What are the time constraints for keeping the data in synch. How stale can the data be in the dependant databases?

Have you thought about Replication of the employee table, then...

Just to be clear, there is no need for the actual line breaks. So this should work fine..

@emailBODY = 'first<br...

dguthrie_2010 (11/29/2011)

---

Hi All,

Thank you Jason for this article, it has been very helpful.

We are having a similar problem to the one JayK described on 8/16/2011 regarding formatting the body of...

Sean Lange (11/29/2011)

---

You are welcome. The query Jason put together is probably the same thing I would have come up with but I figured that the article was worth a...

It's that old saying "You can't see the forest for the...

So if the flag is 0, then do not check that column... correct?

Then ...

SELECT *

FROM Features

WHERE

(Flag1 = @Flag1 OR @Flag1 = 0) and

...

1. Search the SPLIT function on this site.

2. Read up on Dynamic SQL.

Sorry, I think I had a minor issue with the code. This illustrates my question more appropriately.

PRINT 'Testing with ANSI_PADDING ON'

SET ANSI_PADDING ON;

GO

CREATE TABLE t1 (

charcol CHAR(16)...