[SQL] TA_CARDPACK_ITEM & TA_CARDPACK_ACC Tables

[Acardia]

Heres All The Cards Minus The Consumable Ones

Spoiler

USE [Pangya_S4_TH]
GO
/****** Object: Table [dbo].[TA_CARDPACK_ITEM] Script Date: 02/24/2011 18:49:27 ******/
SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ITEM] ON
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374784, 1, 1, 3, CAST(0.100 AS Numeric(8, 3)), N'Y', 3, CAST(0x9E9303BF AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374785, 1, 1, 6, CAST(0.099 AS Numeric(8, 3)), N'Y', 6, CAST(0x9E9303C1 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374788, 1, 1, 7, CAST(0.100 AS Numeric(8, 3)), N'Y', 7, CAST(0x9E9303C3 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374789, 1, 1, 8, CAST(0.099 AS Numeric(8, 3)), N'Y', 8, CAST(0x9E9303C5 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374790, 1, 1, 9, CAST(0.098 AS Numeric(8, 3)), N'Y', 9, CAST(0x9E9303DE AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374792, 1, 1, 10, CAST(0.100 AS Numeric(8, 3)), N'Y', 10, CAST(0x9E9303E1 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374796, 1, 1, 11, CAST(0.100 AS Numeric(8, 3)), N'Y', 11, CAST(0x9E9303E3 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374797, 1, 1, 12, CAST(0.099 AS Numeric(8, 3)), N'Y', 12, CAST(0x9E9303E4 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374800, 1, 1, 13, CAST(0.100 AS Numeric(8, 3)), N'Y', 13, CAST(0x9E9303E8 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374801, 1, 1, 14, CAST(0.099 AS Numeric(8, 3)), N'Y', 14, CAST(0x9E9303E9 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374802, 1, 1, 15, CAST(0.098 AS Numeric(8, 3)), N'Y', 15, CAST(0x9E9303EC AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374804, 1, 1, 16, CAST(0.100 AS Numeric(8, 3)), N'Y', 16, CAST(0x9E9303F0 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374805, 1, 1, 17, CAST(0.099 AS Numeric(8, 3)), N'Y', 17, CAST(0x9E9303F4 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374806, 1, 1, 18, CAST(0.098 AS Numeric(8, 3)), N'Y', 18, CAST(0x9E9303F5 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374808, 1, 1, 19, CAST(0.100 AS Numeric(8, 3)), N'Y', 19, CAST(0x9E9303FF AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374809, 1, 1, 20, CAST(0.099 AS Numeric(8, 3)), N'Y', 20, CAST(0x9E930409 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374810, 1, 1, 21, CAST(0.098 AS Numeric(8, 3)), N'Y', 21, CAST(0x9E930409 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374812, 1, 1, 22, CAST(0.100 AS Numeric(8, 3)), N'Y', 22, CAST(0x9E930411 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2080374813, 1, 1, 23, CAST(0.099 AS Numeric(8, 3)), N'Y', 23, CAST(0x9E930413 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569088, 1, 1, 24, CAST(0.100 AS Numeric(8, 3)), N'Y', 24, CAST(0x9E930422 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569089, 1, 1, 25, CAST(0.099 AS Numeric(8, 3)), N'Y', 25, CAST(0x9E930428 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569092, 1, 1, 26, CAST(0.100 AS Numeric(8, 3)), N'Y', 26, CAST(0x9E93042A AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569096, 1, 1, 27, CAST(0.099 AS Numeric(8, 3)), N'Y', 27, CAST(0x9E93043F AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569104, 1, 1, 28, CAST(0.100 AS Numeric(8, 3)), N'Y', 28, CAST(0x9E930442 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569105, 1, 1, 29, CAST(0.099 AS Numeric(8, 3)), N'Y', 29, CAST(0x9E930443 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569106, 1, 1, 30, CAST(0.098 AS Numeric(8, 3)), N'Y', 30, CAST(0x9E930444 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569108, 1, 1, 31, CAST(0.100 AS Numeric(8, 3)), N'Y', 31, CAST(0x9E930446 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569109, 1, 1, 32, CAST(0.099 AS Numeric(8, 3)), N'Y', 32, CAST(0x9E930448 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569112, 1, 1, 33, CAST(0.098 AS Numeric(8, 3)), N'Y', 33, CAST(0x9E930449 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957696, 2084569113, 1, 1, 34, CAST(0.097 AS Numeric(8, 3)), N'Y', 34, CAST(0x9E930449 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374787, 1, 1, 35, CAST(0.098 AS Numeric(8, 3)), N'Y', 35, CAST(0x9E93044E AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374791, 1, 1, 36, CAST(0.097 AS Numeric(8, 3)), N'Y', 36, CAST(0x9E93044F AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374793, 1, 1, 39, CAST(0.099 AS Numeric(8, 3)), N'Y', 39, CAST(0x9E930450 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374794, 1, 1, 40, CAST(0.098 AS Numeric(8, 3)), N'Y', 40, CAST(0x9E930452 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374814, 1, 1, 41, CAST(0.098 AS Numeric(8, 3)), N'Y', 41, CAST(0x9E930454 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374816, 1, 1, 42, CAST(0.100 AS Numeric(8, 3)), N'Y', 42, CAST(0x9E930467 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374817, 1, 1, 43, CAST(0.099 AS Numeric(8, 3)), N'Y', 43, CAST(0x9E930468 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374818, 1, 1, 44, CAST(0.100 AS Numeric(8, 3)), N'Y', 44, CAST(0x9E93046A AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374819, 1, 1, 45, CAST(0.099 AS Numeric(8, 3)), N'Y', 45, CAST(0x9E93046D AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374820, 1, 1, 46, CAST(0.100 AS Numeric(8, 3)), N'Y', 46, CAST(0x9E930470 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374821, 1, 1, 47, CAST(0.100 AS Numeric(8, 3)), N'Y', 47, CAST(0x9E930470 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374822, 1, 1, 48, CAST(0.100 AS Numeric(8, 3)), N'Y', 48, CAST(0x9E930471 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2080374823, 1, 1, 49, CAST(0.100 AS Numeric(8, 3)), N'Y', 49, CAST(0x9E930473 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569090, 1, 1, 51, CAST(0.098 AS Numeric(8, 3)), N'Y', 51, CAST(0x9E93047D AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569098, 1, 1, 52, CAST(0.097 AS Numeric(8, 3)), N'Y', 52, CAST(0x9E93047E AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569099, 1, 1, 53, CAST(0.100 AS Numeric(8, 3)), N'Y', 53, CAST(0x9E930480 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569100, 1, 1, 54, CAST(0.100 AS Numeric(8, 3)), N'Y', 54, CAST(0x9E930481 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569101, 1, 1, 55, CAST(0.099 AS Numeric(8, 3)), N'Y', 55, CAST(0x9E930482 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569110, 1, 1, 56, CAST(0.098 AS Numeric(8, 3)), N'Y', 56, CAST(0x9E930483 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569115, 1, 1, 57, CAST(0.100 AS Numeric(8, 3)), N'Y', 57, CAST(0x9E930484 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569116, 1, 1, 58, CAST(0.100 AS Numeric(8, 3)), N'Y', 58, CAST(0x9E930486 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569117, 1, 1, 59, CAST(0.100 AS Numeric(8, 3)), N'Y', 59, CAST(0x9E930488 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569118, 1, 1, 60, CAST(0.099 AS Numeric(8, 3)), N'Y', 60, CAST(0x9E930489 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569119, 1, 1, 61, CAST(0.100 AS Numeric(8, 3)), N'Y', 61, CAST(0x9E930489 AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569120, 1, 1, 62, CAST(0.099 AS Numeric(8, 3)), N'Y', 62, CAST(0x9E93048A AS SmallDateTime), 3)
INSERT [dbo].[TA_CARDPACK_ITEM] ([PACK_TYPEID], [CARD_TYPEID], [QTY], [RARETYPE], [SEQ], [PROB], [USE_YN], [MOD_SEQ], [MOD_DT], [card_type]) VALUES (2092957700, 2084569121, 1, 1, 63, CAST(0.099 AS Numeric(8, 3)), N'Y', 63, CAST(0x9E93048B AS SmallDateTime), 3)
SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ITEM] OFF

Spoiler

USE [Pangya_S4_TH]
GO
/****** Object: Table [dbo].[TA_CARDPACK_ACC] Script Date: 02/24/2011 18:55:15 ******/
SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ACC] ON
INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957696, 1, N'2092957696', NULL, 3, N'Y', CAST(0x9E930396 AS SmallDateTime))
INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957697, 5, N'2092957697', NULL, 1, N'Y', CAST(0x9E9303AA AS SmallDateTime))
INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957698, 4, N'2092957698', NULL, 1, N'Y', CAST(0x9E93039D AS SmallDateTime))
INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957699, 3, N'2092957699', NULL, 1, N'Y', CAST(0x9E93039D AS SmallDateTime))
INSERT [dbo].[TA_CARDPACK_ACC] ([PACK_TYPEID], [SEQ], [PACK_NM_KR], [PACK_NM_EN], [OUTQTY], [USE_YN], [IN_DATE]) VALUES (2092957700, 2, N'2092957700', NULL, 3, N'Y', CAST(0x9E930397 AS SmallDateTime))
SET IDENTITY_INSERT [dbo].[TA_CARDPACK_ACC] OFF

 

[o800920]

Re: TA_CARDPACK_ITEM Tables

Good thanks very much

 

[Tsukasa]

Re: TA_CARDPACK_ITEM Tables

Generate a query from this. Posting values like this is practically useless.

 

[Acardia]

Re: TA_CARDPACK_ITEM Tables

Generate a query from this. Posting values like this is practically useless.

i looked all over for how to Generate a query but couldnt find anything

 

[Tsukasa]

Re: TA_CARDPACK_ITEM Tables

If you fancy a Management Studio solution,

You must be registered to see links

works fine for INSERTs (see The Matt's answer), although it doesn't generate optional UPDATE statements (so it's kind of bleh). Navicat can do the same but also doesn't produce UPDATE statements (so it's kind of bleh too). Feel free to check the other answers given on StackOverflow to see which one suits you best.

Ideally you'd do the handiwork and edit the resulting queries to optionally update existing rows (if present). It's more work - but this is the Releases forum (not DIY), so we should strive for the best quality possible. If you feel that's too much work, at least include conditional DELETE statements to make sure existing rows get dropped before being inserted anew.

 

[Acardia]

Re: TA_CARDPACK_ITEM Tables

If you fancy a Management Studio solution,

You must be registered to see links

works fine for INSERTs (see The Matt's answer), although it doesn't generate optional UPDATE statements (so it's kind of bleh). Navicat can do the same but also doesn't produce UPDATE statements (so it's kind of bleh too). Feel free to check the other answers given on StackOverflow to see which one suits you best.

Ideally you'd do the handiwork and edit the resulting queries to optionally update existing rows (if present). It's more work - but this is the Releases forum (not DIY), so we should strive for the best quality possible. If you feel that's too much work, at least include conditional DELETE statements to make sure existing rows get dropped before being inserted anew.

Thanks Tsukasa Im Updating Now