Yes you can have a CASE statement in the join, but it will hurt performance somewhat. If you're joining two tables, I would consider dealing with the invalid end...

I'm not sure why you would need that. The culture is going to be important on the front-end, since it's going to determine how you interact with the end-user....

It's...

Must....resist...getting...sucked...into...religious...war...debate.

Sounds to me that the calculation is wrong for your requirement. Perhaps a different windowed aggregate function.

Try this:

select count(distinct Left(ToName,2)) OVER(PARTITION BY TransTime, DriverNo) as CustCount,

...

Jack - what exactly are you having trouble with? What is not happening?

Can't help you without some more specifics....

swarada1783 (5/29/2008)

---

Friends,

I am planning to use SQL Server Express 2005 as the back end database for one of the VB applications which runs continuously on the client's machine.The data that...

Also - keep in mind that unless he also changed the query to USE the full-text index, chances are - it's not using it. Full-text uses different operators to...

If you need the T-Logs backed up, then I'd say - skip truncating. Ever. If you need to shrink then by all means, do so, just do it...

pete.trudell (5/29/2008)

---

Thank You, Matt. The Leave Query (the query which is not updatable) uses one table and one query. The Table is the leave table which has a...

You're going to have to provide some more details than that. Do these size tables have the same layout and you want to UNION them all? or are...

Warren Peace (5/29/2008)

---

Lets everybody stand back a little and take a good look at this.

Assume this is a production SQL 2005 DB and the recovery model is Full.

A dB get's...

Good catch Antonio. One small change will help with that. Still looking for breaks, but forcing one at the beginning:

declare @start int

set @start=min(col1) from #myTable;

;With bobCTE as

...

Phil Factor (5/29/2008)

---

Brad McGehee hasn't just been sitting there on the top of this forum in the red band asking 'true/false' questions. He's just written a book for Simple-Talk called...

your OR is throwing you off.

I'm thinking you want your WHERE clause to be:

where StartTime >= '2008-5-29' and StartTime < '2008-7-1'

and...