SQLTeam.com | Weblogs | Forums

Transact-SQL


About the Transact-SQL category (1)
I have column name with dates which comes from a table and changes from current month to last 41 month. and i have to write the column name again and again to reach the desired output. Is there any way I can take the column name dynamically (3)
Help needed for this conditional summary (3)
RPA Training in chennai (1)
Relationship between records in the same table (7)
Running SubTotal with NULLS (5)
TSQL Pivot (3)
Select selected record (4)
Designer on each dataset (2)
SQL Query between dates ( 2 ) (22)
Combining two SQL statements into One (6)
Redesigning a table (12)
Delete statement with reference to an ID that is going to be deleted. What happens? (6)
Group By Clause (2)
Join logic problem for multiple relationships in one table (17)
How to show a 1 or 0 in select statement (2)
Calculate DateDiff Challenge Via Pivot Operator (7)
Partition By vs Group By (2)
Insert a duplicate copy of any record that meets certain criteria (9)
Categorywise % of sales and returns of categories in the same code and Output (5)
Simple Group By Clause Question! (3)
Commission Split for Broker report (6)
Date range for report (7)
Bulk Insert using Format File not working (3)
What is help desk ticketing system? (3)
Summarize Case Stament using MS SQL Server (5)
Conditional Formatting within SQL Query (changing cell color on the basis of condition) (8)
Pivot/UNPIVOT/CROSS APPLY rows and columns (11)
Add a running number column based on a text value (13)
Pivot Table (Change Values as Column in Excel) (2)