That is also code noodles, but with different result.

NULL values will be...

Yes it does.

There are some.

xzd000 (7/7/2010)

---

Hi

Some command that's not possible on...

David Portas (7/6/2010)

---

...

Is that the real statement actually being issued or did you simplify it by substituting literal values where there would have been variables? Assuming there are variables driving...

1. Please click the link in my signature, it will explain how t post your question to get timely answers

2. Also, could you please explain what rules for joining betwen...

I am off to Italy for very long weekend tomorrow, so I should care less 😀

But this is quite a nice puzzle, which I am going to have a look...

Brandie Tarvin (7/6/2010)

---

First of all, "she", not he. @=)

Secondly, I need random numbers that do not repeat. I'm not limited to a range, but I need to make sure they...

scott.pletcher (7/6/2010)

---

If by "run it for Tuesday", then you mean "ignore Wednesday's" rows in the query, then no, it still won't, because the count of clock-in will not match the...

Scott, could you please advise where you found that I have "tricked" the test data?

For ecah employee there is a record with LOGIN time before record with OUT time!

You are...

As I have mentioned in my first post, that my query will only take in count "closed" periods.

That is why I have not added filter for time period, as new...

scott.pletcher (7/6/2010)

---

That would have NO effect on my query. As long as the proper pairs were present.

I've done this before on time systems. You really don't have to...

There are many different ways to do it with SSIS. It depends really on your preference and experience in it. SSIS is a tool designed for this kind of tasks....

scott.pletcher (7/6/2010)

---

Yes, SUM() should be used...

There is no database size limitation for mirroring. For your 32-bit system will be limitation of maximum of about 10 databases per server instance.

All restrictions can be found in BoL:

http://technet.microsoft.com/en-us/library/ms366349(SQL.90).aspx

doobya (7/5/2010)

---

the primary function of the IsPaused column is "is this session paused"

the secondary function of the IsPaused column is "if this session is paused - when was it paused"

that...

FREETEXT is not UDF, it is in-build predicate. It cannot be used in such context.

You have used it similar to the following:

...

CASE WHEN ColA>ColB THEN ColC ELSE ColD>ColE

...

While...