Viewing 15 posts - 196 through 210 (of 1,183 total)
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.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 1:14 pm
tacy.highland (12/1/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 12:55 pm
GilaMonster (12/1/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 12:39 pm
This might help. 🙂
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 12:29 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 11:55 am
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. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 30, 2011 at 8:26 am
bumping this thread. I made an edit after your post and not sure if you'd be notified. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 30, 2011 at 8:24 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 30, 2011 at 8:16 am
cgrammont (11/29/2011)
@emailBODY = 'first<br /><br /><br />
second
<br /><br /><br />
third'
Just to be clear, there is no need for the actual line breaks. So this should work fine..
@emailBODY = 'first<br...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 10:27 am
dguthrie_2010 (11/29/2011)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 9:45 am
Sean Lange (11/29/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 9:42 am
Daniel H (11/29/2011)
Errr, that seemed really simple! Here I am thinking functions and dynamical SQL...Let me test that code out
It's that old saying "You can't see the forest for the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 9:41 am
So if the flag is 0, then do not check that column... correct?
Then ...
SELECT *
FROM Features
WHERE
(Flag1 = @Flag1 OR @Flag1 = 0) and
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 9:17 am
1. Search the SPLIT function on this site.
2. Read up on Dynamic SQL.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 29, 2011 at 6:55 am
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)...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgNovember 28, 2011 at 1:54 pm
Viewing 15 posts - 196 through 210 (of 1,183 total)