Lamak questions

Lamak answers

• Stored procedure containing inner join with count not working
• Window functions in SQL Server
• Very slow query, any other ways to format this with better performace?
• Transposing rows to columns using self join
• How to join sequential numbers to unrelated data (SQL Server)
• How to use SELECT with GROUP BY and HAVING in a specific SQL case
• Generate guid for a table without a loop
• are there loops in t-sql ? is using them a good idea?
• Group By Column Alias
• UNION with IF statements