meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 5 months |
| seen | yesterday | |
| stats | profile views | 1 |
|
Mar 12 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP Thanks @aaronbertrand for the assistance and education. I was able to convert all the dates correctly and filter the records out by the correct date. |
|
Feb 27 |
accepted | Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP |
|
Feb 27 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP @AaronBertrand I was originally basing the date range on CURRENT_TIMESTAMP. As previously posted below, I haven't really been in this scenario before so I'm doing information gathering/learning so I can program the right solution. |
|
Feb 27 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP @PaulWhite - I'll edit based on this wealth of information (which I'm still sorting through) as I was unsure what I had to work with when I made my original post. Stay tuned. |
|
Feb 27 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP @AaronBertrand They're basically month end reports for the management types broken down by Month, YTD, and things like that. |
|
Feb 26 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP @PaulWhite - Basically I want to pull all records that were entered into the database (for example) during a given month based on the CURRENT_TIMESTAMP. |
|
Feb 26 |
awarded | Commentator |
|
Feb 26 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP I was unaware of this. Never been in this situation with this scenaro before. Is there a link that I could look over to learn up on it? |
|
Feb 26 |
comment |
Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP When I add complexity to a statement such as SELECT * FROM table_name WHERE current_timestamp_column >= 'Jan 01 2013 10:00AM' order by current_timestamp_column I only get partial results. If I'm going to sort by Month, for example, out of 30 records that would qualify, only 20 show up. |
|
Feb 26 |
asked | Is there a sortable ('order by') alternative to CURRENT_TIMESTAMP |
|
Feb 22 |
comment |
What are the best practices for backing up a secured SQL Server 2012? Ok this I have taken care of but in addition to this I applied a SSL certificate to the server. Unless specifically noted, I don't see how this applies to the SSL scenario. One of my biggest gripes about this product is the lack of good, detailed documentation from MSFT about encrypting a SQL server with a 3rd party SSL and all processes/procedures associated with this including backups. |
|
Feb 22 |
comment |
What are the best practices for backing up a secured SQL Server 2012? It says 'Content Not Found' when clicked. |
|
Feb 22 |
asked | What are the best practices for backing up a secured SQL Server 2012? |
|
Feb 20 |
awarded | Scholar |
|
Feb 20 |
accepted | Resetting a SQL Server 2012 sequence |
|
Feb 19 |
comment |
Resetting a SQL Server 2012 sequence @BaconBits I do have SP1 applied on an Enterprise server. |
|
Feb 19 |
comment |
Resetting a SQL Server 2012 sequence I should note that this is a SQL 2012 SP 1 Enterprise installation. |
|
Feb 19 |
revised |
Resetting a SQL Server 2012 sequence added 27 characters in body |
|
Feb 19 |
asked | Resetting a SQL Server 2012 sequence |
|
Feb 13 |
awarded | Supporter |
