cha's user avatar
cha's user avatar
cha's user avatar
cha
  • Member for 10 years, 4 months
  • Last seen more than a week ago
  • Melbourne, Australia
7 votes

SQL Server 2012 Can't log in with machine account

6 votes

PostgreSQL - summing arrays by index

6 votes
Accepted

complex update query postgres

6 votes
Accepted

Rearranging Data in an MS Access 2007 table into a new table format/Result Output

5 votes
Accepted

How to get the return value from a stored procedure executed with sp_executesql

5 votes
Accepted

Shorthand for epoch

4 votes
Accepted

What difference between these 2 SQL styles?

4 votes

Sum(Case When) Question

3 votes
Accepted

List minutes instead of grouping by them

3 votes

How do I write a mysql query to combine data from related tables into a single summary?

2 votes
Accepted

ALTER TABLE AUTO_INCREMENT number in a Trigger

2 votes

UPDATE table with another table data

2 votes
Accepted

limiting rows in joins

2 votes

Return items not found in database in Oracle

2 votes
Accepted

Changing data source on Access front end

2 votes
Accepted

Creating tables PDO Sqlite

1 vote

Merging a Select query into a view

1 vote
Accepted

List distinct column values where those rows share other column values

1 vote

return continuous set of IDs based on two other columns

1 vote

Select rows based on latest date with multiple joins

1 vote

When Creating a Foreign Key Relationship

1 vote

Combining Tables in MySQL

1 vote
Accepted

Will my query pick up where it stopped due to connection timeout?

1 vote

Get data per Customer and per Date

0 votes
Accepted

Select row with MAX(), or choose one if no MAX() exists

0 votes

Get row from table for last date before date parameter if no row for date parameter or entries null

0 votes

Similar Products with bitwise

0 votes

Need a faster method to concatenate rows into column(s)--currently using CTEs

0 votes
Accepted

UPDATE CONCAT without duplicates

0 votes

Inserting to table: Insert rows with Left Outer Join or Insert rows then Update?