Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
SELECT t1.memno, BookCount = (SELECT COUNT(*) FROM BookTable t2 WHERE t1.memno = t2.memno), BookList = substring((SELECT (',' + bookid ) FROM BookTable t2 WHERE t1.memno = t2.memno ORDER BY memno, bookid FOR XML PATH('') ), 3, 1000 ) FROM BookTable t1 GROUP BY memno ORDER BY memno
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|PROPERCASE SCRIPT IN SQL||3||23|
|Sql query with where clause||2||45|
|Crystal reports login after closing form||3||35|
|Adding blob field removes any item that doesn't have image in database - see post referenced below||4||18|