Skip to main content

Stack Exchange

Dale K

Wellington, New Zealand

Full Stack Developer, .NET, SQL Server HTML/CSS/JavaScript/jQuery/MVC/AngularJS/Angular.

top accounts reputation activity subscriptions
Top Questions
Top Answers
11
Why does the SQL SUM() function return a non-zero total when a group float values should add up to 0?
stackoverflow.com

8
Is there a way to optimize this SQL query?
stackoverflow.com

8
How to delete inserted records without having a key?
stackoverflow.com

8
Bins in single column in SQL
stackoverflow.com

7
when to use sp_getapplock
stackoverflow.com

7
Create trigger in stored procedure
stackoverflow.com

6
Sort on T-SQL unioned query with CTE
stackoverflow.com

6
Using sum with multiple dates but keeping only the latest date
stackoverflow.com

6
Read the return value of SQL Server stored procedure in C#?
stackoverflow.com

6
Removing white spaces and special characters from SQL
stackoverflow.com

6
DECIMAL values being converted to INT + 1 on its own
stackoverflow.com

6
Get the max possible time of a date SQL Server
stackoverflow.com

5
AFTER UPDATE TRIGGER to keep Total Credits up to date
stackoverflow.com

5
Create a date column from the month and year and a static day
stackoverflow.com

5
Select varchar data become int or float
stackoverflow.com

5
LEFT JOIN not returning null when no row exists
stackoverflow.com

5
SQL Case Statement Based on Column value
stackoverflow.com

5
Optimize dynamic SQL stored procedure by reducing the unique query plans generated
stackoverflow.com

5
Insert new records where one doesn't already exist
stackoverflow.com

5
Group by having count less than n or null should return true
stackoverflow.com

5
How to select strings in UUID format + case sensitive wildcards
stackoverflow.com

5
Raw SELECT (without FROM) of most recent 7 days to current
stackoverflow.com

5
How to update multiple columns having the same value or different values in SQL?
stackoverflow.com

5
Inserting data into table from table-valued parameter
stackoverflow.com

5
SQL with non-existing column in where cause can be executed
stackoverflow.com

5
Could a SELECT inside of a transaction lock the table?
stackoverflow.com

5
Avoiding SQL injection with sp_executesql
stackoverflow.com

5
ROW_NUMBER() Based on Dates
stackoverflow.com

5
Combining object and property
stackoverflow.com

5
How to delete inserted records without having a key?
stackoverflow.com

1 2