Reputation
7,429
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 9 22
Newest
 Constituent
Impact
~193k people reached

1d
revised Select when group by contains more than one row with the same value?
added 1 character in body
1d
revised Select when group by contains more than one row with the same value?
rolled back to a previous revision
1d
comment Select when group by contains more than one row with the same value?
STUFF() is just to remove the leading comma. The FOR XML PATH bit does the concatenation.
1d
revised Select when group by contains more than one row with the same value?
added 451 characters in body
1d
answered Select when group by contains more than one row with the same value?
Aug
27
answered Selecting multiple rows as one row with “AS”
Aug
24
revised Where clause in the query
added 30 characters in body
Aug
24
answered Where clause in the query
Aug
21
answered can i shrink log file in full recovery model
Aug
17
revised Why does my WHERE clause benefit from an “included” column?
added 137 characters in body; added 343 characters in body; added 52 characters in body
Aug
17
revised Why does my WHERE clause benefit from an “included” column?
added 17 characters in body
Aug
17
revised Why does my WHERE clause benefit from an “included” column?
added 1547 characters in body
Aug
17
answered Why does my WHERE clause benefit from an “included” column?
Aug
12
answered Is it possible to develop a SSIS with a SQL Server Evaluation Version
Aug
6
answered How can I optimize searching a column for a sub-string in SQL Server?
Aug
6
comment Converting Access SQL HAVING command to T-SQL
It depends on what you're trying to do - but it's standard Access. The fact that your table is hooking into a SQL view should make no difference. Explore how to filter a table by a form element, and then just point it at the view.
Aug
6
comment Converting Access SQL HAVING command to T-SQL
What are you using for your form? If it's Access, then you do exactly the same as you would for a table.
Aug
6
comment Converting Access SQL HAVING command to T-SQL
You create the view WITHOUT the HAVING clause. But then you use the view as if it's a table, specifying the value in the WHERE clause, passing it in from your form like you would for any table.
Aug
6
comment Converting Access SQL HAVING command to T-SQL
A view doesn't store data. When you use the view, providing the value for Guia when you do, it runs the query, using the value as if it's in the HAVING clause.
Aug
6
revised Help with recursing self-referencing table
added 18 characters in body