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!

Search results for query: *

  • Users: rjsql
  • Order by date
  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...

Part and Inventory Search

Back
Top