Melanie Peterson (2/18/2009)

---

Lynn, your suggested query runs in a second, as opposed to minutes for mine. THANK YOU!!! 😀 I just have one question: I thought because...

If I have some time later today, I might try and do more. Unfortunately, I do have my own job that I need to do as well.

Doesn't Jeff's article, Forum Etiquette: How to post data/code on a forum to get the best help, tell you exactly how to post everything you need to get the best...

Any OP in particular?

martijnschaar (2/18/2009)

---

Some sample data:

Sheet1:

portcodesymbol MarketValue

400004TEGACEH LX 107.002,20

400004CAEUBAC LX 86.849,00

400004FIDEBFA LX 108.564,48

400004cash ...

Are you trying to get SSRS to automatically translate your labels from one language (English) to another (French)?

I don't think you can do that in SSRS.

Not enough information to really help you. May I suggest that you read the first article I have referenced below in my signature block regarding asking for assistance.

If you...

I realize the OP hasn't posted anything yet, but I put together the following code to demonstrate what is happening. The key thing to remember from this is when...

I read your post several times and never caught the reference to AttendenceDateTime until you pointed out that you had mentioned it, if it had been a snake...

Next question I...

I have to agree on reading books. I have a bunch of books I keep in my car (my portable library) so I can have them at work and...

I'd like to hear Hugo's answer to your question, but IMHO not much really changes in SQL Server 2008 with regard to the DATE and TIME data types. When...

Jeff Moden (2/17/2009)

---

Lynn's suggested changes are a great way to start. What he failed to mention is... why. Even if you added a pot wad of indexes to...

arun.sas,

Is everything working okay?

And this is my code changes using left outer joins. Of course, with no tables and sample data, I can't test it:

DECLARE @CurrDate AS datetime

SELECT @CurrDate = '2009-02-02'

DECLARE...

Here is my first shot with minor changes. I would also look at moving some of the subqueries into left joins in the FROM clause, but I'll wait a...