<ul class='maketea'>
<li>Tea</li>
<li>Water</li>
<li>Sugar</li>
<li>Milk</li>
</ul>
IF OBJECT_ID('dbo.test') IS NOT NULL
DROP TABLE dbo.test;
CREATE TABLE dbo.test
(
id INT PRIMARY KEY
, prodName VARCHAR(20)
);
Dim fileName As String = "C:\mydir\test.txt"
SELECT CASE Row.dayNoOfWeek
Case 1
Row.NameOfWeekDay = "Sunday"
Case 2
Row.NameOfWeekDay = "Monday"
Case 3
Row.NameOfWeekDay = "Tuesday"
Case 4
Row.NameOfWeekDay = "Wednesday"
Case 5
Row.NameOfWeekDay = "Thursday"
Case 6
Row.NameOfWeekDay = "Friday"
Case 7
Row.NameOfWeekDay = "Saturday"
END SELECT
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
switch (Row.dayNoOfWeek) {
case 1: Row.NameOfWeekDay = "Sunday"; break;
case 2: Row.NameOfWeekDay = "Monday"; break;
case 3: Row.NameOfWeekDay = "Tuesday"; break;
case 4: Row.NameOfWeekDay = "Wednesday"; break;
case 5: Row.NameOfWeekDay = "Thursday"; break;
case 6: Row.NameOfWeekDay = "Friday"; break;
case 7: Row.NameOfWeekDay = "Saturday"; break;
}
}
No comments:
Post a Comment