Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Runtime error "Msg 248" overflowed an int column
CREATE PROCEDURE GENDSTDATEEX (@p_Time_Zone VARCHAR(100), @p_TZ_Start_Date INT, @p_TZ_End_Date INT, @p_TZ_Start_Time INT, @p_TZ_End_Time INT, @po_Error_Code INT OUTPUT, @po_Error_Msg VARCHAR(500) OUTPUT ) AS BEGIN DECLARE @DecimalVar INT, @v_Rowcount...- rjsql
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Runtime error "Msg 248" overflowed an int column
CREATE PROCEDURE GENDSTDATEEX (@p_Time_Zone VARCHAR(100), @p_TZ_Start_Date INT, @p_TZ_End_Date INT, @p_TZ_Start_Time INT, @p_TZ_End_Time INT, @po_Error_Code INT OUTPUT, @po_Error_Msg VARCHAR(500) OUTPUT ) AS BEGIN DECLARE @DecimalVar INT, @v_Rowcount...- rjsql
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Why do I get error 170 "Incorrect syntax near @v_year" in this proc?
SET @v_Start_Year = CONVERT(INT,SUBSTRING(CONVERT (CHAR,@p_TZ_Start_Date),1,4)) SET @v_End_Year = CONVERT(INT,SUBSTRING(CONVERT(CHAR,@p_TZ_End_Date),1,4)) SET @v_year = @v_Start_Year /* Create array of specific start and end dates after taking...- rjsql
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
