[Conny Westh]

Här kommer lite SQL-kod som jag testat i MS SQL-server 2008 R2, har sånt sabla problem att få MySQL 5.5.28.2 att fungera.

-- Följande är SQL för att skapa tabellen LevelDefinitions i MSSQL-server 2008 R2
USE [wntest]
GO

/****** Object:  Table [dbo].[LevelDefinition]    Script Date: 10/04/2012 20:42:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- Skapa tabellen med DDL-script
CREATE TABLE [dbo].[LevelDefinition](
	[Level] [int] NOT NULL,
	[LowValue] [int] NULL,
	[HighValue] [int] NULL,
 CONSTRAINT [PK_LevelDefinition] PRIMARY KEY CLUSTERED 
(
	[Level] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

-- Lägg upp definitionen av alla tabellerna
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 1000,1000,999999
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 500,500,999
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 200,200,499
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 100,100,199
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 50,50,99
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 10,10,49
INSERT INTO [dbo].[LevelDefinition] ([Level],[LowValue],[HighValue])
SELECT 0,0,9
GO

-- kolla innehållet i hela tabellen, så det ser ut att vara OK
select * from LevelDefinition

-- Så här får man fram rätt LEVEL
select Max(Level) from LevelDefinition where 75>=LowValue;