2 votes
Accepted

conversion failed when converting date and/or time from character string only on one of the server

when i enter date manually like '01/06/2023' it shows data in table but whenever i enter getdate() function to get current date automatically it shows no data GETDATE() returns the current system ...
  • 29.5k
1 vote

Best approach for populating date dimension table

Here is a single SELECT query that uses the WITH RECURSIVE statement. It does not require loops, procedures etc. A RECURSIVE SQL common table expression (CTE) is a query that continuously references a ...
  • 111

Only top scored, non community-wiki answers of a minimum length are eligible