team2005
asked on
What is wrong with this query
Hi!
Have this query:
Gives me this erro message:
[Error Code: 8116, SQL State: S1000] Argument data type int is invalid for argument 1 of substring function. 2) [Error Code: 8116, SQL State: S1000] Argument data type int is invalid for argument 1 of substring function.
What is wrong ?
Have this query:
Declare
@SQL varchar(2000),
@version_id varchar(50),
@MyCursor CURSOR,
@perioden varchar(4),
@moneden varchar(2),
@aaret1 varchar(4),
@aaret2 int,
@maaned1 varchar(2),
@maaned2 int,
@periodeteller int,
@FORECASTYEARWEEK int,
@DATAAREAID varchar(4)
SET @MyCursor = CURSOR FAST_FORWARD
FOR
Select version_id,FORECASTYEARWEEK,DATAAREAID From dbo.Perioder_tmp_perioder
OPEN @MyCursor
FETCH NEXT FROM @MyCursor
INTO @version_id,@FORECASTYEARWEEK,@DATAAREAID
WHILE @@FETCH_STATUS = 0
BEGIN
SET @aaret1 = SUBSTRING (@FORECASTYEARWEEK,1,4)
SET @aaret2 = CAST(@aaret1 AS INT)
SET @maaned1 = SUBSTRING (@FORECASTYEARWEEK,5,2)
SET @maaned2 = CAST(@maaned1 AS INT)
INSERT Into TMP_Forcast_Hit_Ratio_Art_version
(
[DATAAREAID],
[ITEMID],
[version_id],
[FORECASTYEARWEEK],
[ITEMIDDAT]
)
SELECT
@DATAAREAID,
ART.ITEMID,
@version_id,
@FORECASTYEARWEEK,
ART.ITEMID+@DATAAREAID
FROM dbo.DIM_Artikkel as ART
WHERE ((year(ART.CREATEDDATETIME))=@aaret2) and (cast(DATEPART(week,ART.CREATEDDATETIME)as int)<=@maaned2)
FETCH NEXT FROM @MyCursor
INTO @version_id,@FORECASTYEARWEEK,@DATAAREAID
END
Gives me this erro message:
[Error Code: 8116, SQL State: S1000] Argument data type int is invalid for argument 1 of substring function. 2) [Error Code: 8116, SQL State: S1000] Argument data type int is invalid for argument 1 of substring function.
What is wrong ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
@FORECASTYEARWEEK is INT in the database