When I'm reporting spammers in the spam forum, please don't mark my post as spam. Honestly, the number of messages I have had lately that are getting flagged as spam - the spam detection system is doing a very poor job.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
You asked this a mere 14 hours ago. Please, have a little patience. The staff will get to this as soon as possible; adding extra noise to this forum isn't going to get them to your request any quicker.
Thank you for adding more tags in the article editor. Much obliged!
But, isn't Android a platform? I can only find, Google there and no Android. It would be helpful in adding articles under Android also.
Also. When would these changes reflect the "Sections" settings? Articles are less categorized under tags, and are categorized more often based on the "Section" they are posted under. So, I guess, that also needs some of your attention.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
select @ResponsibleName = ResponsibleName
select @FrequencyName = FrequencyName
select @TypeName = TypeName
--WHEN @TypeName IS null then ''
-- ELSE @TypeName
--WHEN @FrequencyName IS null then ''
-- ELSE @FrequencyName
--WHEN @ResponsibleName IS null then ''
-- ELSE @ResponsibleName
--WHEN @VesselPosition IS null then ''
-- ELSE @VesselPosition
SET @SelectStatement = 'SELECT ROW_NUMBER()OVER (ORDER BY M.EquipmentId) AS Row,
WHEN @VesselPosition IS null then ''
END AS PositionInVessal,
WHEN @TypeName IS null then ''
CONVERT(VARCHAR(10), M.LastDoneDate, 105)LastDoneDate,
CONVERT(VARCHAR(10), NextDueDate, 105) NextDueDate,
WHEN @ResponsibleName IS null then ''
WHEN @FrequencyName IS null then ''
END as FrequencyType
FROM dbo.PMS_TBL_MAINTANANCE_MASTER M
INNER JOIN PMS_TBL_MAINTANANCE_COMPLETION C
LEFT OUTER JOIN PMS_TBL_EQUIPMENT_MASTER E
LEFT OUTER JOIN PMS_TBL_SUB_EQUIPMENT_MASTER S
SET @FullStatement = @SelectStatement + ISNULL(@WhereClause,'')
EXECUTE sp_executesql @FullStatement
when i execute it , it getting an error like " Msg 137, Level 15, State 2, Line 6 Must declare the scalar variable "@VesselPosition"." can any one suggest me the reason