Home Forums SQL Server 2008 T-SQL (SS2K8) output ve space while printing in sql server 2000 RE: output ve space while printing in sql server 2000

  • while em using str in my query its showing error, like

    select slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate

    from GOALSDTL

    union

    select str((slno,entrydate,goals,kpi,weightage,goals_review_date,reviewcomments,reviewedby,reviewdate),5,2)

    from GOALSDTL_History

    error:

    doest convert date into int