this may help explain:

http://technet.microsoft.com/en-us/library/ms190696.aspx

clear explanation of the Access "switch"

http://www.databasechannel.com/AccessArticles/Article_Conditions_NestedIfFunctionsSwitch.html

renecarol33 (8/31/2011)

---

It doesn't work. I googled CASE in Access and it said it can only be used in VBA code. I am using SQL code in Access. I don't...

toddasd (8/31/2011)

---

Umm...when we say "try...

try this debra

probably requires some more work

---=====++++++++++++++++++++++++++++++++++++++

USE TempDB

;

---conditionally drop the test table

IF OBJECT_ID('TempDB.dbo.TMPDATA','U') IS NOT NULL

...

nairdeepa (8/28/2011)

---

Hello Gah,

Based on your query, I was able to modify mine. Many thanks to you..My query now looks like below 🙂

use crm_project;

go

;With abc as

(select client_order_number as 'client_order_number'

,(convert(datetime,(left(session_start_date,4)

+ substring(session_start_date,3,2)...

Jeff Moden (8/28/2011)

---

Gah covered that pretty well for me. He also provided an example...

Jeff Moden (8/27/2011)

Good lord, NO! 😀 The RBAR in that solution will take a month of Sundays to run. Please take a look at the first link in...

Hi David

Code posted below may provide you with some ideas and I would be very happy to hear back from you and others once reviewed.

It uses an AUDIT table that...

Hi

does this help?

SELECT

DATEADD (MONTH, -1, (CAST ( Right(CaptureDate,4) + '/' + Left(CaptureDate,2) + '/01' as DATE))) AS FieldDate

FROM dbo.HorizontalTable

SELECT DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0))

SELECT DATEPART(YEAR,DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0)))

SELECT DATEPART(MONTH,DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,getdate())-1,0)))

Hi

If you can please provide what Lynn has asked for, then I am sure that will help us.

Also:

Am I correct in thinking that rows in Order_test table are "inward" movements...

Hi

This may be of interest

http://www.red-gate.com/products/dba/sql-monitor/

free trial available

...I dont work for Redgate.

regards gah

Hi RK...thanks for posting your solution...and as you say...

Does this help?

WITH cte

AS (SELECT asset_id,

MAX(asset_location_id) AS max_assloc_no

...