Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 need help on sql

Author  Topic 

Idyana
Yak Posting Veteran

96 Posts
Posted - 2011-09-23 : 03:48:49
I've script as following,

/****** Object:  Table [dbo].[Hijrah]    Script Date: 09/22/2011 20:35:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Hijrah](
	[date_start] [smalldatetime] NULL,
	[nama_bulan] [varchar](40) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x906E0000 AS SmallDateTime), N'Muharram 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x908C0000 AS SmallDateTime), N'Safar 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90A90000 AS SmallDateTime), N'RabiulAwal 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90C70000 AS SmallDateTime), N'RabiulAkhir 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90E40000 AS SmallDateTime), N'JamadilAwal 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91010000 AS SmallDateTime), N'JamadilAkhir 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x911F0000 AS SmallDateTime), N'Rejab 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x913C0000 AS SmallDateTime), N'Syaaban 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x915A0000 AS SmallDateTime), N'Ramadhan 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91770000 AS SmallDateTime), N'Syawal 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91950000 AS SmallDateTime), N'Zulkaedah 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91B30000 AS SmallDateTime), N'Zulhijjah 1422')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91D00000 AS SmallDateTime), N'Muharram 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x91EE0000 AS SmallDateTime), N'Safar 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x920C0000 AS SmallDateTime), N'RabiulAwal 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92290000 AS SmallDateTime), N'RabiulAkhir 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92470000 AS SmallDateTime), N'JamadilAwal 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92640000 AS SmallDateTime), N'JamadilAkhir 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92810000 AS SmallDateTime), N'Rejab 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x929F0000 AS SmallDateTime), N'Syaaban 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92BC0000 AS SmallDateTime), N'Ramadhan 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92DA0000 AS SmallDateTime), N'Syawal 1423 ')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x92F70000 AS SmallDateTime), N'Zulkaedah 1423')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93150000 AS SmallDateTime), N'Zulhijjah 1423')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90330000 AS SmallDateTime), N'Zulkaedah 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90510000 AS SmallDateTime), N'Zulhijjah 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8FDA0000 AS SmallDateTime), N'Syaaban 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8E950000 AS SmallDateTime), N'Ramadhan 1420')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8EB30000 AS SmallDateTime), N'Syawal 1420')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8ED10000 AS SmallDateTime), N'Zulkaedah 1420')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8EEF0000 AS SmallDateTime), N'Zulhijjah 1420')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F0C0000 AS SmallDateTime), N'Muharram 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F2A0000 AS SmallDateTime), N'Safar 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F470000 AS SmallDateTime), N'RabiulAwal 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F640000 AS SmallDateTime), N'RabiulAkhir 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F810000 AS SmallDateTime), N'JamadilAwal 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8F9F0000 AS SmallDateTime), N'JamadilAkhir 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8FBC0000 AS SmallDateTime), N'Rejab 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x8FF70000 AS SmallDateTime), N'Ramadhan 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x90150000 AS SmallDateTime), N'Syawal 1421')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93320000 AS SmallDateTime), N'Muharram 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93500000 AS SmallDateTime), N'Safar 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x936E0000 AS SmallDateTime), N'RabiulAwal 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x938C0000 AS SmallDateTime), N'RabiulAkhir 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93A90000 AS SmallDateTime), N'JamadilAwal 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93C60000 AS SmallDateTime), N'JamadilAkhir 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x93E40000 AS SmallDateTime), N'Rejab 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94010000 AS SmallDateTime), N'Syaaban 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x941F0000 AS SmallDateTime), N'Ramadhan 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x943C0000 AS SmallDateTime), N'Syawal 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x945A0000 AS SmallDateTime), N'Zulkaedah 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94770000 AS SmallDateTime), N'Zulhijjah 1424')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94950000 AS SmallDateTime), N'Muharram 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94B20000 AS SmallDateTime), N'Safar 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94D00000 AS SmallDateTime), N'RabiulAwal 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x94EE0000 AS SmallDateTime), N'RabiulAkhir 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x950B0000 AS SmallDateTime), N'JamadilAwal 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95290000 AS SmallDateTime), N'JamadilAkhir 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95460000 AS SmallDateTime), N'Rejab 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95640000 AS SmallDateTime), N'Syaaban 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95810000 AS SmallDateTime), N'Ramadhan 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x959F0000 AS SmallDateTime), N'Syawal 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95BC0000 AS SmallDateTime), N'Zulkaedah 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95DA0000 AS SmallDateTime), N'Zulhijjah 1425')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x95F70000 AS SmallDateTime), N'Muharam 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96150000 AS SmallDateTime), N'Safar 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96320000 AS SmallDateTime), N'RabiulAwal 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96500000 AS SmallDateTime), N'RabiulAkhir 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x966D0000 AS SmallDateTime), N'JamadilAwal 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x968B0000 AS SmallDateTime), N'JamadilAkhir 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96A80000 AS SmallDateTime), N'Rejab 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96C60000 AS SmallDateTime), N'Syaaban 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x96E40000 AS SmallDateTime), N'Ramadhan 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97010000 AS SmallDateTime), N'Syawal 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x971F0000 AS SmallDateTime), N'Zulkaedah 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x973D0000 AS SmallDateTime), N'Zulhijjah 1426')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x975A0000 AS SmallDateTime), N'Muharram 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97780000 AS SmallDateTime), N'Safar 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97950000 AS SmallDateTime), N'RabiulAwal 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97B20000 AS SmallDateTime), N'RabiulAkhir 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97D00000 AS SmallDateTime), N'JamadilAwal 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x97ED0000 AS SmallDateTime), N'JamadilAkhir 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x980A0000 AS SmallDateTime), N'Rejab 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98280000 AS SmallDateTime), N'Syaaban 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98460000 AS SmallDateTime), N'Ramadhan 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98640000 AS SmallDateTime), N'Syawal 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98810000 AS SmallDateTime), N'Zulkaedah 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x989F0000 AS SmallDateTime), N'Zulhijjah 1427')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98BC0000 AS SmallDateTime), N'Muharam 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98DA0000 AS SmallDateTime), N'Safar 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x98F70000 AS SmallDateTime), N'RabiulAwal 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x99150000 AS SmallDateTime), N'RabiulAkhir 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x99320000 AS SmallDateTime), N'JamadilAwal 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x994F0000 AS SmallDateTime), N'JamadilAkhir 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x996D0000 AS SmallDateTime), N'Rejab 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x998A0000 AS SmallDateTime), N'Syaaban 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x99A80000 AS SmallDateTime), N'Ramadhan 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x99C60000 AS SmallDateTime), N'Syawal 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x99E30000 AS SmallDateTime), N'Zulkaedah 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A010000 AS SmallDateTime), N'Zulhijjah 1428')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A1F0000 AS SmallDateTime), N'Muharam 1429')
GO
print 'Processed 100 total records'
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A3D0000 AS SmallDateTime), N'Safar 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A5A0000 AS SmallDateTime), N'RabiulAwal 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A780000 AS SmallDateTime), N'RabiulAkhir 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9A950000 AS SmallDateTime), N'JamadilAwal 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9AB20000 AS SmallDateTime), N'JamadilAkhir 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9ACF0000 AS SmallDateTime), N'Rejab 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9AED0000 AS SmallDateTime), N'Syaaban 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B0A0000 AS SmallDateTime), N'Ramadhan 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B280000 AS SmallDateTime), N'Syawal 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B450000 AS SmallDateTime), N'Zulkaedah 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B630000 AS SmallDateTime), N'Zulhijjah 1429')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B810000 AS SmallDateTime), N'Muharram 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9B9F0000 AS SmallDateTime), N'Safar 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9BBC0000 AS SmallDateTime), N'RabiulAwal 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9BDA0000 AS SmallDateTime), N'RabiulAkhir 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9BF70000 AS SmallDateTime), N'JamadilAwal 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9C150000 AS SmallDateTime), N'JamadilAkhir 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9C320000 AS SmallDateTime), N'Rejab 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9C500000 AS SmallDateTime), N'Syaaban 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9C6D0000 AS SmallDateTime), N'Ramadhan 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9C8B0000 AS SmallDateTime), N'Syawal 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9CA80000 AS SmallDateTime), N'Zulkaedah 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9CC50000 AS SmallDateTime), N'Zulhijjah 1430')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9CE30000 AS SmallDateTime), N'Muharram 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D010000 AS SmallDateTime), N'Safar 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D1E0000 AS SmallDateTime), N'RabiulAwal 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D3C0000 AS SmallDateTime), N'RabiulAkhir 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D5A0000 AS SmallDateTime), N'JamadilAwal 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D770000 AS SmallDateTime), N'JamadilAkhir 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9D950000 AS SmallDateTime), N'Rejab 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9DB20000 AS SmallDateTime), N'Syaaban 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9DCF0000 AS SmallDateTime), N'Ramadhan 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9DED0000 AS SmallDateTime), N'Syawal 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E0A0000 AS SmallDateTime), N'Zulkaedah 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E280000 AS SmallDateTime), N'Zulhijjah 1431')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E450000 AS SmallDateTime), N'Muharram 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E630000 AS SmallDateTime), N'Safar 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E800000 AS SmallDateTime), N'RabiulAwal 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9E9E0000 AS SmallDateTime), N'RabiulAkhir 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9EBC0000 AS SmallDateTime), N'JamadilAwal 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9EDA0000 AS SmallDateTime), N'JamadilAkhir 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9EF70000 AS SmallDateTime), N'Rejab 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9F150000 AS SmallDateTime), N'Syaaban 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9F320000 AS SmallDateTime), N'Ramadhan 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9F6D0000 AS SmallDateTime), N'Syawal 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9F8A0000 AS SmallDateTime), N'Zulkaedah 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9FA80000 AS SmallDateTime), N'Zulhijjah 1432')
INSERT [dbo].[Hijrah] ([date_start], [nama_bulan]) VALUES (CAST(0x9FC50000 AS SmallDateTime), N'Safar 1433')


Let's say my as following,
declare @myDt date;
set @myDt='20110922'

My logic as following,
1. @myDt datepart(year)= 2011
2. @myDt datepart(month)= Sept
3. So, date_start= 2011-09-29 and nama_bulan= Syawal 1432

4. @myDt datepart(day)= 22
5. So, DATEDIFF(d,'20110922','20110929')= 7
6. Then, 7 + 1= 8
7. The result, my hijrah is 8 Syawal 1432

How my SQL looks like to generate the 8 Syawal 1432?

Need help

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2011-09-23 : 05:01:33
[code]
declare @date datetime

select @date = '2011-09-22'

select datediff(day, @date, date_start) + 1, nama_bulan
from Hijrah
where date_start = ( select min(date_start)
from Hijrah
where date_start >= @date)
[/code]

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

Idyana
Yak Posting Veteran

96 Posts
Posted - 2011-09-25 : 23:23:16
tq sir
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site