Transact-SQL

Topic	Replies	Views	Activity
Sql query from excel via VBA	1	287	January 21, 2022
Error	4	219	January 21, 2022
Mapping rows in the routing table with other tables on certain conditions	0	160	January 20, 2022
Need to create uniuqe key	1	182	January 20, 2022
SQL Statement	3	183	January 19, 2022
Parse the business rules query to Tsql	0	198	January 17, 2022
Query to get the fully present employees from a table	2	223	January 17, 2022
Please help on Pivot/UN Pivot	6	418	January 13, 2022
How to get first row group by partid and compliance typeid and document type? tsql , sql2012 , sql2014	3	281	January 13, 2022
Calculate MTD from same table (SQL) sql2016	5	2077	January 12, 2022
SQL 2017 : Conversion failed when converting the nvarchar value '____' to data type int	2	528	January 11, 2022
Insert or Update a record via Openrowset linked server sql2014	2	2077	January 11, 2022
Attendance Calculation Based on IN Timing	10	366	January 11, 2022
TSQL Query returning results I am not expecting tsql	2	270	January 10, 2022
Write SQL query to put hirarchy-based data into Level-based table format sql2012 , sql2016 , sql2014	3	264	January 10, 2022
Why is this returning 0?	6	237	January 10, 2022
How to allow multi user work on same table without any issue of interact data? sql2008 , tsql , sql2012	8	741	January 10, 2022
How to pass date in sqlcmd tsql , sql2012 , sql2016	1	822	January 9, 2022
Round up sql2012	6	745	January 8, 2022
Why is the column 'challenge_counter' invalid?	9	229	January 7, 2022
Beginner needing help	3	242	January 7, 2022
How to write query get long process job or query or stored procedure running on server? sql2012 , tsql , sql2014	1	275	January 7, 2022
How to make data pivot dynamically to materialper and suplierperc both? sql2008 , tsql , sql2012	2	440	December 23, 2021
How to reduce high cost index seek and hash match inner join when analysis execution plan issue? sql2012 , tsql , sql2014	5	2550	January 6, 2022
How to write update with best practice? sql2012 , tsql , sql2014	1	262	January 5, 2022
How to get data from table Compliance Data Horizontally Based on Part Id and Compliance Type Id? sql2012 , tsql , sql2008	10	444	January 4, 2022
Adding vertical sum of rows(Sum in last availble column) for Transposed data tsql , sql2014	3	1202	January 2, 2022
Error converting data type varchar to datetime in Stored Procedure sql2014	2	6685	January 1, 2022
Extracting part of a text field (variable length)	17	1674	December 28, 2021
How to use inner join instead of left join on query below in case of data not exist on chemical master? sql2014 , tsql , sql2012	1	410	December 28, 2021