WHERE (DATEPART(YEAR,GETDATE()) = DATEPART(yyyy, Docket_Date))And Docket_Date > DATEADD(MONTH, -2, GETDATE())

Woops

Sorry

I changed the path in my app and its working now

Thanks all

Hmmmm the file is on the second computer, do you think it would be better to copy it to the SQL server before bulk inserting? this way the server would...

Operating system error code 53(failed to retrieve text for this error. Reason: 1815).

Thanks

Sorry Jeff, performance as it stands is not that bad. Originally the report where done using access and generating a report from that took 5mins, even using the method I...

Right I think I was doing the convert in the wrong place, this returns results I want to see.

SELECT MachineName, ModeName, FileName, JobName,...

Thanks Chris, sorry to post and post but I feel like I am close. I dont have a holing table anymore and the only problem I have is running queries...

If I Convert and use the AS can I run a query against it ?

SELECT MachineName, ModeName, FileName, JobName, UserName,

CONVERT(datetime, StartDate) AS...

Hi Jefff, where am I going wrong with this query please

SELECT MachineName, ModeName, FileName, JobName, UserName,

StartDate, StartTime, CONVERT(datetime, StartDate) + CONVERT(datetime,...

To Make life easier is it possible to replace the date in StartDate_Time with the results returned from

Select StartDate, StartTime, convert(datetime, StartDate) + convert(datetime, StartTime) AS StartDate_Time

from...

Select StartDate, StartTime, convert(datetime, StartDate) + convert(datetime, StartTime) AS t

from ProdDataTB

Its not dropped 🙁

you declaring at the start but how how do I tell it to use StartDate ?

from ProdDataTB

Thanks

Ah magic I think the pennie has dropped. I will post what I have so you can advise if that's ok.

Jay

Hi Jeff, sorry I am confused a bit, I get a flat text file, then convert to csv and bulk insert all the data into ProdData table which is all...

APS08,C5_LAKE_WE,08075_002_,0807500236,ADAMSAG,26013,Sun Jan 01 07:21:59 2012,01/01/2012,07:21:59,2012,01,01,07,21,59,,Sun Jan 01 07:30:42 2012,01/01/2012,07:30:42,2012,01,01,07,30,42,,196,27,88,212,88,212,498,483,3,0,8,00000487,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00001147,00001147,00000000,00000000,00000000,00000000,13463,,2,0,0,2,0,0,2,0,0,0,,,,,,,,,,,,,,,,,488,245,,,,498,483,,

APS05,C5_LAKE_WE,08066_005_,0806600536,HUGHEPE,28708,Sun Jan 01 07:08:38 2012,01/01/2012,07:08:38,2012,01,01,07,08,38,,Sun Jan 01 07:47:25 2012,01/01/2012,07:47:25,2012,01,01,07,47,25,,1467,45,295,520,295,520,5476,5457,12,2,15,00005467,00000000,00000000,00000000,00000000,00000000,00000109,00004248,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00009894,00000000,00009894,00000000,00000000,00000000,14090,,18,0,0,14,4,11,2,0,0,5,,,,,,,,,,,,,,,,,5467,275,,,,5476,5457,,

This is 2 lines from the csv

the order is the same as the create...