Calculate data based on position

Hi,

I have a table "PrintArea" with below table structure.

The Details column have "\n" saperated data.

CREATE TABLE [dbo].[PrintArea](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[AccessDate] [datetime] NULL,
	[IPAddress] [varchar](16) NULL,
	[SerialNum] [varchar](256) NULL,
	[Description] [varchar](256) NULL,
	[Details] [varchar](2048) NULL,

)

This is how the data lookis like.

INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104280, CAST(0x0000A28A00A88310 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Printing', N'Headboard_Insert_4
1
1
7938
5579
396.875
400
2
None
F
F
Cyan=0.000,Magenta=0.137,Yellow=0.095,Black=0.001,LightCyan=0.181,LightMagenta=0.251,LightYellow=0.091,LightBlack=0.044')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104281, CAST(0x0000A28A00A88D9C AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104282, CAST(0x0000A28A00A88D9C AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiaIq170ZpkKzaxqj/c0ASDI=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104283, CAST(0x0000A28A00A8DAF4 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104284, CAST(0x0000A28A00A8DAF4 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Levels', N'cYx6sT0i2sBO5ZXiPimbZmUs2V9P+5gi8TX2vwUP7Uo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104285, CAST(0x0000A28A00A90524 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYGx3nHT8TqNY7bCKP1bjckGYK+dIfSvsk=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104286, CAST(0x0000A28A00A977FC AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993374
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=4.517,Magenta=5.499,Yellow=4.030,Black=1.947,LightCyan=11.324,LightMagenta=16.283,LightYellow=13.675,LightBlack=6.485')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104287, CAST(0x0000A28A00AAF028 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBbFhcmyTxsOvzgLRmjUD4ViIGBzJajhA1c=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104288, CAST(0x0000A28A00AB7368 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993857
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=4.484,Magenta=6.095,Yellow=3.869,Black=2.379,LightCyan=8.392,LightMagenta=13.095,LightYellow=10.408,LightBlack=5.369')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104289, CAST(0x0000A28A00ABF1F8 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104290, CAST(0x0000A28A00ABF57C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'Mw7LXckVtxD8DHy21fO3cx9QEQ/Cwose')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104291, CAST(0x0000A28A00AC6BD8 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Printing', N'TEST
2
1
51134
25131
508
600
1
None
F
U
Cyan=0.938,Yellow=0.872,Black=3.671,Magenta=0.869,Orange=0.220,Violet=0.203')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104292, CAST(0x0000A28A00ACE93C AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBbFhcmyTxsOv4KreEHH9uBV+QSozFd/F7Q=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104293, CAST(0x0000A28A00AD53E0 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993302
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=4.972,Magenta=5.541,Yellow=3.790,Black=2.151,LightCyan=9.089,LightMagenta=15.081,LightYellow=10.980,LightBlack=4.801')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104294, CAST(0x0000A28A00AE6618 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy654Sv3aOtCAi/MFpZXFwHA')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104295, CAST(0x0000A28A00AE699C AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104296, CAST(0x0000A28A00AE77AC AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvC2b0ZKFxGL3ThaviKReNhLrRWd3CVn8BI=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104297, CAST(0x0000A28A00AEA308 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Printing', N'TEST2
1
3
17022
50029
508
600
1
None
F
U
Cyan=0.009,Yellow=0.005,Black=11.372,Magenta=0.007,Orange=0.001,Violet=0.000')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104298, CAST(0x0000A28A00AECAE0 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBbFhcmyTxsOv4KreEHH9uBV+QSozFd/F7Q=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104299, CAST(0x0000A28A00AF0ED8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Printing', N'D3
1
8
8147
4800
793.75
400
2
Backlit Over
F
M
Cyan=3.756,Magenta=1.908,Yellow=0.177,Black=7.252,LightCyan=5.815,LightMagenta=10.010,LightYellow=7.658,LightBlack=1.919,White=34.491')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104300, CAST(0x0000A28A00AF29CC AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993992
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=6.483,Magenta=8.386,Yellow=5.454,Black=3.051,LightCyan=11.535,LightMagenta=17.199,LightYellow=13.634,LightBlack=7.630')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104301, CAST(0x0000A28A00B0430C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104302, CAST(0x0000A28A00B0430C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'e+opnKN7FMPRbSNiczTnZPZvQtqKmZs3')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104303, CAST(0x0000A28A00B055CC AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'MpQwKw+ccVkIDLX2wr0wwAhvNn7q+9kDkwP+9RagMjE=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104304, CAST(0x0000A28A00B0A1F8 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBbFhcmyTxsOvzgLRmjUD4ViIGBzJajhA1c=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104305, CAST(0x0000A28A00B15B20 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993713
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=2.333,Magenta=3.185,Yellow=2.195,Black=0.752,LightCyan=8.004,LightMagenta=11.602,LightYellow=9.019,LightBlack=4.167')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104306, CAST(0x0000A28A00B2CFC8 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBbFhcmyTxsOv4KreEHH9uBV+QSozFd/F7Q=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104307, CAST(0x0000A28A00B2D5A4 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Started', N'A002.002c22 - T001.001g')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104308, CAST(0x0000A28A00B31744 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993978
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=3.771,Magenta=5.415,Yellow=3.069,Black=1.697,LightCyan=7.475,LightMagenta=10.712,LightYellow=9.052,LightBlack=5.008')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104309, CAST(0x0000A28A00B4459C AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Printing', N'D3
1
8
8147
4800
793.75
400
2
Backlit Under
F
M
Cyan=3.756,Magenta=1.908,Yellow=0.177,Black=7.252,LightCyan=5.815,LightMagenta=10.010,LightYellow=7.658,LightBlack=1.919,White=34.491')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104310, CAST(0x0000A28A00B48BEC AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYN1GiDAhjeUPkeBWdpVfSk4//PNjRQvZk=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104311, CAST(0x0000A28A00B4D944 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993972
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=4.782,Magenta=5.041,Yellow=4.219,Black=1.831,LightCyan=12.066,LightMagenta=16.064,LightYellow=11.802,LightBlack=6.482')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104312, CAST(0x0000A28A00B57520 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Printing', N'INLINE_GC_Purple_Solid_Door
1
1
58787
18400
793.75
400
2
None
F
F
Cyan=3.855,Magenta=26.574,Yellow=0.010,Black=0.091,LightCyan=25.846,LightMagenta=0.000,LightYellow=1.410,LightBlack=4.699')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104313, CAST(0x0000A28A00B5C020 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104314, CAST(0x0000A28A00B5C020 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiUe1jYecg4Dhzh39Mtif9ek=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104315, CAST(0x0000A28A00B61480 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104316, CAST(0x0000A28A00B624E8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104317, CAST(0x0000A28A00B624E8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiSb3EH1l4uKX0E+/KI0R2hI=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104318, CAST(0x0000A28A00B65170 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYN1GiDAhjeUPkeBWdpVfSk4//PNjRQvZk=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104319, CAST(0x0000A28A00B683D4 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104320, CAST(0x0000A28A00B690B8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiSb3EH1l4uKXGRJv4K7ULNU=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104321, CAST(0x0000A28A00B6CDA8 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Levels', N'cYx6sT0i2sBO5ZXiPimbZmUs2V9P+5gi8TX2vwUP7Uo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104322, CAST(0x0000A28A00B6E194 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i993678
1
1
65088
19600
793.75
400
4
None
F
M
Cyan=11.154,Magenta=10.522,Yellow=7.888,Black=7.081,LightCyan=7.378,LightMagenta=10.503,LightYellow=8.166,LightBlack=5.893')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104323, CAST(0x0000A28A00B735F4 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104324, CAST(0x0000A28A00B74404 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiUe1jYecg4DhH9ivL/lsfUo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104325, CAST(0x0000A28A00B77D70 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Printing', N'D3
1
8
8147
4800
793.75
400
2
Backlit Under
F
M
Cyan=3.756,Magenta=1.908,Yellow=0.177,Black=7.252,LightCyan=5.815,LightMagenta=10.010,LightYellow=7.658,LightBlack=1.919,White=34.491')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104326, CAST(0x0000A28A00B7D2FC AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCApzWfe35iiUe1jYecg4DhH9ivL/lsfUo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104327, CAST(0x0000A28A00B8DAA8 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Printing', N'INLINE_GC_Purple_Solid_Door
1
1
58787
18400
793.75
400
2
None
F
F
Cyan=3.855,Magenta=26.574,Yellow=0.010,Black=0.091,LightCyan=25.846,LightMagenta=0.000,LightYellow=1.410,LightBlack=4.699')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104328, CAST(0x0000A28A00B8FDD0 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104329, CAST(0x0000A28A00B90280 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy654Sv3aOtCAi/MFpZXFwHA')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104330, CAST(0x0000A28A00B93868 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Started', N'A002.002c22 - T001.001g')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104331, CAST(0x0000A28A00B97D8C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Printing', N'TEST3
2
1
51134
25131
508
600
1
None
F
U
Cyan=1.268,Yellow=1.200,Black=4.648,Magenta=1.409,Orange=0.368,Violet=0.172')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104332, CAST(0x0000A28A00B9AFF0 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBZBf2UrYSkFHx1NdKTjeGvH5uZtUbBuhZA=')
GO
print 'Processed 103300 total records'
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104333, CAST(0x0000A28A00B9D570 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i994183
1
1
65088
19600
793.75
400
4
None
F
M
Cyan=7.073,Magenta=8.388,Yellow=5.517,Black=4.248,LightCyan=9.619,LightMagenta=13.174,LightYellow=11.153,LightBlack=6.688')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104334, CAST(0x0000A28A00BA3204 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Levels', N'cYx6sT0i2sBO5ZXiPimbZmUs2V9P+5gi8TX2vwUP7Uo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104335, CAST(0x0000A28A00BA9474 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Printing', N'91327
1
1
45821
18291
793.75
400
2
None
F
M
Cyan=4.262,Magenta=4.626,Yellow=3.826,Black=4.257,LightCyan=9.694,LightMagenta=10.641,LightYellow=10.360,LightBlack=8.035')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104336, CAST(0x0000A28A00BAB8C8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104337, CAST(0x0000A28A00BAC6D8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCWoC9AVXnpodMLt9UDlRhZEKAE0wziu2Q=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104338, CAST(0x0000A28A00BB0E54 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Printing', N'INLINE_GC_Purple_Solid_Door
1
1
58787
18400
793.75
400
2
None
F
F
Cyan=3.855,Magenta=26.574,Yellow=0.010,Black=0.091,LightCyan=25.846,LightMagenta=0.000,LightYellow=1.410,LightBlack=4.699')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104339, CAST(0x0000A28A00BB8960 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy654Sv3aOtCAi/MFpZXFwHA')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104340, CAST(0x0000A28A00BBB5E8 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104341, CAST(0x0000A28A00BBC524 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCWoC9AVXnpoUvPjhkQyKAQdrLCeK96Y6A=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104342, CAST(0x0000A28A00BBF788 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Levels', N'7PR/zU52552WSE34/uEI7EaRn7Byb++Ad2bZbwQbUyw=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104343, CAST(0x0000A28A00BC6484 AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Levels', N'cYx6sT0i2sBO5ZXiPimbZmUs2V9P+5gi8TX2vwUP7Uo=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104344, CAST(0x0000A28A00BC8C5C AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Printing', N'91327
2
1
45821
18291
793.75
400
2
None
F
M
Cyan=8.524,Magenta=9.252,Yellow=7.652,Black=8.514,LightCyan=19.387,LightMagenta=21.282,LightYellow=20.720,LightBlack=16.070')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104345, CAST(0x0000A28A00BC9490 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104346, CAST(0x0000A28A00BCA2A0 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCWoC9AVXnpoUvPjhkQyKAQdrLCeK96Y6A=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104347, CAST(0x0000A28A00BCA3CC AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYN1GiDAhjeUGLVwfHw2RjVLp/z075d/n4=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104348, CAST(0x0000A28A00BCD630 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i994638
1
1
65088
19600
793.75
400
4
None
F
M
Cyan=9.238,Magenta=9.306,Yellow=7.194,Black=6.355,LightCyan=8.312,LightMagenta=10.537,LightYellow=7.874,LightBlack=4.572')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104349, CAST(0x0000A28A00BE5438 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104350, CAST(0x0000A28A00BE6374 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104351, CAST(0x0000A28A00BE6374 AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'wKKc2S9XrvCWoC9AVXnpoRqPLwfvSFVLrOqTbkAm4K8=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104352, CAST(0x0000A28A00BEC008 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Levels', N'7PR/zU52552WSE34/uEI7OOJ4yLem84zbaA/tW9/HU8=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104353, CAST(0x0000A28A00BED8A4 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Started', N'A002.002c22 - T001.001g')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104354, CAST(0x0000A28A00BF08B0 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104355, CAST(0x0000A28A00BF0E8C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy7evCk4vg+jcgRMk1jV3CEM')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104356, CAST(0x0000A28A00BF1EF4 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Printing', N'91327
2
1
45821
18291
793.75
400
2
None
F
M
Cyan=8.524,Magenta=9.252,Yellow=7.652,Black=8.514,LightCyan=19.387,LightMagenta=21.282,LightYellow=20.720,LightBlack=16.070')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104357, CAST(0x0000A28A00BF24D0 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104358, CAST(0x0000A28A00BF2980 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy7evCk4vg+jcgRMk1jV3CEM')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104359, CAST(0x0000A28A00BF5284 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Printing', N'ALL
1
1
41101
123971
508
800
1
None
F
U
Cyan=115.369,Yellow=0.136,Black=12.967,Magenta=3.018,Orange=0.000,Violet=76.270')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104360, CAST(0x0000A28A00BF7354 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104361, CAST(0x0000A28A00BF7354 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'r0gbW/D8hy654Sv3aOtCAi/MFpZXFwHA')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104362, CAST(0x0000A28A00BF7B88 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Levels', N'7PR/zU52552WSE34/uEI7LUBPuxsX765FIdtue2dEo0=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104363, CAST(0x0000A28A00BF9B2C AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Printing', N'ALL
1
1
41101
123971
508
800
1
None
F
U
Cyan=115.369,Yellow=0.136,Black=12.967,Magenta=3.018,Orange=0.000,Violet=76.270')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104364, CAST(0x0000A28A00BFA5B8 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBZBf2UrYSkFHx1NdKTjeGvH5uZtUbBuhZA=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104365, CAST(0x0000A28A00BFB29C AS DateTime), N'71.250.247.242', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'EndJob', N'False')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104366, CAST(0x0000A28A00BFC0AC AS DateTime), N'71.250.247.242', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Levels', N'IsaYfKzOcm38f03/IF4LaCQyEfF7l+cYJ67DDzwzfzQ=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104367, CAST(0x0000A28A00BFD36C AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Printing', N'91327
1
1
45821
18291
793.75
400
1
None
F
M
Cyan=4.262,Magenta=4.626,Yellow=3.826,Black=4.257,LightCyan=9.694,LightMagenta=10.641,LightYellow=10.360,LightBlack=8.035')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104368, CAST(0x0000A28A00C0150C AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i995097
1
1
65088
19600
793.75
400
4
None
F
M
Cyan=10.962,Magenta=11.926,Yellow=8.646,Black=7.105,LightCyan=7.416,LightMagenta=10.633,LightYellow=8.962,LightBlack=6.311')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104369, CAST(0x0000A28A00C0EF04 AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Levels', N'7PR/zU52552WSE34/uEI7OOJ4yLem84zbaA/tW9/HU8=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104370, CAST(0x0000A28A00C2E368 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYN1GiDAhjeUPkeBWdpVfSk4//PNjRQvZk=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104371, CAST(0x0000A28A00C3495C AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i996545
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=3.429,Magenta=5.148,Yellow=3.483,Black=1.626,LightCyan=7.968,LightMagenta=11.695,LightYellow=9.183,LightBlack=5.203')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104372, CAST(0x0000A28A00C3C7EC AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'InkLevels', N'Need to check system date')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104373, CAST(0x0000A28A00C3CB70 AS DateTime), N'173.15.66.221', N'Global Imaging Inc-bc05e335-96af-4673-8598-aad190db9484', N'Levels', N'Mw7LXckVtxAXCPWC+zB3lghptIWHCuhN')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104374, CAST(0x0000A28A00C4BCD8 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBYN1GiDAhjeUPkeBWdpVfSk4//PNjRQvZk=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104375, CAST(0x0000A28A00C4FFA4 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i996054
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=4.181,Magenta=5.282,Yellow=3.564,Black=2.053,LightCyan=7.436,LightMagenta=11.819,LightYellow=9.550,LightBlack=4.909')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104376, CAST(0x0000A28A00C67578 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Levels', N'6sFVC5vVSBZBf2UrYSkFHx1NdKTjeGvH5uZtUbBuhZA=')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104377, CAST(0x0000A28A00C7EB4C AS DateTime), N'70.90.228.250', N'Brand Imaging-57956e8d-06cc-4694-a310-6f78ada39ea5-YM133S000318,BFEBFBFF000306A9', N'Printing', N'line6_print2
4
1
45821
18291
793.75
400
1
None
F
M
Cyan=35.400,Magenta=24.448,Yellow=15.294,Black=27.064,LightCyan=27.020,LightMagenta=35.995,LightYellow=40.940,LightBlack=29.670')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104378, CAST(0x0000A28A00C93CCC AS DateTime), N'70.89.39.161', N'InSign-f529c824-85a6-4a64-8c59-e9f786d718f3-YM2AS31367,BFEBFBFF000306A9', N'Printing', N'INLINE_GC_Purple_Solid_Door
1
1
58787
18400
793.75
400
2
None
F
F
Cyan=3.855,Magenta=26.574,Yellow=0.010,Black=0.091,LightCyan=25.846,LightMagenta=0.000,LightYellow=1.410,LightBlack=4.699')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104379, CAST(0x0000A28A00CA191C AS DateTime), N'173.220.122.114', N'Polytype - NJ-99a9f6fd-1bf0-42ee-b708-a8dec5b893f8-YM2AS31481,BFEBFBFF000306A9', N'Printing', N'test_800x400
1
1
70644
15200
793.75
400
2
None
F
M
Cyan=7.870,Magenta=3.439,Yellow=15.627,Black=9.191,LightCyan=20.615,LightMagenta=22.268,LightYellow=10.255,LightBlack=15.032')
INSERT [dbo].[PrintArea] ([ID], [AccessDate], [IPAddress], [SerialNum], [Description], [Details]) VALUES (104380, CAST(0x0000A28A00CA9554 AS DateTime), N'65.121.240.194', N'Colorado Timberline-f1cacd73-6db5-4e98-a1dc-64a28697f525-YM2AS31922,BFEBFBFF000306A9', N'Printing', N'md16_i996294
1
1
65088
19600
793.75
400
2
None
F
M
Cyan=6.617,Magenta=7.383,Yellow=6.148,Black=3.614,LightCyan=11.110,LightMagenta=14.212,LightYellow=11.104,LightBlack=7.986')

I want to calculate totalAreaPrinted based on below  formula from Details column.

Can someone please help.

Thanks

June 4th, 2015 3:22pm

You would need a split function to split the Details column, you can find lots of them by googling "SQL Server Split Function".  One possibility is 

CREATE FUNCTION dbo.Split (@DelimitedString nvarchar(max), @Delimiter nvarchar(max))
RETURNS table
/* Use Option(MaxRecursion 0) in queries that call this function if 
   there can be more than 99 delimited values in @DelimitedString */
AS
RETURN (
    WITH Pieces (ID, start, stop) AS (
      SELECT CAST(1 AS bigint), CAST(1 AS bigint), CAST(CHARINDEX(@Delimiter, @DelimitedString) AS bigint)
      UNION ALL
      SELECT ID + 1, CAST(stop + DATALENGTH(@Delimiter)/2 As bigint), CAST(CHARINDEX(@Delimiter, @DelimitedString, stop + DATALENGTH(@Delimiter)/2) AS bigint)
      FROM Pieces
      WHERE stop > 0
    )
    SELECT ID,
      SUBSTRING(@DelimitedString, start, CASE WHEN stop > 0 THEN stop-start ELSE LEN(@DelimitedString) END) AS Element
    FROM Pieces
  )
GO

It looks like in your sample data only the rows with Description = 'Printing' have the multiple values you are looking for.  So you could do something like

;With cteSplit As
(Select p.ID, p.AccessDate, p.IPAddress, p.SerialNum, p.Description, p.Details, s.ID As SplitID, s.Element
From PrintArea p
Cross Apply dbo.Split(Replace(p.Details, 0x0D0A, ','), ',') As s
Where p.Description = 'Printing' And s.ID In (2,3,4,5,6,7) ),

ctePivot As
(Select ID, AccessDate, IPAddress, SerialNum, Description, Details, 
  Cast([2] As decimal(10,3)) As Rows,
  Cast([3] As decimal(10,3)) As Columns,
  Cast([4] As decimal(10,3)) As Width,
  Cast([5] As decimal(10,3)) As Height,
  Cast([6] As decimal(10,3)) As HDPI,
  Cast([7] As decimal(10,3)) As VDPI
From cteSplit
Pivot (Max(Element) For SplitID In ([2],[3],[4],[5],[6],[7])) pvt)
Select ID, AccessDate, IPAddress, SerialNum, Description, Details, 
  ((Height / VDPI)/12) * ((Width / HDPI) / 12)* Rows * Columns As TotalPrintArea
From ctePivot
Option (MaxRecursion 0);
Tom
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2015 11:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics