|
How to delete records with not exist
|
|
1
|
128
|
March 15, 2021
|
|
How to update colum serial where is null by max+1?
|
|
4
|
113
|
March 11, 2021
|
|
Query question
|
|
2
|
104
|
March 8, 2021
|
|
How to write update query to check exist column by value 1 where it exist on table FeaturesvalueA or FeaturesvalueB only?
|
|
5
|
139
|
March 7, 2021
|
|
How to Update field updatedStuffDiff when i have different values for parts exist on temp table?
|
|
2
|
103
|
March 2, 2021
|
|
How to update comment with statment havemulti status where i have more than one status per part?
|
|
1
|
88
|
February 24, 2021
|
|
How to write query generate unique Id for concate both columns search parts and company id?
|
|
0
|
99
|
February 22, 2021
|
|
When search on long text on table have 40 milion rows it is very slow so what i do?
|
|
5
|
101
|
February 21, 2021
|
|
How to use exists on this sql statment?
|
|
4
|
126
|
February 18, 2021
|
|
Query question
|
|
2
|
104
|
February 15, 2021
|
|
Replacement for OR to improve performance?
|
|
1
|
94
|
February 10, 2021
|
|
How to pull count group by one of two fields from database?
|
|
3
|
96
|
February 10, 2021
|
|
How to display size feature on final result where partc and partx not have same feature?
|
|
0
|
75
|
February 8, 2021
|
|
How to add mapped to in table trade codes where mapped from exist?
|
|
2
|
135
|
February 4, 2021
|
|
How to get value portion key to every rn from 1 to 3 row on one row?
|
|
4
|
127
|
January 26, 2021
|
|
Transact sql error need help
|
|
0
|
168
|
January 22, 2021
|
|
How to get parts from table part and not exist on both tables chemical missing and chemical master?
|
|
2
|
160
|
January 15, 2021
|
|
How to call sp and pass parameters to make pivot on sample below?
|
|
8
|
137
|
January 8, 2021
|
|
How to represent rows as column from details table?
|
|
1
|
111
|
January 6, 2021
|
|
Why result when select top 10 is different from same table?
|
|
1
|
110
|
January 5, 2021
|
|
How to use distinct instead of using group by?
|
|
8
|
144
|
January 5, 2021
|
|
How to get repeated PartId and Company Id and have different Status?
|
|
5
|
154
|
January 1, 2021
|
|
How to get parts related to every Code by Features related?
|
|
7
|
196
|
December 31, 2020
|
|
How to display features workflow first then package second?
|
|
1
|
147
|
December 28, 2020
|
|
How to get parts that not have full features on table settings by codetype and plid?
|
|
1
|
139
|
December 24, 2020
|
|
Using cast inside sum or outside?
|
|
1
|
122
|
December 22, 2020
|
|
Exercise , please need help to understand this how can i work only with trip table only?
|
|
5
|
156
|
December 22, 2020
|
|
How to use Cursor to Execute stored procedure where featurevalue is bigger than 0?
|
|
5
|
131
|
December 20, 2020
|
|
How to get zplid that have zfeature key value on all rows?
|
|
1
|
120
|
December 20, 2020
|
|
How to delete Second PartDetailsId for Reapeated parts Based on CompanyId and PartId?
|
|
4
|
145
|
December 20, 2020
|
