Viewing 15 posts - 2,236 through 2,250 (of 2,452 total)
this may help explain:
http://technet.microsoft.com/en-us/library/ms190696.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 1, 2011 at 1:19 am
clear explanation of the Access "switch"
http://www.databasechannel.com/AccessArticles/Article_Conditions_NestedIfFunctionsSwitch.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2011 at 3:32 pm
renecarol33 (8/31/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2011 at 3:00 pm
toddasd (8/31/2011)
nairdeepa (8/30/2011)
the only problem i see though i have not tried this.is that it might update everything..and i want only the last one to be updated
Umm...when we say "try...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2011 at 1:34 pm
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
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2011 at 12:33 am
nairdeepa (8/28/2011)
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)...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 29, 2011 at 10:22 am
Jeff Moden (8/28/2011)
nairdeepa (8/27/2011)
Hi Jeff,I am not clear on what you just said. could you please elaborate?
Many thanks,
Gah covered that pretty well for me. He also provided an example...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2011 at 12:41 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 28, 2011 at 7:55 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 24, 2011 at 2:50 pm
Hi
does this help?
SELECT
DATEADD (MONTH, -1, (CAST ( Right(CaptureDate,4) + '/' + Left(CaptureDate,2) + '/01' as DATE))) AS FieldDate
FROM dbo.HorizontalTable
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 22, 2011 at 12:07 pm
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)))
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 20, 2011 at 4:00 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 20, 2011 at 2:35 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 14, 2011 at 7:38 am
vermarajiv (8/8/2011)
Depending on how large your result set is and how many records will be deleted in each iteration, performance will vary.
Hi RK...thanks for posting your solution...and as you say...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2011 at 3:21 pm
Does this help?
WITH cte
AS (SELECT asset_id,
MAX(asset_location_id) AS max_assloc_no
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 8, 2011 at 10:47 am
Viewing 15 posts - 2,236 through 2,250 (of 2,452 total)