Q1. How to truncate a SQL Server log file while the database stays online ?

           Created: 6/10/2011

Q2. Generate Insert Statements

     Basics      Created: 6/10/2011

Q3. How to delete duplicates

     Basics      Created: 6/10/2011

Q4. Using the Pivot clause to turn rows into columns

     Basics      Created: 6/10/2011

Q5. How to import XML data

     Basics      Created: 6/10/2011

Q6. Get list of Contacts who are deleted donors for an area (to mark inactive or delete)

     YL Specific      Created: 6/10/2011

Q7. How to copy data and structure to a new table (e.g. backup a table)

           Created: 6/10/2011

Q8. Oracle 4 part naming (used in update from)

           Created: 6/10/2011

Q9. Update From

           Created: 6/10/2011

Q10. Copy PPL Events

           Created: 6/10/2011

Q11. Mass inserts for Camp Trip app

     YL Specific      Created: 6/10/2011

Q12. Copy a PPL from one MU to another (to be done after copying donor contacts)

           Created: 6/10/2011

Q13. Useful blocks for YL / Field Development

     YL Specific      Created: 6/10/2011

Q14. Oracle views and performance

     Oracle      Created: 6/10/2011

Q15. Getting the top N rows for each group.

           Created: 6/10/2011

Q16. Cleanup orphaned data using NOT EXISTS

           Created: 6/10/2011

Q17. Doing a Group By along with a join to get info from another table

           Created: 6/10/2011

Q18. SQL Server functions - Scalar versus Table values

           Created: 6/10/2011

Q19. OpenQuery Notes

           Created: 6/10/2011

Q20. Copy data from one table to another (structure already in place)

           Created: 6/10/2011

Q21. Doing an Update from one table to another.

           Created: 6/10/2011

Q22. Using Group By and Having to find duplicates

           Created: 6/10/2011

Q23. Using Group By to get row count based on an aggregate.

           Created: 6/10/2011

Q24. Using TOP twice to psuedo paginate

           Created: 6/10/2011

Q25. Logging SQL Syntax errors in SQL Server

           Created: 6/10/2011

Q26. Using bulk insert

           Created: 6/10/2011

Q27. Alumni Export

     YL Specific      Created: 8/12/2011

Q28. ASIST Status report numbers

     YL Specific      Created: 8/12/2011