Thank you guys,

It works!

Thank you again,

Brano

Drew,

i saw your answer right now, after I post my reply.

Thank you, will work on both so I can compare results.

Nobody is happier than me :-),

Thanks,

Brano

Thank you all for answers!

Lowell, it seems your query worked.

Thanks again,

Brano

Thanks for answers, will try that one.

Drew, you are right, not all of them, query is correct, not the English statement.

Thanks,

Brano

Thanks for answers,

In first you have Where clause: dbo.Invoice.EventDate = '2011/02/22'

As you can see, in the second, 9957047 has Payment at 2011/02/19 (<2011/02/22), which 205017714 doesn't.

So, real query should have...

Thanks J-F,

That is my misunderstanding of LEFT JOIN.

And I found better explanation of LEFT JOIN. I didn't count that "situation", when I can have duplicate in Table2.

In my case,...

I created view with query I have, it come to this:

Image1 Constituent1 ImageNo213,

Image1 Constituent2 ImageNo213

Is there easy way to merge column...

I tried, it is still giving duplicates, something like this:

Image1Constituent1Constituent1ImageNo213,

Image1Constituent2Constituent2ImageNo213,

instead of:

Image1Constituent1Constituent2ImageNo213

Why?

Thanks SSC,

It is database connected with application.

My task is administration, sometimes reports. I am not sure about normalization, but trying not to go there :-).

I do not know how to...

Thank you Craig, Pablo, for your quick response.

I will try.

I have to pull data from tables I mention, to looks something like this:

[Image Name] from Images table,

Artists (ConstituentTypeID=1) from...

Are you familiar with Report Builder 2.0?

It is a little extra work to find list ID (from URL, without extra letters, mine looks like: {3E170346-36F8-43DC-BBC7-A000EB8CA204}), but nothing you cannot achieve...

Thanks, SSC Veteran, that is the way!

Thanks again, regards,

Brano

jamie (8/5/2009)

---

You could also read the msdb tables and find the latest file backed up.

I just whipped this together and could probably be written better - and should be tested!...

Thank you guys,

there are some great information in your posts, regards,

Brano

It works, it works :)!

Thank you Ken, all the best,

Brano