Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Subqueries are not allowed in this context. Only scalar expressions are allowed.

    Hi John,

    I replace this:

    VALUES(@BoardID,@RankID,@UserName,@DisplayName,'-',@Email,GETUTCDATE() ,GETUTCDATE() ,0, ISNULL((SELECT CAST(CAST(Value AS VARCHAR(5)) AS INT) from [{databaseOwner}].[{objectQualifier}Registry] where Name LIKE 'timezone' and BoardID = @BoardID), 0),@approvedFlag,@ProviderUserKey)

    with this:

    VALUES(@BoardID,@RankID,@UserName,@DisplayName,'-',@Email,GETUTCDATE() ,GETUTCDATE() ,0, ISNULL(CAST(Value AS VARCHAR(5)) AS...

  • RE: Incorrect syntax near 'xml' - SQL2000

    Thank you matt

    SQLXML3 is not installed unfortunately.

    Any idea how to bypass or fix this?

    Thanks

Viewing 2 posts - 1 through 3 (of 3 total)