|
Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Invalid length parameter passed to the LEFT or SUBSTRING function
|
|
5
|
52
|
April 9, 2021
|
|
Not exists query
|
|
1
|
74
|
March 30, 2021
|
|
How to get Part Id that have part level 0 and not have map from?
|
|
1
|
59
|
March 27, 2021
|
|
Calculate elapsed business/work time in hours:Minutes format
|
|
2
|
58
|
March 25, 2021
|
|
Connect Polybase and S3
|
|
0
|
53
|
March 23, 2021
|
|
How to select code type 1900 and 1885 when exist at least one time per part?
|
|
2
|
72
|
March 18, 2021
|
|
How to get partid that have two category and exist on 2000,2200?
|
|
1
|
71
|
March 16, 2021
|
|
How to delete records with not exist
|
|
1
|
82
|
March 15, 2021
|
|
How to update colum serial where is null by max+1?
|
|
4
|
84
|
March 11, 2021
|
|
Query question
|
|
2
|
78
|
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
|
96
|
March 7, 2021
|
|
How to Update field updatedStuffDiff when i have different values for parts exist on temp table?
|
|
2
|
59
|
March 2, 2021
|
|
How to update comment with statment havemulti status where i have more than one status per part?
|
|
1
|
64
|
February 24, 2021
|
|
How to write query generate unique Id for concate both columns search parts and company id?
|
|
0
|
62
|
February 22, 2021
|
|
When search on long text on table have 40 milion rows it is very slow so what i do?
|
|
5
|
68
|
February 21, 2021
|
|
How to use exists on this sql statment?
|
|
4
|
81
|
February 18, 2021
|
|
Query question
|
|
2
|
79
|
February 15, 2021
|
|
Replacement for OR to improve performance?
|
|
1
|
68
|
February 10, 2021
|
|
How to pull count group by one of two fields from database?
|
|
3
|
71
|
February 10, 2021
|
|
How to display size feature on final result where partc and partx not have same feature?
|
|
0
|
49
|
February 8, 2021
|
|
How to add mapped to in table trade codes where mapped from exist?
|
|
2
|
99
|
February 4, 2021
|
|
How to get value portion key to every rn from 1 to 3 row on one row?
|
|
4
|
90
|
January 26, 2021
|
|
Transact sql error need help
|
|
0
|
106
|
January 22, 2021
|
|
How to get parts from table part and not exist on both tables chemical missing and chemical master?
|
|
2
|
116
|
January 15, 2021
|
|
How to call sp and pass parameters to make pivot on sample below?
|
|
8
|
100
|
January 8, 2021
|
|
How to represent rows as column from details table?
|
|
1
|
76
|
January 6, 2021
|
|
Why result when select top 10 is different from same table?
|
|
1
|
74
|
January 5, 2021
|
|
How to use distinct instead of using group by?
|
|
8
|
102
|
January 5, 2021
|
|
How to get repeated PartId and Company Id and have different Status?
|
|
5
|
108
|
January 1, 2021
|
|
How to get parts related to every Code by Features related?
|
|
7
|
154
|
December 31, 2020
|
