scott2718281828 thanks for your approach, it worked a treat other than for leap years so I've had to union a second statement for any on the 29th Feb...
Hi All, I'm using the below code to create one flat table with all specified item details in, however it is incredibly slow. There is approx 20,000...
Thanks for the info, but I'm still not sure of the solution. How would I rewrite this as a Select? I have the table generated for the start and end...
SP details below *************************** insert into POLICY_YEARS VALUES(@POLICYKEY, DATEADD(day, DATEDIFF(day, '20000101', @DATE),...
Hi Everyone, I'm new to SQL so apologies if my question is simple but I'm struggling with how best to complete the task I have. I have a record set...
Separate names with a comma.
