Sarath Avanavu
|
Registered User
|
- CREATE TABLE #Teacher(TchrId VARCHAR(3), TeacherName VARC...
- CREATE TABLE #Teacher(TchrId VARCHAR(3), TeacherName VARC...
- CREATE TABLE #TEMP(sales_Id INT, product_id INT, ...
- CREATE TABLE #CustomerDetails (CustomerID INT, CustCo...
- CREATE TABLE #CustomerDetails (CustomerID INT, CustCo...
- SAMPLE
- Dynamic sql
- DECLARE @table TABLE ( [Group] CHAR(1) , Value1 INT , ...
- Cross Apply
- Pivot
- CSV with COALESCE
- CSV with QUOTENAME
- Wrong result in Coalesce
- Replace NULL with zero in static pivot
- Replace NULL with zero in dynamic pivot