Viewing 4 posts - 16 through 19 (of 19 total)
You can't use the CREATE TABLE #TEMPTABLE command to create a table for the duration of the function
You can create a table for the duration of the function by declaring...
May 22, 2008 at 3:51 am
Hi All,
Thanks for the advice, it is really appreciated.
🙂
May 22, 2008 at 1:53 am
JohnG (5/21/2008)
tony.sawyer (5/21/2008)
We've got a UDF called TruncDate that effective truncates the date by removing the time element from it. This mimics the TRUNC() command in Oracle.
Why do all...
May 21, 2008 at 9:56 am
We've got a UDF called TruncDate that effective truncates the date by removing the time element from it. This mimics the TRUNC() command in Oracle.
ALTER FUNCTION TruncDate
(
@InDate DATETIME
)
RETURNS DATETIME
AS
BEGIN
DECLARE...
May 21, 2008 at 9:38 am
Viewing 4 posts - 16 through 19 (of 19 total)