david.kelly (2/3/2009)

---

:angry:I can feel the pain and I also suffer with it.

I believe what we are trying to discover is how do we turn off the dashed line in query...

CrazyMan (2/3/2009)

---

Hi Chris

It works, it returns all rows with date (2nd) despite of what ever month...

Test with some extra data, CrazyMan. It doesn't work.

Insert into #Month Values('2008-12-30 23:48:56.024')

Insert into #Month Values('2008-12-31 23:48:56.024')

Insert into #Month Values('2009-01-01 23:48:56.024')

Insert into #Month Values('2009-01-02 23:48:56.024')

Insert into #Month Values('2009-01-03 23:58:53.024')

Insert into...

CrazyMan (2/3/2009)

---

Hi Visal

Thanks, i need all records that more than a months old despite of year,...

There's another possible angle here. Where is the code running from? Is it a query placed in a command object in Crystal or from a stored procedure? How many rows...

You can use min on varchar. Hopwever, it might not give the same result as you were originally getting. This is closer, using correlated subqueries:

SELECT d.*

INTO #feedrecord

FROM (

SELECT f.*,

VENDORNUM =...

Aha!

Can you please set up some...

The purpose of this statement is to pull...

I'm sorry I can't go any further with this -...

Philip Horan (1/31/2009)

---

Hi Chris, yes the same values. The query is for a report. Currently the report returns a blank for NULL's, I thought it would look better if it...

GilaMonster (2/2/2009)

---

I'll change the avatar back in a few days. That's the second comment about the haircut.

Funny thing is, it's not far different...

Resolving the tables out of the views results in this:

SELECT it.error_code, COUNT(*) as occurances,

SUM(d.qty_tested) AS qty_tested,

SUM(d.qty_failed) AS qty_failed

FROM [assembly] as a

INNER JOIN tester_configuration as tc ON...

GilaMonster (2/2/2009)

---

From a quick glance, this doesn't need a cursor at all.

One question - if all 5 of the carrier names are blank, do you want 5 records in the...

You're welcome.

This isn't a complicated process and there's certainly no need for a cursor. Processing the feed table row by row,

with up to six individual inserts per row, is...

Exactly as you would find on an order or an invoice?