Treasure point help

1 Attachment(s)

Re: Treasure point help

Too lazy to create an automated query. Here's an excel file. Just copy and paste the datas in the tables TA_TREASURE_COURSE, TA_TREASURE_RT, TA_TREASURE_HOLE.

As always, have fun :D:

Re: Treasure point help

You are the hero. You saved my day again. :D

Re: Treasure point help

thanks bublastic

Re: Treasure point help

Here is the query. Thanks bubbastic :)

Code:

USE Pangya_S4_TH GO -- ---------------------------- -- Records of TA_TREASURE_COURSE -- ---------------------------- INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'0', N'Blue Lagoon', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'1', N'Blue Water', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'2', N'Sepia Wind', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'3', N'Wind Hill', null, N'5', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'4', N'Wiz Wiz', null, N'4', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'5', N'West Wiz', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'6', N'Blue Moon', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'7', N'Silvia Cannon', null, N'4', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'8', N'Ice Cannon', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'9', N'White_Wiz', null, N'3', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'10', N'Shining Sand', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'11', N'Pink Wind', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'12', N'Moon_Dummy', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'13', N'Inferno', null, N'5', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'14', N'Ice Spa', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'15', N'Lost Seaway', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'16', N'Eastern Valley', null, N'2', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'17', N'Maps', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'127', N'Random', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'138', N'TEST', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'253', N'TUTO', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_COURSE] VALUES (N'254', N'TEST', null, N'1', N'.25', null, N'1', N'y', N'2011-01-26 23:48:00.000'); GO -- ---------------------------- -- Records of TA_TREASURE_HOLE -- ---------------------------- INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-54', N'1', N'1', N'Y', N'2010-12-29 17:56:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-53', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-52', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-51', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-50', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-49', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-48', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-47', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-46', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-45', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-44', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-43', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-42', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-41', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-40', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-39', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-38', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-37', N'1', N'1', N'Y', N'2010-12-29 17:58:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-36', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-35', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-34', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-33', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-32', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-31', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-30', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-29', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-28', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-27', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-26', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-25', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-24', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-23', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-22', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-21', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-20', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-19', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-18', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-17', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-16', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-15', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-14', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-13', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-12', N'1', N'1', N'Y', N'2010-12-29 17:59:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-11', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-10', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-9', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-8', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-7', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-6', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-5', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-4', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-3', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-2', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'-1', N'1', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'0', N'0', N'1', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'1', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'2', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'3', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'4', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'5', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'6', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'7', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'8', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'9', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'10', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'11', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'12', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'13', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'14', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'15', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'16', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'17', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'18', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'19', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'20', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'21', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'22', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'23', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'24', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'25', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'26', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'27', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'28', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'29', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'30', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'31', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'32', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'33', N'0', N'0', N'Y', N'2010-12-29 18:00:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'34', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'35', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'36', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'37', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'38', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'39', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'40', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'41', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'42', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'43', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'44', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'45', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'46', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'47', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'48', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'49', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'50', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'51', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'52', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'53', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_HOLE] VALUES (N'54', N'0', N'0', N'Y', N'2010-12-29 18:01:00.000'); GO -- ---------------------------- -- Records of TA_TREASURE_RT -- ---------------------------- INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'0', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'1', N'40.00', N'1', N'y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'2', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'3', N'75.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'4', N'65.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'5', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'6', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'7', N'65.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'8', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'9', N'40.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'10', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'11', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'12', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'13', N'75.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'14', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'15', N'25.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'16', N'30.00', N'1', N'Y', N'2010-12-29 18:09:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'17', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'127', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'138', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'253', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO INSERT INTO [dbo].[TA_TREASURE_RT] VALUES (N'254', N'25.00', N'1', N'Y', N'2010-12-29 18:20:00.000'); GO

Re: Treasure point help

even the tables full I still got the following error :

Code:

Procedure or function USP_TREASURE_POINT has too many arguments specified.) CurrQuery({ call dbo.USP_TREASURE_POINT (9, 0, 0, 1, 0) })

I see in the db that it needs only 4 :

Code:

[dbo].[USP_TREASURE_POINT] ( @MAP_ID INT --맵아이디 , @SCORE INT --게임 SCORE , @EQUIP_DROP NUMERIC(5, 2) --드랍율 , @INTVAL INT = 1 -- DEFAULT (1 HOUR) )

Example :

Code:

** EXEC DBO.USP_TREASURE_POINT 3, -2, 2.1, 1

Could that be from the fact that the 3rd value is on decimal number with "2,1" insteed of "2.1" so taken as 2 vars?

Re: Treasure point help

Spoiler:

Code:

ALTER PROC [dbo].[USP_TREASURE_POINT] ( @MAP_ID INT --맵아이디 , @SCORE INT --게임 SCORE , @EQUIP_DROP1 INT --드랍율 , @EQUIP_DROP2 INT , @INTVAL INT = 1 -- DEFAULT (1 HOUR) ) -- WITH ENCRYPTION AS BEGIN /******************************************************* ** 트레져 포인트 계산 ** EXEC DBO.USP_TREASURE_POINT 3, -2, 2.1, 1 *******************************************************/ SET NOCOUNT ON -- -- SELECT @MAP_ID = 3 -- , @SCORE = -2 -- , @EQUIP_DROP = 2.1 -- , @INTVAL = 1 IF OBJECT_ID('TEMPDB..#TREASURE_STAT') IS NOT NULL DROP TABLE #TREASURE_STAT CREATE TABLE #TREASURE_STAT (MAP_ID INT, CT INT, RT NUMERIC(5, 2)) INSERT INTO #TREASURE_STAT (MAP_ID, CT, RT) EXEC DBO.USP_TREASURE_GAGE 1 -- SELECT -- MAP_ID, CT, RT -- FROM -- DBO.TD_TREASURE_STAT -- WHERE -- MOD_SEQ = (SELECT MAX(MOD_SEQ) FROM DBO.TD_TREASURE_STAT WHERE USE_YN = 'Y') DECLARE @EQUIP_DROP NUMERIC(5,2) SELECT @EQUIP_DROP = CAST(CAST(@EQUIP_DROP1 AS VARCHAR(2)) + '.' + CAST(@EQUIP_DROP2 AS VARCHAR(2)) AS NUMERIC(5,2)) SELECT TREASURE_POINT = CAST(ROUND((F.BASIC_TREASURE_POINT + @EQUIP_DROP) * (E.TREASURE_RT + E.TREASURE_ADD_RT), 0) AS INT) FROM ( SELECT C.MAP_ID , C.DIFFICULT , C.TREASURE_ADD_RT , C.TREASURE_BOX , C.C_RT , D.TREASURE_RT FROM ( SELECT MAP_ID = A.MAP_NO , A.DIFFICULT , A.TREASURE_ADD_RT , A.TREASURE_BOX , C_RT = ISNULL(B.C_RT, 0) FROM ( SELECT MAP_NO , DIFFICULT , TREASURE_ADD_RT , TREASURE_BOX FROM TA_TREASURE_COURSE WHERE MAP_NO = @MAP_ID AND USE_YN = 'Y' ) A LEFT OUTER JOIN (SELECT MAP_ID , CT , RT , C_RT = CAST(ROUND(RT + .5, 2) AS INT) FROM #TREASURE_STAT WHERE MAP_ID = @MAP_ID ) B ON A.MAP_NO = B.MAP_ID ) C INNER JOIN UVW_TREASURE_RT D ON C.C_RT BETWEEN D.S_GAGE AND D.E_GAGE ) E CROSS JOIN ( SELECT * FROM TA_TREASURE_HOLE WHERE USE_YN = 'Y' AND SCORE = @SCORE) F SET NOCOUNT OFF END

There you go cody, a workaround. Does work for me though.

Re: Treasure point help

héhé that was a nice way to do it thanks mate, nice!

Re: Treasure point help

thanks, I get it to work perfectly, no errors =)