Aaaaarrrrrgggggghhhhhhhhhh!!!!

I'm never harvesting wildfowl feathers ever again!

Ben & Jerry's

lagniappe

da-zero (6/24/2010)

---

arik_beri (6/24/2010)

---

Thanks Chris, it sure looks much more simple that way.

But yet it still doesn't work. When I copied this expression to the expression column in the SSIS edit...

Have you tried using datetime functions for this?

SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '00:45')

SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '01:00')

SELECT DATEDIFF(mi, '1900-01-01 00:00', '1900-01-01 ' + '01:01')

SELECT DATEDIFF(mi,...

It's still a little unclear what you are trying to do, but I think it's a filter.

So,

WHEN @timespan = 'YTD'

you want to return data within...

Yes

England vs Slovenia is in progress.

Perhaps that should have read Slovenly vs Slovenia 😀

Tactical Nuclear Penguin

(more of a weapon than a beer) 😀

If the column 'CalendarDays' isn't in the table which contains...

The choices in your CASE resolve to constants.

-- WHEN @sortby = 'YTD'

GROUP BY cp.Device_Type_Code, c.Perfect_Journey_Tech_Exception_Flag, 2010

-- WHEN @sortby = 'Q2 2010'

GROUP BY cp.Device_Type_Code, c.Perfect_Journey_Tech_Exception_Flag, 2

-- WHEN @sortby = 'June 2010'

GROUP...

CirquedeSQLeil (6/21/2010)

---

Trey Staker (6/21/2010)

---

So true, I also spent 2 weeks in Huston in August in 90 degree weather and it felt...

The date filter in the WHERE clause will work much more efficiently if the date can be compared directly to a lower and upper bound without any transformation. The expression...

Looks like an UPDATE to me.

UPDATE docsadm.shellorganisation

SET [disabled] = 'y'

WHERE docsadm.shellorganisation.org_name LIKE 'do not use%'

What are you trying to do here? Insert new rows into shellorganisation, or update existing rows?