please elaborate the select statemet howshould i use the max statement

vk-kirov (12/1/2010)

---

Comments...

that's Really great i read that article such a wonder full information lot of thanks

sorry for the late reply

Mark-101232 (8/24/2010)

---

Try this

SET DATEFORMAT YMD

--Sample table

DECLARE @TABLE AS TABLE(

[RID] INT,

[EMID] INT,

[In Time] DATETIME,

[Out Time] DATETIME)

--Insert sample data

INSERT INTO @TABLE

SELECT 62, 12, '2005-08-18 06:02:00', '2005-08-18 06:31:00'

UNION ALL...

thanks to your snippet hopes finally i found a way to solve it

i tried this snippet pretty close to me the resultant show all the records with the same...

--Sample table

DECLARE @TABLE AS TABLE(

[RID] INT,

[EMID] INT,

[In Time] DATETIME,

[Out Time] DATETIME)

--Insert sample data

INSERT INTO @TABLE

Select 46,19,'Aug 16 2005 10:49AM','Aug 16 2005 11:05AM'

Union All Select 47,19,'Aug 16 2005 11:23AM','Aug...

thanks for the immediate reply

i am extremely sorry i think i am wrong there

this is what my need

62122005-08-18 06:02:002005-08-18 06:31:00

63122005-08-18 06:31:002005-08-18 06:33:00

64122005-08-18 06:33:002005-08-18 06:34:00

66122005-08-18 08:02:002005-08-18 08:31:00

67122005-08-18 08:31:002005-08-18 08:33:00

68122005-08-18 08:33:002005-08-18...

great

wow that's great simple and easy chris

i got it thanks for your reply

sorry, i think i am not clear there

i want to delete the records in the batchstock table if the combination of the slno and itemid not available in the #tmp...

thanks for your immediate response

is this query is correct

DELETE BatchStock

FROM #tmp t

...

thanks phil finally i have succeed it but there is some security issues there, will it be controllable

ok, now using the sql profiler i found that the first query is faster and the loas t one is lettle bit of faster that the first one so the...

that's great immediate reply,

i have attached it

i execute this 4 statement,

i didn't know which one is better