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!

Register Log in
  • 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!

Recent content by rjsql

  1. rjsql

    Runtime error "Msg 248" overflowed an int column

    Time_Zone table def is: TIME_ZONE_ID DECIMAL 9 TIME_ZONE_NUMBER DECIMAL 9 NAME VARCHAR 40 DESCRIPTION VARCHAR 80 DAYLIGHT_SAVINGS_OFFSET DECIMAL 9 GMT_OFFSET DECIMAL 9 DST_START DECIMAL 12 DST_END...
  2. rjsql

    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...
  3. rjsql

    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...
  4. rjsql

    Why do I get error 170 "Incorrect syntax near @v_year" in this proc?

    Sorry for the confusion. Did find out the error -- I did not need parens around the parms for the calls to Convert_DST proc. Thanks for the reply anyway!
  5. rjsql

    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...
See more

Part and Inventory Search

Back
Top