Advertisement
Advertisement
| 04.03.2008 at 08:49AM PDT, ID: 23293204 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: |
-- Here's sort of what I have in mind CREATE FUNCTION GetWeekRange (@week_number smallint) RETURNS VARCHAR(25) BEGIN DECLARE @week_range varchar(25) ,@min_range datetime ,@max_range datetime -- PSEUDO -- Do something here though I have -- No idea how to get the range values SET @min_range = SELECT Something WHERE Something SET @max_range = SELECT Something WHERE Something SET @week_range = CONVERT(varchar,@min_range,101) + ' - ' + CONVERT(varchar,@max_range,101) RETURN @week_range END |