Isn't that Muffin?

Had to Google it Seth, movies take a while to cross the pond...but "a butler who takes an odd interest in feet" - GF might find that very amusing:)

Garadin (1/8/2009)

---

john g (1/8/2009)

---

LOL, it has been quite a day so far - 2 bad responses on my part...it has definitely taught me to read the OP carefully - and...

Integrate it into the body of your query, something like this:[font="Courier New"]SELECT DISTINCT

   view_leveranciers.LEV_ID,

   view_leveranciers.ADR_NAAM,

   view_leveranciers.ADR_TEL,

   view_leveranciers.PAR_NED AS FirmaNaam,

   view_leveranciers.ADR_ID,

   view_leveranciers.ADS_ID,

   TOEDETAIL.TSD_ARTNR_LEV,

  ...

Might take a while to find it in BOL for SQL2k!

This looks like a candidate...

Your assumptions were spot on, AL.

Thanks for the feedback.

DECLARE @Startdate DATETIME, @Enddate DATETIME

SELECT @Startdate = DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 0), -- 2009-01-08 00:00:00.000

@Enddate = DATEADD(dd, 1, @Startdate) ...

Look up CASE in BOL.

eddy (1/8/2009)

---

SELECT tsd_id,

SUM(CASE WHEN Code = 101 THEN verkoop ELSE 0 END) AS Price1,

...

Try this, eddy:SELECT tsd_id,

SUM(CASE WHEN Code = 101 THEN verkoop ELSE 0 END) AS Price1,

SUM(CASE WHEN Code = 102 THEN verkoop ELSE 0 END) AS Price2,

SUM(CASE WHEN Code =...

nabajyoti.b (1/8/2009)

---

DECLARE @columnx FLOAT, @columny nvarchar(2)

SELECT @columnx = 0.05, @columny = 'A'

SELECT @columny + STR(@columnx*100, 6,2) + '%'

displays A 5.00% which is having 2 spaces in...

Well done Richard, top work.

DECLARE @columnx FLOAT, @columny nvarchar(2)

SELECT @columnx = 1, @columny = 'A'

SELECT @columny + convert(varchar(5),@columnx*100.00) + '%',

@columny + STR(@columnx*100, 6,2) + '%'

Output:

-------- ---------

A100% A100.00%

What's 'TimClosestatus'? Where does it come from?

Richard, what are the results of the following two queries?

SELECT book_date as Job_Date, COUNT(*)

FROM dbo.Job

WHERE book_date IS NULL OR book_date = '1899-12-30 00:00:00.000'

GROUP BY book_date

SELECT [datetime] as Manifest_Date, COUNT(*)

FROM dbo.Job

WHERE...