|
In an SQL script, how to get one line by clientid with the most current period end and discard the rest - thank you
|
|
1
|
222
|
April 27, 2023
|
|
Can not connect session database via web application
|
|
1
|
1085
|
April 27, 2023
|
|
Case , Partitioning with Null check
|
|
2
|
536
|
April 26, 2023
|
|
When to use Having?
|
|
6
|
450
|
April 26, 2023
|
|
SQL code CTE's
|
|
1
|
317
|
April 25, 2023
|
|
'Distingish between 'GROUP BY' and ' ORDER BY'?
|
|
4
|
348
|
April 25, 2023
|
|
I need to locate all '@' in the login name field
|
|
3
|
296
|
April 24, 2023
|
|
How to split a string with special text from SQL column?
|
|
7
|
724
|
April 24, 2023
|
|
AVG on TIME
|
|
0
|
216
|
April 23, 2023
|
|
'LIKE' or '=' in SQL statement
|
|
5
|
354
|
April 22, 2023
|
|
Cursor returns also empty records
|
|
3
|
600
|
April 21, 2023
|
|
Query performance help
|
|
4
|
238
|
April 21, 2023
|
|
User Segmentation in Google Analytics Data via SQL
|
|
1
|
321
|
April 20, 2023
|
|
Table Reference in FROM and Subqueries
|
|
1
|
311
|
April 20, 2023
|
|
XML replace Value
|
|
1
|
301
|
April 20, 2023
|
|
Copy table to new empty talbe with indexes and identity
|
|
14
|
1715
|
March 24, 2023
|
|
To Remove Cursor and use update/insert statement for deadlock issue
|
|
1
|
404
|
April 18, 2023
|
|
Window Function SQL Help! Grouping
|
|
2
|
218
|
April 17, 2023
|
|
XML data schema to SQL table inserts
|
|
1
|
338
|
April 14, 2023
|
|
Create sequence
|
|
4
|
398
|
April 15, 2023
|
|
Unable to use the SQL function in my SSRS SELECT Statement as text in Dataset Properties
|
|
4
|
530
|
April 14, 2023
|
|
Exporting Query Results to CSV Not Receiving What I see
|
|
1
|
216
|
April 14, 2023
|
|
Finding the month over month and year over month comparison metrics
|
|
1
|
257
|
April 14, 2023
|
|
Table with incorrect data in columns
|
|
3
|
219
|
April 14, 2023
|
|
Column not found error on alias
|
|
3
|
257
|
April 14, 2023
|
|
SQL query how to take out the average weight for the column
|
|
9
|
857
|
April 13, 2023
|
|
Database schema and permissions
|
|
3
|
197
|
April 13, 2023
|
|
Can not Truncate the database because "secondaries has no log was added"
|
|
5
|
1851
|
April 13, 2023
|
|
Adding Listener for Availability Group
|
|
3
|
331
|
April 13, 2023
|
|
Why using COUNT for the SELECT section?
|
|
1
|
163
|
April 12, 2023
|