/* SQL Insert Script Provided by DbaMgr2k 0.21.1 */ /* */ /* Generated # 24.07.2008 19:37:49 # */ /* Original database # gap # */ /* Original data table # [dbo].[HonorarFormeln] # */ /* */ /* Settings */ /* Property - Value */ /* -) SET NOCOUNT ON = Wahr */ /* -) Batch size = 1000 */ /* -) SET DATE FORMAT = ymd */ /* -) Date-Time format = {121} ODBC [yyyy-mm-dd hh:mi:ss.mmm(24h)] */ /* */ /* */ /* You are advised to check the script manually before running it. */ /* Also, BACK UP YOUR DATABASE before running this script */ /* columns of IMAGE and VARIANT data type are not supported for obvious reasons */ /* */ SET DATEFORMAT ymd /* Loading data */ SET NOCOUNT ON INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 0.0000, 100.0000, 0.0500, 129450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 5000.0000, 5000.0000, 1050.0000, 0.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 10000.0000, 1000.0000, 150.0000, 1050.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 25000.0000, 2500.0000, 150.0000, 1800.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 50000.0000, 5000.0000, 150.0000, 2700.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 500000.0000, 1.0000, 0.0200, 3450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 1000000.0000, 10.0000, 0.1400, 12450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 2000000.0000, 1.0000, 0.0100, 19450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 5000000.0000, 10.0000, 0.0500, 29450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 10000000.0000, 10.0000, 0.0300, 44450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 50000000.0000, 10.0000, 0.0100, 59450.0000 ) INSERT INTO [dbo].[HonorarFormeln] ([Tabelle], [Bis], [fj], [um], [zzgl] ) VALUES ( 'SchO-DIS', 100000000.0000, 100.0000, 0.0600, 99450.0000 ) GO -- Batch termination SET NOCOUNT OFF /* Data load has completed */ /* Sql Insert Script Provided by DbaMgr2k 0.21.1 */