SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 events by user jdennis occurring around 2021-07-21 08:40:08.

2022-03-10
09:54 Reply: How to unpivot a cross-table with “changing“ numbers of columns and column names? (artifact: 24e2b11a93 user: jdennis)
2022-03-06
10:16 Reply: CASE TYPEOF(field) WHEN 'text' THEN .... doesn't seem to work (artifact: f74117dbc4 user: jdennis)
2022-02-13
02:52 Reply: Query to find maximum number of values sharing a common key (artifact: e26d61c593 user: jdennis)
2022-02-10
03:24 Reply: Query to find maximum number of values sharing a common key (artifact: 4155b08e96 user: jdennis)
02:56 Reply: Query to find maximum number of values sharing a common key (artifact: f7058c9175 user: jdennis)
2022-02-09
09:16 Reply: Query to find maximum number of values sharing a common key (artifact: cc85865951 user: jdennis)
09:06 Reply: Query to find maximum number of values sharing a common key (artifact: 62fdf62de2 user: jdennis)
08:12 Post: Query to find maximum number of values sharing a common key (artifact: b9ab16c717 user: jdennis)
2022-01-26
06:32 Reply: SQLiteDataAdapter.FillSchema problem with left joined tables (artifact: f82cb56687 user: jdennis)
2022-01-25
07:30 Reply: Case when (artifact: 4302a6cab3 user: jdennis)
2021-11-27
07:51 Reply: Существует ли справочник синтетических ошибок?Где искать исправления error near? (artifact: 0fe77ab5a5 user: jdennis)
2021-11-05
06:58 Reply: Question about memory management (artifact: 31315b1882 user: jdennis)
2021-09-21
09:36 Reply: get only first record found (artifact: e6e0c8f47d user: jdennis)
2021-09-09
09:01 Reply: How to insert duplicate rows? (artifact: 713ecc29bd user: jdennis)
06:35 Reply: How to insert duplicate rows? (artifact: ae054ac0a4 user: jdennis)
2021-08-23
02:03 Edit reply: How to select columns that have name beginning with same prefix? (artifact: ba745286c9 user: jdennis)
02:03 Reply: How to select columns that have name beginning with same prefix? (artifact: 2b4378a6bf user: jdennis)
2021-08-16
04:28 Reply: Numeric vs integer (artifact: 0a37de2b6a user: jdennis)
2021-08-15
06:32 Reply: Numeric vs integer (artifact: 9c087c216a user: jdennis)
05:34 Post: Numeric vs integer (artifact: 07a8e7ef77 user: jdennis)
2021-08-14
12:11 Reply: AVG funcion problem (artifact: 3d0ba36c8d user: jdennis)
2021-07-30
08:58 Reply: Round function returning -0.0 (artifact: f19825c660 user: jdennis)
07:07 Reply: Round function returning -0.0 (artifact: fc46f950a0 user: jdennis)
2021-07-21
10:15 Reply: SELECT optimization for constant expression (artifact: 73dc36c494 user: jdennis)
08:40 Edit reply: SELECT optimization for constant expression (artifact: d8e3ab4601 user: jdennis)
08:39 Reply: SELECT optimization for constant expression (artifact: 8592637c01 user: jdennis)
2021-07-11
12:01 Reply: Unstack one column to multiple (artifact: 745f7fe347 user: jdennis)
2021-04-17
03:09 Reply: SQL query help for between times and grouping times (artifact: da76705fa8 user: jdennis)
2021-04-13
12:17 Reply: count strings with same length (artifact: e6e107d431 user: jdennis)
2021-04-05
06:57 Reply: COUNT statement returns inconsistent values when used with UNION ALL (artifact: bfed5dc019 user: jdennis)
06:54 Reply: COUNT statement returns inconsistent values when used with UNION ALL (artifact: da426488b5 user: jdennis)
2021-03-23
10:29 Reply: When is SELECT ... FROM with no table-or-subquery valid. (artifact: edb167d7eb user: jdennis)
2021-03-14
10:54 Reply: Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS (artifact: 7de330ef72 user: jdennis)
09:46 Reply: Feature request: pragma for changing the precision / format of CURRENT_TIMESTAMP to YYYY-MM-SSTHH:MM:SS.SSS (artifact: 6be344edc6 user: jdennis)
2021-02-10
02:22 Reply: Split an Extract column (artifact: f3889668fe user: jdennis)
2021-02-02
11:36 Reply: SQLite3 Array? (artifact: deff0ca712 user: jdennis)
2021-01-27
06:09 Reply: Help with a search command (artifact: 9e370fcc42 user: jdennis)
03:47 Reply: Help with a search command (artifact: fa0dc202f7 user: jdennis)
2021-01-10
03:25 Reply: SELECT question (artifact: ec7f5b7fbe user: jdennis)
2020-11-29
02:42 Reply: Proposal: Add the SUBSTRING alias to the SUBSTR function (artifact: 79aa74c0c8 user: jdennis)
2020-11-27
01:33 Reply: How I can get all the information of *msf file? (artifact: 220baf7035 user: jdennis)
01:28 Reply: Proposal: Add the SUBSTRING alias to the SUBSTR function (artifact: 88b9365eed user: jdennis)
2020-11-06
10:16 Reply: no such table: generate_series (artifact: 077ef5df40 user: jdennis)
2020-10-07
10:37 Reply: Performance Issue: How can I increase a performance? (artifact: 56c4ee0905 user: jdennis)
08:36 Reply: Performance Issue: How can I increase a performance? (artifact: 1187c95a6c user: jdennis)
2020-10-05
09:19 Reply: Database integirity check returns Invalid Page number (artifact: 8b5ca35cd5 user: jdennis)
2020-09-05
07:57 Edit reply: Join Question (artifact: d4094ae0e6 user: jdennis)
07:00 Reply: Join Question (artifact: e75ea49649 user: jdennis)
2020-08-15
09:32 Reply: Time difference between two records (artifact: a6b23151e3 user: jdennis)
2020-08-11
12:07 Reply: Select by column id (artifact: d8a04672a1 user: jdennis)