Transact-SQL

Topic	Replies	Views	Activity
Pivot Table Issue	9	271	July 24, 2020
Potential side effects to this query? Or better way to do it? sql2012	4	354	July 23, 2020
How to improve performance on query tsql , sql2012	6	360	July 23, 2020
Each GROUP BY expression must contain at least one column that is not an outer reference	3	625	July 22, 2020
Alter Column (T-SQL) tsql	3	314	July 20, 2020
A request for documentation on sp_whoisactive sql2012	4	530	July 19, 2020
Check for Random Number ,Insert if not exists tsql , sql2016	9	809	July 18, 2020
To query just ID from a table to multiple table with query containing left outer join, subquery, Max, Inner Join	21	574	July 17, 2020
Need to query XML data inside a nvarchar column sql2016	9	6162	July 15, 2020
Update multiples columns data if record available then update other wise Insert sql2014	6	356	July 14, 2020
UnPivot, CrossApply	6	316	July 14, 2020
Trying to Determine the Ticket Title for Orders	3	305	July 14, 2020
SUM based on column value change	1	483	July 14, 2020
Compose WHERE from comma separated values string	6	338	July 13, 2020
Return max value and associted row values with the same ID	4	566	July 10, 2020
Better way to collect sp_whoisactive data? sql2012	4	2272	July 6, 2020
Sql server help sql2008 , tsql , sql2012	5	352	July 4, 2020
Function test question	6	274	July 2, 2020
Free database data	5	582	July 2, 2020
Date Dimension gives date one day later than start date	7	408	July 1, 2020
Case statement based on alphabetical order of a code	2	664	July 1, 2020
Filter and re-arrange data based on multiple conditions	3	416	June 30, 2020
How to write dynamic statement with way do it run quickly? sql2012 , tsql	7	404	June 30, 2020
Need SQL Query for Audittrail count against Master Table	3	343	June 29, 2020
Order by dynamic	2	313	June 29, 2020
How to get max Value Unit from field Value Unit based on first value before comma separated? tsql , sql2012	2	406	June 29, 2020
Issue On Values when separate it to value and text? tsql , sql2012	18	861	June 29, 2020
Convert NVARCHAR to date format to use with Get Date	2	1253	June 29, 2020
Cast dynamically created column in SQL statement	9	1747	June 29, 2020
How to display Unit as Second Display Item for same display Order? tsql , sql2012	2	344	June 28, 2020