Rory, how big are the 2 tables?

May i add another method?

SELECT DISTINCT OBJECT_NAME (SC.id)

FROM syscomments sc

WHERE sc.text LIKE '%DatabaseA%'

drew.allen (4/16/2012)

---

Here's an improved version of my original query. It only scans the table once instead of twice.

SELECT u.SourceA, u.SourceB, t.Counts

FROM #Temp1 AS t

CROSS APPLY(

SELECT SourceA, SourceB

UNION

SELECT SourceB, SourceA

)...

Somehting like this?

SELECT SourceA = ISNULL(TabA.SourceA , TabB.SourceA)

,SourceB = ISNULL(TabA.SourceB,TabB.SourceB)

,Counts = ISNULL (TabA.Counts ,...

How do you arrive at the order of the results? what are teh rules for it?

Matt Miller (#4) (4/16/2012)

---

Just be careful with this. You will have to ensure that SSIS actually assigns the ID's in the correct...

Lol, they dont even want me at the office :-D:w00t: (that was...

Thanks for the...

I had some spare time now and here is the query

First, sample data

DECLARE @Tab TABLE

(

iD INT IDENTITY(1,1)

,Data VARCHAR(100)

)

INSERT @Tab

...

With 314 points and 791 visits, i hope you know the etiquettes in posting the sample data in readily consumable format. Please follow Jeff's article http://www.sqlservercentral.com/articles/Best+Practices/61537/ and post your data.

FYI,...

If the input values are either NULL or some value, the we can use this as well.

IF @ID IS NULL

BEGIN

-- We know we need everything...

Try this:

SELECT *

FROM @TABLE T

WHERE ISNULL(T.fldID, '') = CASE WHEN @ID IS NULL THEN ISNULL(T.fldID, '') ELSE @ID END

How about this?

Setting up the sample data

DECLARE @Tab TABLE

(

ID INT

,Tym TIME

,Axn INT

)

INSERT @Tab

SELECT 1 ,'10:00', 1

UNION...

Your sample data has a flaw; All the iDs after 9 are 8 only. You have to increment them. I did that, and here is the query that produces the...

So, you can ask you question like this!

Hi here are is my sample data and sample table structure

IF OBJECT_ID('tempdb..#Temp') IS NOT NULL

DROP TABLE #Temp

-- Sample Table

CREATE TABLE...