|
How to write update query to check exist column by value 1 where it exist on table FeaturesvalueA or FeaturesvalueB only?
|
|
5
|
299
|
March 7, 2021
|
|
How to Update field updatedStuffDiff when i have different values for parts exist on temp table?
|
|
2
|
367
|
March 2, 2021
|
|
How to update comment with statment havemulti status where i have more than one status per part?
|
|
1
|
242
|
February 24, 2021
|
|
How to write query generate unique Id for concate both columns search parts and company id?
|
|
0
|
253
|
February 22, 2021
|
|
When search on long text on table have 40 milion rows it is very slow so what i do?
|
|
5
|
267
|
February 21, 2021
|
|
How to use exists on this sql statment?
|
|
4
|
284
|
February 18, 2021
|
|
Query question
|
|
2
|
265
|
February 15, 2021
|
|
Replacement for OR to improve performance?
|
|
1
|
254
|
February 10, 2021
|
|
How to pull count group by one of two fields from database?
|
|
3
|
230
|
February 10, 2021
|
|
How to display size feature on final result where partc and partx not have same feature?
|
|
0
|
217
|
February 8, 2021
|
|
How to add mapped to in table trade codes where mapped from exist?
|
|
2
|
279
|
February 4, 2021
|
|
How to get value portion key to every rn from 1 to 3 row on one row?
|
|
4
|
275
|
January 26, 2021
|
|
Transact sql error need help
|
|
0
|
613
|
January 22, 2021
|
|
How to get parts from table part and not exist on both tables chemical missing and chemical master?
|
|
2
|
381
|
January 15, 2021
|
|
How to call sp and pass parameters to make pivot on sample below?
|
|
8
|
382
|
January 8, 2021
|
|
How to represent rows as column from details table?
|
|
1
|
282
|
January 6, 2021
|
|
Why result when select top 10 is different from same table?
|
|
1
|
247
|
January 5, 2021
|
|
How to use distinct instead of using group by?
|
|
8
|
330
|
January 5, 2021
|
|
How to get repeated PartId and Company Id and have different Status?
|
|
5
|
330
|
January 1, 2021
|
|
How to get parts related to every Code by Features related?
|
|
7
|
379
|
December 31, 2020
|
|
How to display features workflow first then package second?
|
|
1
|
282
|
December 28, 2020
|
|
How to get parts that not have full features on table settings by codetype and plid?
|
|
1
|
289
|
December 24, 2020
|
|
Using cast inside sum or outside?
|
|
1
|
1865
|
December 22, 2020
|
|
Exercise , please need help to understand this how can i work only with trip table only?
|
|
5
|
780
|
December 22, 2020
|
|
How to use Cursor to Execute stored procedure where featurevalue is bigger than 0?
|
|
5
|
284
|
December 20, 2020
|
|
How to get zplid that have zfeature key value on all rows?
|
|
1
|
297
|
December 20, 2020
|
|
How to delete Second PartDetailsId for Reapeated parts Based on CompanyId and PartId?
|
|
4
|
305
|
December 20, 2020
|
|
How to pivot data values On Features based on parts Exist on table inputdata?
|
|
1
|
273
|
December 17, 2020
|
|
How to prevent update to category only by part id when it be blank or NULL on inputdata table?
|
|
1
|
265
|
December 16, 2020
|
|
How to get zplid that have two code type one code type have Null on zfeature key and another have value only without null?
|
|
2
|
231
|
December 14, 2020
|