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