After 35 minutes of trying to log in, it finally let us from the link on the http://appdev.sqlpass.org/ website, however, it was a different meeting ID than was...

Thanks Matt... This is going to work.

I did find other records that were duplicated a bit different. I am assuming I will need to tweak your code to...

That does seem to clean up my two examples, but what would be the best way to track down all the records in my db that are like this so...

Thanks Bit! This line works perfectly from the blog post with a change in a variable.

select dateadd(qq, datediff(qq, 0, @ThisDate) - 1, 0)

Change that to -4 and it works...

Thanks Ninja.

What I am doing is creating a view to pull this info. I need the view to only pull the data on the last 4 quarters......

No offense was meant at all guys. It was a time issue for me and I just didn't have the time yesterday. As I said yesterday, I really...

terrance.steadman (7/14/2009)

---

skailey (7/14/2009)

---

I would like to be able to do this without joining on 2 separate sub queries, for example (field1 is primary key):

select field1

from a

inner join b on...

While I appreciate the reasoning for why you would like certain questions posted this way, I believe it is overkill for my question. I have 2 tables. I...

Hi Lynn,

Thanks so much for the response. That did work, however, I was able to simplify this for my needs with what you gave me... they key being how...