Topics tagged tsql

Topic	Replies	Views	Activity
Need help writing SQL script that updates/merge from the original script Transact-SQL tsql	2	243	February 17, 2022
How to replace stuff with string agg on sql server 2017? Transact-SQL tsql , sql2012 , sql2016	7	533	January 24, 2022
How to get first row group by partid and compliance typeid and document type? Transact-SQL tsql , sql2012 , sql2014	3	249	January 13, 2022
TSQL Query returning results I am not expecting Transact-SQL tsql	2	238	January 10, 2022
How to allow multi user work on same table without any issue of interact data? Transact-SQL sql2008 , tsql , sql2012	8	386	January 10, 2022
How to pass date in sqlcmd Transact-SQL tsql , sql2012 , sql2016	1	593	January 9, 2022
How to write query get long process job or query or stored procedure running on server? Transact-SQL sql2012 , tsql , sql2014	1	242	January 7, 2022
How to make data pivot dynamically to materialper and suplierperc both? Transact-SQL sql2008 , tsql , sql2012	2	395	December 23, 2021
How to reduce high cost index seek and hash match inner join when analysis execution plan issue? Transact-SQL sql2012 , tsql , sql2014	5	1874	January 6, 2022
How to write update with best practice? Transact-SQL sql2012 , tsql , sql2014	1	238	January 5, 2022
How to get data from table Compliance Data Horizontally Based on Part Id and Compliance Type Id? Transact-SQL sql2012 , tsql , sql2008	10	375	January 4, 2022
Adding vertical sum of rows(Sum in last availble column) for Transposed data Transact-SQL tsql , sql2014	3	1026	January 2, 2022
How to use inner join instead of left join on query below in case of data not exist on chemical master? Transact-SQL sql2014 , tsql , sql2012	1	359	December 28, 2021
How to solve error Conversion failed when converting the nvarchar value '24VAC/D Transact-SQL tsql , sql2014 , sql2012	7	1469	December 2, 2021
After add two statement stuff query executing take long time as 5 minute? Transact-SQL tsql , sql2014 , sql2012	2	244	December 1, 2021
How to add top 1 row as header on SQL server as extra row? Transact-SQL sql2012 , tsql , sql2008	7	4261	December 1, 2021
Join by id rather than VARBINARY Transact-SQL tsql , sql2014 , sql2012	6	630	November 26, 2021
My query select into very slow How to enhance it? Transact-SQL sql2014 , sql2012 , tsql , sql2008	7	2308	November 19, 2021
How to use group by instead of distinct when make STUFF execute dynamic SQL query @SQL? Transact-SQL sql2012 , tsql , sql2008	6	592	November 19, 2021
How to add customer extra header row on top of pivot? Transact-SQL sql2014 , sql2012 , tsql	0	225	November 17, 2021
Add Date Parameter to script to filter Date Paid Through tsql	6	246	November 16, 2021
Dynamic procedure pivot not accept multi columns SQL server? Transact-SQL sql2014 , sql2012 , tsql	3	306	November 14, 2021
Custom row via sql query insert into when value changes Transact-SQL tsql	0	366	November 12, 2021
How to get data from two tables from sub procedure to main procedure without using insert into? Transact-SQL sql2014 , tsql , sql2012	6	259	November 10, 2021
How to get FeatureName and FeatureValue separated by $ for table AllData? Transact-SQL tsql , sql2012 , sql2008	0	264	November 5, 2021
Insert rows it take too much time for 0 rows inserted? Transact-SQL tsql , sql2012	7	330	November 3, 2021
How to get feature key and feature value separated $ based on part id? Transact-SQL tsql , sql2008 , sql2012	2	302	October 28, 2021
How to make rownumber start by 1 instead of 0 when make union all? Transact-SQL sql2012 , tsql , sql2008	1	336	October 20, 2021
Why update statement take too much time? Transact-SQL sql2012 , tsql , sql2014	6	368	October 13, 2021
Conditional update Transact-SQL sql2008 , sql2012 , tsql	2	464	September 29, 2021