VIEW
Points
Time
Detail
+15
-
Answered the question Warning: Null value is eliminated by an aggregate or other SET operation ? confirmed by the asker in the Transact-SQL Forum.
0
-
Replied to a forums thread I need a field containing 00:00:00 as numeric (not text) in VFP to export dbf files to Sage 300 2020 in the Transact-SQL Forum.
0
-
Replied to a forums thread Warning: Null value is eliminated by an aggregate or other SET operation ? in the Transact-SQL Forum.
0
-
Replied to a forums thread Warning: Null value is eliminated by an aggregate or other SET operation ? in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the Replacing numbers from a string thread in the Transact-SQL Forum.
0
-
Replied to a forums thread Change foreign the key relationships to reference one master record? in the Transact-SQL Forum.
0
-
Replied to a forums thread Calculating weightage based on value in sql in the Transact-SQL Forum.
0
-
Replied to a forums thread include column in select list based on criteria in the Transact-SQL Forum.
0
-
Replied to a forums thread Increment a table number on 1st of every month and query the table in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions thread in the Transact-SQL Forum.
0
-
Replied to a forums thread Is there a way to return unique combinations regardless of order in the Transact-SQL Forum.
0
-
Replied to a forums thread The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions in the Transact-SQL Forum.
0
-
Replied to a forums thread ID with different roles, leave out certain roles and create new table with selection and new column. But how?? in the Transact-SQL Forum.
0
-
Replied to a forums thread Recommendation on speeding up the Procedure in the Transact-SQL Forum.
0
-
Replied to a forums thread How to track address change over time in SQL in the Transact-SQL Forum.
0
-
Replied to a forums thread Query to find the tables order in which data needs to be deleted because of PrimaryKey and ForeignKey setup in a database in the Transact-SQL Forum.
0
-
Replied to a forums thread Change font colour in table cell based on SQL Query in SQL Email in the Transact-SQL Forum.
+15
-
Answered the question Create a Stored Procedure to pass in NewDateOfBirth and MemberID As Parameters which Update the age, DateofBirth columns..... confirmed by the asker in the Transact-SQL Forum.
+20
-
Quickly answered the question While Loop Returns Error when more than 1 ID is used confirmed by the asker in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the While Loop Returns Error when more than 1 ID is used thread in the Transact-SQL Forum.
+15
-
Answered the question How is a CHECK CONSTRAINT using the IN operator actually being processed for an [int] column? confirmed by the asker in the Transact-SQL Forum.
0
-
Replied to a forums thread While Loop Returns Error when more than 1 ID is used in the Transact-SQL Forum.
0
-
Replied to a forums thread How is a CHECK CONSTRAINT using the IN operator actually being processed for an [int] column? in the Transact-SQL Forum.
0
-
Replied to a forums thread Pass column names as argument and combine column values in the Transact-SQL Forum.
+15
-
Answered the question How to create a function to parse last name from full name? confirmed by the asker in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the How to create a function to parse last name from full name? thread in the Transact-SQL Forum.
0
-
Replied to a forums thread How to create a function to parse last name from full name? in the Transact-SQL Forum.
0
-
Contributed a proposed answer to the question Help in finding re-admission summary counts from detail data. in the Transact-SQL Forum.
0
-
Replied to a forums thread Help in finding re-admission summary counts from detail data. in the Transact-SQL Forum.
+15
-
Answered the question Convert function doesn't work confirmed by the asker in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the Convert function doesn't work thread in the Transact-SQL Forum.
+20
-
Quickly answered the question Create Retention Solution using a Control Table confirmed by the asker in the Transact-SQL Forum.
0
-
Replied to a forums thread SQL - how to get minimum from a set of dates in the Transact-SQL Forum.
0
-
Replied to a forums thread Need to update particular column in particular row in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the Join Order of Execution in T-SQL thread in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the Convert function doesn't work thread in the Transact-SQL Forum.
+15
-
Answered the question Convert function doesn't work confirmed by the asker in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the SET NULL Causing Cyclical Foreign Key thread in the Transact-SQL Forum.
0
-
Contributed a proposed answer to the question please i need help with writing up this new Tsql code in the Transact-SQL Forum.
0
-
Replied to a forums thread Display all the days for the previous month in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the How to use local variable in a group by clause thread in the Transact-SQL Forum.
0
-
Replied to a forums thread how to get multi columns from single column value in the Transact-SQL Forum.
0
-
Replied to a forums thread please i need help with writing up this new Tsql code in the Transact-SQL Forum.
0
-
Replied to a forums thread SQL Server - Avoid cursor while serial update in the Transact-SQL Forum.
0
-
Replied to a forums thread INERT INTO table by filtering existing added values in the Transact-SQL Forum.
0
-
Replied to a forums thread GROUP BY with HAVING SUM not returning what I'd expect in the Transact-SQL Forum.
+5
-
Contributed a helpful post to the Do tools exist that help you to make a database ansi compliant? thread in the Transact-SQL Forum.
0
-
Replied to a forums thread Do tools exist that help you to make a database ansi compliant? in the Transact-SQL Forum.
0
-
Replied to a forums thread Loop through a table by row and insert row into another table in the Transact-SQL Forum.
0
-
Replied to a forums thread insert default values dynamically in sql server in the Transact-SQL Forum.
0
-
Replied to a forums thread how to combine 3 columns into 1 column and identify in sql server in the Transact-SQL Forum.
0
-
Replied to a forums thread Query to look for a column in particular group has null in the Transact-SQL Forum.
0
-
Replied to a forums thread Need tables list in Parent child level order in the Transact-SQL Forum.
0
-
Replied to a forums thread How to pivot dates in query results to columns based off of a another column in the Transact-SQL Forum.
0
-
Replied to a forums thread Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. in the Transact-SQL Forum.
0
-
Replied to a forums thread How can I convert values in a column into comma delimited values in a field in as a single row? in the Transact-SQL Forum.
0
-
Replied to a forums thread table should allow only few fields unique and rest fields can allow duplicate values through sp while inserting or updation in the Transact-SQL Forum.
0
-
Replied to a forums thread Conversion error. Not understanding why is this error coming in the Transact-SQL Forum.
0
-
Replied to a forums thread Is there way i can track the total of all the other Items in the order? in the Transact-SQL Forum.
0
-
Contributed a proposed answer to the question Not able to create a trigger to auto populate datetime value in a field in SQL Server after Insert,update in the Transact-SQL Forum.
0
-
Replied to a forums thread Not able to create a trigger to auto populate datetime value in a field in SQL Server after Insert,update in the Transact-SQL Forum.
0
-
Replied to a forums thread Passing the output of CASE into a parameter in the Transact-SQL Forum.
0
-
Replied to a forums thread How to select * from a table where two columns dont match in another table in the Transact-SQL Forum.