Thanks for the feedback. One thing I noticed however, is that the query may not produce correct results if the activities overlap. It can be fixed, but may not be...

I've had a quick look at this, I think that when the total drive time becomes zero, such when

an activity completely overlaps the drivetime, the drivetime isn't displayed.

You can see...

dale_keller (11/25/2009)

---

Now the user would like me to get rid of both records in question since we have identified this as being a duplicate record. How would I do...

It's not totally clear what you want, but try this

WITH CTE AS(

SELECT Column_A,Column_B,Column_C,

COUNT(*) OVER(PARTITION BY Column_A) AS cn

FROM mytable)

SELECT Column_A,Column_B,Column_C

FROM CTE

WHERE cn=1

SELECT SUM(CASE WHEN tblUseOfForce.Taser=1 THEN 1 ELSE 0 END) AS Taser,

SUM(CASE WHEN tblUseOfForce.PhysicalForce=1 THEN 1 ELSE 0 END) AS PhysicalForce

FROM tblUseOfForce INNER JOIN

tblIncident...

eddy-644184 (11/24/2009)

---

Hi Mark,

Tnx for your help,

The provided code seems to do the trick, for witch i send you a lot of thanks,

I'm really not strong when dates come into play.

The...

Probably a bit overcomplex, but seems to give the correct results.

WITH Starts(drtid,starttime) AS (

SELECT b.drtid,

b.starttime

FROM @tDriveTimes b

WHERE NOT EXISTS(SELECT...

Something like this?

WITH CTE AS (

SELECT SoldTo,

ShipTo,

PriceType,

Value,

...

As long as there are unchecked memory accesses,...

C# Screw (11/19/2009)

---

We have a new leader !! Absolutely fab !! 😀

SQL function: Replace Technique : but using replacement chars ||*9*9||

2634

SQL function :Brigzy (C#Screw) Looping

2514

SQL function: Jeff Original : single...

C# Screw (11/19/2009)

---

Not sure how to get this into asembly :unsure:

Error1CREATE ASSEMBLY for assembly 'RemoveSpace_CLR' failed because assembly 'RemoveSpace_CLR' failed verification. Check if the referenced assemblies are up-to-date and trusted...

Paul White (11/18/2009)

---

Hey Mark,

Wouldn't...

Paul White (11/18/2009)

---

To the C# crew:

This seems to be the fastest method so far (on my machine at least)...would one or more of you please try it out?

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public...

SELECT DB_NAME()

SQL Learner-684602 (11/9/2009)

---

Thanks a lot..

it works fine for all the string ..but doesn't work for 0000 string

it only removes one 0

I want to make it single 0 if it is...