If I understand correctly, in either table you can have no records for a match in the other table, but you want to show the data from both tables. correct?

If...

mjackson-1128654 (6/29/2010)

---

We have a legacy database which contains a configuration table. Many parameters are stored in that table. Typically a stored procedure queries the table for a parameter...

This explains why just the = works.

Thank you for the reference to...

aberndt (6/29/2010)

---

Steve - Thank you, thank you, thank you!!! I removed the > from your statement as I need only yesterday's data, not today's and it worked great!!! ...

I've learned the most not from the questions asked, but...

David Tooker (6/29/2010)

---

I guess I should have been more specific. I can add a Id column without a problem. I only put the first few servers down as...

You are correct, this would work.

I...

Sigh... I sure wish we could put into the briefcase an individual post on the forum... This one of Jeff's certainly would be in it.

@jeff -

1. Did you test...

And if there are any gaps, then this will work for you:

DECLARE @test-2 TABLE (ID INT)

INSERT INTO @test-2

VALUES (1),(2),(3),(4),(5),(6)

;WITH CTE AS

(

SELECT ID, RN = ROW_NUMBER() OVER (ORDER BY ID)

...

Sigh... duplicate post.

Please continue discussion at this post

How does this work?

declare @test-2 table (Col1 varchar(50))

insert into @test-2

select '[abcdef] Client' UNION ALL

select '[gdhdnuidd] 1st Party SW' UNION ALL

select 'testbusiness'

select case when charindex(']', Col1) > 0 then substring(Col1,...

Agile (6/28/2010)

---

Thanks wayne for the suggestion, Im just wondering, Because when I use your solution, I did not declare variable for Date. Is there a difference in performance on doing...

lmu92 (6/28/2010)

---

Ok, kinda funny I had to go back to this post within just a few hours...

The first person who "forced" me to do it actually created the...

I would suggest the following:

declare @MyDate datetime,

@fn varchar(100),

@cmd varchar(200)

set @MyDate = DateAdd(day, -1, getdate())

set...

I believe I saw a follow-up post from Jeff where he found that the...