meta user
network profile
| bio | website | onlybluefeet.com |
|---|---|---|
| location | Arizona | |
| age | 37 | |
| visits | member for | 11 months |
| seen | 25 mins ago | |
| stats | profile views | 128 |
developer, techie, nerd.....
My feet are blue from running or I am part smurf. I haven't figured it out yet.
contact:
|
1h |
comment |
How can I group sql rows by hours? Cross-posted on SO stackoverflow.com/questions/16719046/… |
|
3h |
accepted | How to get a row_number to have the behavior of dense_rank |
|
12h |
awarded | Notable Question |
|
18h |
comment |
How to get a row_number to have the behavior of dense_rank @AaronBertrand No we are not filtering the parameters that way. The grp table has columns with different indicators, let's say the group is restricted to certain users based on the group owner, we are verifying that the proc only is returning the rows that the person has access to...there are several ORs in the where clause but it is not a check between the @param is null or column = @param. |
|
18h |
comment |
How to get a row_number to have the behavior of dense_rank @AaronBertrand The order by is exactly what I placed in this post. The stored proc has a large block of where filtering is used when the initial row_number is applied to the result. |
|
18h |
comment |
How to get a row_number to have the behavior of dense_rank @PaulWhite This was a small piece of a stored proc. I trimmed down the details significantly to get a solution to this specific problem. I would be open to other suggestions/solutions. |
|
20h |
comment |
How to get a row_number to have the behavior of dense_rank Well of course this appears to be working, I just need to test it a bit more with the entire proc. |
|
20h |
asked | How to get a row_number to have the behavior of dense_rank |
|
23h |
reviewed | Reviewed Troubleshooting SOS_SCHEDULER_YIELD wait |
|
23h |
reviewed | Reviewed Performance effect of indexing foreign keys |
|
1d |
comment |
Merging two Access tables into one Do the tables, queries, macros, etc have the same names? Or are the names of object different? |
|
2d |
reviewed | Reviewed Replicating schema changes between production and development databases |
|
2d |
reviewed | Reviewed Replicating schema changes between production and development databases |
|
2d |
awarded | Constituent |
|
May 17 |
revised |
Database design: Two 1 to many relationships to the same table added the images |
|
May 17 |
suggested | suggested edit on Database design: Two 1 to many relationships to the same table |
|
May 16 |
revised |
Single quote issue updated format |
|
May 16 |
suggested | suggested edit on Single quote issue |
|
May 15 |
reviewed | Reviewed Configuring PostgreSQL for read performance |
|
May 15 |
awarded | Informed |
