CTE error: “Types don’t match between the anchor and the recursive part”

by

Exactly what it says:

'name1' has a different data type to 'name' + CAST((rn+1) as varchar(255))

Try this (untested)

;with cte as
(
select 1 as rn, CAST('name1' as varchar(259)) as nm
union all
select rn+1,nm = 'name' + CAST((rn+1) as varchar(255))
from cte a where rn<10)
select * from cte

Basically, you have to ensure the length matches too. For the recursive bit, you may have to use CAST('name' AS varchar(4)) if it fails again

More Related Contents:

  1. Difference between CTE and SubQuery?
  2. Update records in table from CTE
  3. Common Table Expression, why semicolon?
  4. When to use Common Table Expression (CTE)
  5. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  6. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  7. Is it possible to write single query on two table which are not connected to each other?
  8. SQL Server dynamic PIVOT query?
  9. SQL Server Process Queue Race Condition
  10. Create a date from day month and year with T-SQL
  11. Creating an index on a table variable
  12. SQL – Subtracting a depleting value from rows
  13. OR is not supported with CASE Statement in SQL Server
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. How to set variable from a SQL query?
  16. SELECT FOR UPDATE with SQL Server
  17. T-SQL: Selecting Column Based on MAX(Other Column)
  18. How to group by month from Date field using sql
  19. SQL dot notation
  20. Split function in SQL Server 2008
  21. T-SQL How to create tables dynamically in stored procedures?
  22. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  23. SQL “between” not inclusive
  24. Can I set ignore_dup_key on for a primary key?
  25. Using PIVOT in SQL Server 2008
  26. SQL Server replace, remove all after certain character
  27. Inserting rows into a table with one IDENTITY column only [duplicate]
  28. SQL Row_Number() function in Where Clause
  29. When using GETDATE() in many places, is it better to use a variable?
  30. Cumulative Total in MS Sql server [duplicate]

Leave a Comment