Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER PROCEDURE dbo.get_steps_detail
- @proj_id int
- AS
- BEGIN
- SET NOCOUNT ON
- SELECT step_date, step_stat
- FROM steps_table
- WHERE proj_id = @proj_id ORDER BY step_num
- END
- Running [dbo].[get_steps_detail] ( @proj_id = 1 ).
- step_date step_stat
- ------------------------------ ---------------------------------------------------------
- 2014-02-06 00:00:00.0000000 1
- 2014-01-30 00:00:00.0000000 1
- 2014-01-30 00:00:00.0000000 1
- 2014-01-30 00:00:00.0000000 1
- No rows affected.
- (4 row(s) returned)
- @RETURN_VALUE = 0
- Finished running [dbo].[get_steps_detail].
- SELECT step_date, step_stat
- FROM steps_table
- WHERE (proj_id = 1)
- ORDER BY step_num
- 2/6/2014 1
- 1/30/2014 1
- 1/30/2014 1
- 1/30/2014 1
- SELECT CAST(step_date AS DATE) ...
- SELECT DATEPART(year, step_date) AS step_date_year, DATEPART(month, step_date) AS step_date_month, DATEPART(day, step_date) AS step_date_day
- <asp:Label ID="Label1" runat="server" ><%# Eval("step_date_year")%> - <%# Eval("step_date_month")%> - <%# Eval("step_date_day")%></asp:Label>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement