forrest77 (4/24/2015)

---

Lynn, this is the table.

CREATE TABLE [dbo].[EditLog](

[Id] [INT] IDENTITY(1,1) NOT NULL,

[EditDate] [DATETIME] NOT NULL,

[PlanId] [INT] NOT NULL,

[TransId] [INT] NOT NULL,

[EntityId] [INT] NOT NULL,

[QtyPrior] [FLOAT] NULL,

[QtyAfter] [FLOAT] NOT...

Taking the "sample data" you posted as if it were the data in a table, here is how I would get the most recent row of data for each PlanId:

/*

Id...

forrest77 (4/24/2015)

---

here is some some records. all are same records but the edit time are different. I would like to have a cursor or something else that can through...

forrest77 (4/24/2015)

---

CREATE FUNCTION dbo.ADMC_DDL_GetUniqueEditEdit()

RETURNS @EditLog TABLE(

Id INT NOT NULL

,EditDate DATETIME NOT NULL

,PlanId INT NOT NULL

,TransId INT NOT NULL

,EntityId INT NOT NULL

,QtyPrior FLOAT NULL

,QtyAfter FLOAT NOT NULL

,Description VARCHAR(255) NULL

,NotText NVARCHAR(max) NULL

)

AS

BEGIN

INSERT...

I think you are making this harder than it actually is. Could you post the DDL (CREATE TABLE statement) for the tables involved, some SAMPLE data for both tables...

CELKO (4/24/2015)

---

Of course there is, since you can cast the number to a string any time you want, although you'd never need to compute a check digit that's already...

Steve Jones - SSC Editor (4/24/2015)

---

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make...

jonathan.crawford (4/24/2015)

---

Steve, my brother is getting hitched on the 4th of July weekend in Breckinridge. I'm not sure we're going to be able to make it, but assuming we do...

Sounds like they are using UTC time in their tables.

mistylove98 (4/23/2015)

---

Thanks all for the help I feel kinda stupid now. Yes it should not have been shipped date it should have been

delete LMOrders where OrderDate between 10-10-1996...

Well, that is the result of that particular query. You inserted a single row of data into a table and SQL Server reported 1 row inserted.

If you had surrounded...

Is ShippedDate actually a...

ScottPletcher (4/23/2015)

---

Stripping out delimiters should never eliminate information from the data. If you need to, you can set a tinyint code that reflects the meaning of the delimiters. ...

Not quite how I would do it, but give this a try:

delete from

dbo.LMOrders

where

OrderDate between '19961010' and '19961025'

and ShippedDate...

Make the following change to your code above:

SET @cmd = '"copy ' + @dir + '\*.*' + ' ' + @extPAth +'"'