Hi Jeff,

You know, it's a whole new SQL world for me when I see you statements, and I take couple of hours to understand it even when you kindly explain...

Thanks Jeff, I will wait for your always helpfull examples then!

I made some changes in the formatfle but still not working 🙁 ...

10.0

29

1SQLCHAR012"\","1cGroupID""

2SQLCHAR012"\","2cGroupIDBillable""

3SQLCHAR00",\""3cGroupNameLatin1_General_CI_AS

4SQLCHAR00"\","4cGroupDescriptionLatin1_General_CI_AS

5SQLCHAR012"\","5cRowID""

6SQLCHAR00",\""6cRowNameLatin1_General_CI_AS

7SQLCHAR00",\""7cRowDescriptionLatin1_General_CI_AS

8SQLCHAR024"\","8cTransactDate""

9SQLCHAR00",\""9cTransactTypeLatin1_General_CI_AS

10SQLCHAR00",\""10cChargeAccountIDLatin1_General_CI_AS

11SQLCHAR00",\""11cChargeAccountTypeLatin1_General_CI_AS

12SQLCHAR00",\""12cUserWhoPrintedLatin1_General_CI_AS

13SQLCHAR00",\""13cDocumentNameLatin1_General_CI_AS

14SQLCHAR012"\","14cUnits""

15SQLCHAR00",\""15cDocumentIDLatin1_General_CI_AS

16SQLCHAR00",\""16cDeviceIPLatin1_General_CI_AS

17SQLCHAR00",\""17cDevModelLatin1_General_CI_AS

18SQLCHAR00",\""18cDevManufLatin1_General_CI_AS

19SQLCHAR00",\""19cDurationLatin1_General_CI_AS

20SQLCHAR00",\""20cDestinationLatin1_General_CI_AS

21SQLCHAR00",\""21cFullNameLatin1_General_CI_AS

22SQLCHAR00",\""22cPrimaryPINLatin1_General_CI_AS

23SQLCHAR00",\""23cWorkstationLatin1_General_CI_AS

24SQLCHAR012"\","24cAmount""

25SQLCHAR00",\""25JobPropertiesLatin1_General_CI_AS

26SQLCHAR012"\","26cAltCost""

27SQLCHAR00",\""27cDepartmentLatin1_General_CI_AS

28SQLCHAR00",\""28cBillableLatin1_General_CI_AS

29SQLCHAR00"\"\r"29cAlternatePinLatin1_General_CI_AS

I need the CREATE TABLE statements for each of these file types. JPG's won't do me any good. I need the code itself. You can save it...

Hi guys,

I have been struggling myself for the last two days but I couldn't make it work. Could anyone help me on this statement?

-- TABLE EQUIT

USE TEMPDB

GO

CREATE TABLE Equit

(

cGroupIDINT,

cGroupIDBillableINT,

cGroupNameVARCHAR(MAX),

cGroupDescriptionVARCHAR(MAX),

cRowIDINT,

cRowNameVARCHAR(MAX),

cRowDescriptionVARCHAR(MAX),

cTransactDateSMALLDATETIME,

cTransactTypeVARCHAR(MAX),

cChargeAccountIDVARCHAR(MAX),

cChargeAccountTypeVARCHAR(MAX),

cUserWhoPrintedVARCHAR(MAX),

cDocumentNameVARCHAR(MAX),

cUnitsINT,

cDocumentIDVARCHAR(MAX),

cDeviceIPVARCHAR(MAX),

cDevModelVARCHAR(MAX),

cDevManufVARCHAR(MAX),

cDurationVARCHAR(MAX),

cDestinationVARCHAR(MAX),

cFullNameVARCHAR(MAX),

cPrimaryPINVARCHAR(MAX),

cWorkstationVARCHAR(MAX),

cAmountINT,

JobPropertiesVARCHAR(MAX),

cAltCostINT,

cDepartmentVARCHAR(MAX),

cBillableVARCHAR(MAX),

cAlternatePinVARCHAR(MAX)

)

GO

-- FORMAT...

I need the CREATE TABLE statements for each of these file types. JPG's won't do me any good. I need the code itself. You can save it...

Hi Celko,

Thank you for your message. I just submitted a download form and a message said that an Astera Software representative will be in contact shortly.

Up!!!:-D

Thanks Jeff,

I will use a directory at:

C:\Temp\Eq_files\Eq_sample_1.csv and Eq_sample_2.csv

C:\Temp\sync_files\sync_sample_1.csv and sync_sample_2.csv

C:\Temp\pcut_files\pcut_sample_1.csv and pcut_sample_2.csv

C:\Temp\sm_files\V151110456_print.csv and V1511100466_print.csv

All the files are zipped in a folder (sample files, table structure image and t-code)....

Hi Jeff,

Hope you had a great X'mas Eve!

I have to agree with you, this whole code is like a every kid's dream ;-)!

It worked perfectly, even when I don't get...

Hi Jeff,

First of all, I am impressed how helpfull you were creating this code, it is totally amazing! I am so happy to find people like you helping people like...

Great Jeff!!!

Thanks a lot! I saw it and it seems very, very complex for me to understand rigth away. I will take sometime later on to test the code you...

Hi Jeff,

Thank you for your response!

Yes, I do have multiple files, and the most important information are the Date, Equipment and the IP. This 5 lines header (considering that it...