declare @currDate1 datetime
declare @currDate2 datetime
declare @Schedule1 nvarchar(20)
declare @Schedule2 nvarchar(20)
set @currDate1='2012-08-24 06:28:41.420'
set @currDate2='2012-08-24 14:28:41.420'
set @Schedule1='I go to school'
set @Schedule2='I go to zoo'
select (@currDate1)currDate1,(@Schedule1)Schedule1,(@currDate2)currDate2,(@Schedule2)Schedule2
#Results:
currDate1 Schedule1 currDate2 Schedule2
2012-08-24 06:28:41.420 I go to school 2012-08-24 14:28:41.420 I go to zoo
Query can be modified as below
select (@currDate1)schedule_date,(@Schedule1)schedule_activity union
select (@currDate2)schedule_date,(@Schedule2)schedule_activity
#Results:
schedule_date schedule_activity
2012-08-24 06:28:41.420 I go to school
2012-08-24 14:28:41.420 I go to zoo
Tidak ada komentar:
Posting Komentar