sql 截取字符串
USE [Booking] GO /****** Object: Table [dbo].[Market] Script Date: 04/25/2014 14:18:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Market]( [ID] [nvarchar](50) NOT NULL, [GoodsID] [int] IDENTITY(1,1) NOT NULL, [GoodsName] [nvarchar](50) NULL, [Department] [nvarchar](50) NULL, [BookingPeople] [nvarchar](50) NULL, [Buyer] [nvarchar](50) NULL, [BookingTime] [nvarchar](50) NULL, [BookingNum] [nvarchar](50) NULL, [GoodsNum] [nvarchar](50) NULL, [GoodsPrice] [nvarchar](50) NULL, [BookingPhone] [nvarchar](50) NULL, [BookingNote] [nvarchar](50) NULL, [VerifyStatus] [nvarchar](50) NULL, [IsSubmit] [bit] NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[Market] ON INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'eb0cc365-da83-4ba5-adec-d38de60ef0b8', 35, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'91', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'fc517bd6-cfea-4418-a9dd-c2f9e85f69ad', 254, N'大肉包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'64', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'5272c277-425d-4c25-8b88-cdd0a5f96da5', 13, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'90', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bbf65e11-d661-436d-8c43-77880c2554bd', 126, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'84', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'401521d0-0c5c-4429-bfef-83e2cca77769', 123, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'86', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'e52f7b1e-aaff-4349-935a-2892174efd9b', 129, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'81', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'4370e7b8-5d5f-416c-a98f-0faa4e51b786', 130, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'5', N'100', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'1eee80e7-be3c-4917-9f34-f2cd9deb41fa', 50, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'7', N'88', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'06bf2137-8a8d-4c2d-8b98-b7112698052c', 131, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'83', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'58d07bbf-07de-4bec-9367-99c9cbbde0cb', 135, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'79', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'8604c75b-166b-4adc-8f78-5ae797a73d9b', 143, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'77', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'f0c7eb94-ccfe-4e6d-a89e-8927801717b8', 134, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'79', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'fb687f83-4aa5-45aa-9167-44c2be2c7eda', 140, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'77', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'5b0235f5-cecc-4173-9d54-0d498b3433f5', 141, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'77', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'f8893d7b-9aa5-483b-a6d9-379c74b3ea43', 142, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'77', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'4585b789-b72e-4926-a4c3-13d471e7c20f', 144, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'7', N'70', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'2ebcf410-277f-48b1-bb51-42130bbc1f49', 146, N'慕司', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'7', N'77', N'2', N'', N'葡式', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'f19498c6-2430-4591-9a22-636fd8f7c534', 147, N'切片面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'7', N'90', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'35615d9d-6f3a-43a3-a72f-feb0f9a2f323', 148, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'4', N'95', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'7243f9b4-5347-417d-98cb-52139d6be9f1', 149, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'5', N'91', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'31af4fc6-173c-49fd-abe0-dde5cb7e4cf0', 150, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'7', N'63', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'af2d7f25-2cd5-4270-896d-502b5e5e6a75', 151, N'肉松面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'4', N'85', N'4.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'553d73b4-7c43-4fe0-b103-9b80658a01a9', 152, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'56', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'5960e2cb-3e08-4d86-8c7e-7b709454cb26', 153, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'86', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bfb25d85-c67c-457d-8444-954530b12772', 154, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'81', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'67496f1b-562b-4317-8d2a-f40e170ab6cf', 155, N'肉松面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'81', N'4.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ad437319-cb06-4426-892a-d2000dfaf26c', 156, N'蛋塔', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'48', N'1', N'', N'法式', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'69c0c07d-b809-488c-8ec3-c620a4dffda9', 157, N'切片面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'83', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'751285dd-803f-4b81-b17f-6008137cc603', 158, N'慕司', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'70', N'2', N'', N'葡式', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'd91da1a0-5aa0-4201-8168-9ee5777c5dda', 159, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'55', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'84a1a790-c9ec-4fcc-98bf-b56add8cbbfc', 160, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'55', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'9d0d3d70-760f-46e1-9d72-ee33e243861f', 161, N'肉松面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'80', N'4.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bd807d1f-8084-4b8f-bdb8-596ad0f671ac', 162, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'55', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'30781f13-1e46-4c72-ab1d-ec5d65e5055b', 163, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'85', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'927a76cc-3f0e-4beb-903d-44b4f28b5240', 164, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'80', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'dfbd9380-e725-4eca-a213-05429d8232af', 166, N'切片面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'82', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ced8da9f-0e61-450e-8568-57b24d235464', 167, N'慕司', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'69', N'2', N'', N'葡式', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'13de6eae-3c62-4f71-ae58-f8fc8988fb52', 171, N'切片面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'79', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'2087b061-6beb-4fa0-8fef-fb6643e3a638', 172, N'慕司', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'5', N'68', N'2', N'', N'葡式', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'eec70251-2f93-43c7-8875-f6d06e7ca50f', 273, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'484949a9-25f0-41d2-a58c-0b40a488070f', 173, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'52', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'13961b7c-ab2e-4ddd-bc44-1db91ca53ccc', 174, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'84', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ad9d262b-cb46-4363-84cc-da939ddbf152', 175, N'面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'79', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'349d7129-e43b-43cd-8b50-440674ee935a', 176, N'肉松面包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'79', N'4.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'099ff684-3773-4947-b93d-cbf39d8a4bc9', 177, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'50', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'87207972-de00-4687-ab3b-346db870dec9', 188, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'48', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'78dc4ae1-d510-4efa-a5f6-2b2b52791180', 189, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'5', N'45', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'3f29441f-50c4-4ef7-b14c-fff3623790c2', 190, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'4', N'40', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'598c85bf-7d9e-4d52-aec4-83a517ff6884', 193, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'4', N'35', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'8c827df6-71bf-4895-8838-14cdaadddf94', 255, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'65', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'456b4899-639d-4f0e-9b51-a4ac91493330', 266, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'f7577e33-25de-4e02-b06e-f923ba370ae5', 267, N'花卷', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'4216f7da-9c7e-4c48-95e0-7e08f94d0c96', 268, N'大肉包', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'64', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'96966b22-b10d-4e02-b0fc-0b56f1c5c67d', 269, N'蛋糕', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'39', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'dc77285a-3d03-4a7b-b269-f10c6df93897', 270, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'64', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'3c1fd586-af71-4147-aab8-23bfcb0d589e', 271, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'62', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'5a145138-d675-47fd-b8b3-204c4a578041', 274, N'大肉包', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'64', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ba134ffc-6c64-4bd5-81d2-0de89a84693a', 276, N'馒头', N'机关服务中心\综合科\秦政', N'秦政', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', NULL) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'46f6ba33-7fd8-4d5f-a1e1-eda6ad421948', 277, N'花卷', N'机关服务中心\综合科\秦政', N'秦政', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', NULL) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bd59050f-93e8-4dc6-91c1-9befb01b857d', 208, N'面包', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'69', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'd0d95cc6-f00c-4bb5-8bf6-8c2e98134ee7', 209, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'85', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'e1088f60-32fd-4699-8e1e-5c169136909e', 210, N'花卷', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'76', N'1.00', N'', N'葱花', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'2fb19a29-d5fb-494b-a362-671f605affb8', 211, N'面包', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'68', N'3.00', N'', N'全麦', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bb1d08e3-4c8b-4b3d-bd18-118dab4133b0', 278, N'馒头', N'机关服务中心\综合科\秦政', N'秦政', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', NULL) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'40590980-b424-4ec4-b742-1db02811ada9', 279, N'花卷', N'机关服务中心\综合科\秦政', N'秦政', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', NULL) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'dae1e631-f3b7-4c8c-8506-2fd10c87aedd', 280, N'大肉包', N'机关服务中心\综合科\秦政', N'秦政', N'', N'04 25 2014 11:55AM', N'1', N'63', N'1.00', N'', N'无', N'审核通过', NULL) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'6ebdf54a-1c0b-4d52-8b72-85fc66e23689', 187, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'49', N'1.00', N'', N'黑米', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'3ddc7c4d-d208-499e-ac55-4988cc70f9bf', 233, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'3', N'63', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'3a2171d1-921a-433d-93a9-6c71d2f763e5', 234, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'4', N'60', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'96891f21-3026-4fda-815f-ff83d033de00', 215, N'花卷', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'4', N'65', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'a05c4acc-3048-433f-8295-2027d2d0d7fd', 235, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'2', N'56', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'5e82822d-e8db-4934-8787-d20928089278', 253, N'蛋糕', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'2', N'38', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'783d6a67-0f30-46d8-8c0e-2d77fd179e3e', 256, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'65', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'f617da9b-1e7e-494f-9b8b-3cc00bf76bd8', 257, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'74393877-2917-43ab-af55-f840494f2166', 258, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'2694a44d-3466-4444-b41f-dc111c71aef5', 259, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'63', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'267483d3-b244-4c71-b374-3c0e66b4d63c', 260, N'大肉包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'63', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'852c428d-0783-4f12-aeb5-8ca2cac7ea34', 261, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'63', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'41ac3fed-826c-4b9f-89de-7c0560ff8d57', 262, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'4', N'62', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ce09d70b-7e4c-4c1c-974c-9cca94864903', 272, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'59', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'eccff321-c7f5-4eaf-902b-836d82dd4f1e', 275, N'蛋糕', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'1', N'39', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'11707785-77a6-4ada-a6be-8f6386d2e4cb', 265, N'馒头', N'机关服务中心\综合科\田恬', N'田恬', N'', N'04 25 2014 11:55AM', N'2', N'58', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'51de295e-5c78-4875-9779-6ac47e1a98fe', 281, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'7742bb9a-ea3c-4107-90e0-cca9aa4b2f6c', 282, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'64', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'b331ecfe-7fac-4350-ad5e-340902b523d9', 283, N'大肉包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'63', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'a56538fc-8081-453a-ad45-6e0f7ca7e5ac', 285, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'54', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'1f840919-a164-4936-bdfe-0cbee3643c05', 286, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'3', N'52', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'3a69bf1f-d46b-4237-8f09-c7e41ddc7d61', 287, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'63', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'aed69812-334b-4b0e-bfda-0bc7d08ae609', 288, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'49', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'9078623e-8ecd-4bce-b4c4-25976be78c6f', 289, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'62', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'183434a7-5297-49c4-8252-77f872fae584', 290, N'大肉包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'62', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'171b11d9-d8cd-4ed8-a506-8a3604d7a897', 300, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'47', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ee0cc420-be75-4ebb-b04e-55e066d03665', 301, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'2', N'60', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'd5a92245-fc41-4f89-99db-b5c6dd2acc95', 302, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'58', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'967a9e56-99ec-432b-b51e-24c0a9ac6aab', 303, N'大肉包', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'61', N'1.00', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'ff55bd1e-9447-4f5b-93e0-01667919bb72', 305, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'57', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'bb7b77dc-1372-4945-9a00-1bd708f52dc5', 306, N'花卷', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'1', N'56', N'0.50', N'', N'无', N'审核通过', 1) INSERT [dbo].[Market] ([ID], [GoodsID], [GoodsName], [Department], [BookingPeople], [Buyer], [BookingTime], [BookingNum], [GoodsNum], [GoodsPrice], [BookingPhone], [BookingNote], [VerifyStatus], [IsSubmit]) VALUES (N'cf9953a8-eb65-4c58-94da-fb8b5a0af01b', 293, N'馒头', N'技术处\应用管理科\曹懿', N'曹懿', N'', N'04 25 2014 11:55AM', N'01', N'48', N'0.50', N'', N'无', N'审核通过', 1) SET IDENTITY_INSERT [dbo].[Market] OFF
这就是数据表
下面我们要变成这样的格式
select GoodsName,BookingPeople,BookingNum,fathdep,substring(dep,0,charindex('\', dep)) as dep,
YEAR,MONTH from (
select GoodsName,BookingPeople,BookingNum,GoodsPrice,substring(Department,0,charindex('\', Department)) as fathdep,substring(Department,charindex('\', Department) + 1,len(Department)-2) as dep,
YEAR(CONVERT(datetime,BookingTime)) as year,month(CONVERT(datetime,BookingTime)) as month
from dbo.Market where VerifyStatus='审核通过' ) as tb1
你懂了吗？纠结的表结构，害死人啊
