Topics tagged tsql

Topic	Replies	Views	Activity
How to separate values by stick when Feature values for C and X is different? Transact-SQL tsql , sql2012	4	312	September 30, 2020
Can I use only one statment for update without using three statment update separately? Transact-SQL tsql , sql2012	3	282	September 30, 2020
How to count Leadfinish where have values and not null? Transact-SQL tsql , sql2012	4	323	September 27, 2020
When use where <> 100 not get value not equal 100? Transact-SQL tsql , sql2012	12	439	September 21, 2020
How to avoid writing (in ) when update fields temp table? Transact-SQL tsql , sql2012	6	372	September 17, 2020
How to add case when to displayportal field based on first number on DoneCode? Transact-SQL tsql , sql2012	7	308	September 14, 2020
How to get active part for obsolete parts on part ID x on replacement table? Transact-SQL tsql , sql2012	3	321	September 14, 2020
How to make update statement incremental by 1 for group Id from step 1 to 3? Transact-SQL tsql , sql2012 , sql2008r2	10	440	September 13, 2020
How to give number to every group of steps? Transact-SQL tsql , sql2012	1	285	September 12, 2020
How to update status with match character in case of length portion key signature is bigger than portion key and position equal position portion key? Transact-SQL sql2012 , tsql	13	345	September 9, 2020
How to get data from signature key where not like stars? Transact-SQL sql2012 , tsql	1	261	September 8, 2020
How to update status to not match character in case of signature key not have stars *? Transact-SQL sql2012 , tsql	3	381	September 8, 2020
How to replace (or Plid is null) with any thing more best practice? Transact-SQL sql2012 , tsql	6	328	September 7, 2020
How to update table Transact-SQL sql2012 , tsql	3	278	September 3, 2020
Select statement take 10 minute to return 1000 rows only why and how to minimize time? Transact-SQL sql2012 , tsql	5	372	September 2, 2020
How to get missing parts on trade code table and that exist on table #parts and #search data? Transact-SQL sql2012 , tsql	7	326	September 1, 2020
Can you help me enhance query performance? Transact-SQL sql2012 , tsql	7	311	August 28, 2020
Getting sum from joined table data - MS SQL 2014 Transact-SQL sql2014 , tsql	2	274	August 28, 2020
Identify the corresponding negative number and separate left over positive number sql2016 , tsql	3	326	August 27, 2020
How to update status where no data returned from select statement? Transact-SQL tsql , sql2012	1	256	August 24, 2020
Why count is wrong for Books related to Authors? Transact-SQL tsql , sql2012	10	365	August 24, 2020
When group value based on feature some times come left and some times come right why and how to solve issue Transact-SQL tsql , sql2012	10	292	August 24, 2020
How to replace sub string by stuff? Transact-SQL tsql , sql2012	1	261	August 24, 2020
Warning: Null value is eliminated by an aggregate or other SET operation? Transact-SQL sql2012 , tsql	5	4465	August 17, 2020
How to update status to wrong numeric if at least on character exist? Transact-SQL sql2012 , tsql	2	315	August 14, 2020
How to update status based on positional value of another column Transact-SQL sql2012 , tsql	5	477	August 14, 2020
How to get mask that have multiple part and different on pin out on same table? Transact-SQL sql2012 , tsql	2	280	August 14, 2020
Script to bulk change notification_method parameter for SQL server alerts SQL Server Administration tsql	4	730	August 6, 2020
WHEN Add optional parameters on join query become very slow so How to solve slow performance? Transact-SQL tsql , sql2012	5	356	August 5, 2020
How to make update status when at least one site assembly exist based on Revision Id? tsql , sql2012	3	320	July 30, 2020