Viewing 15 posts - 181 through 195 (of 397 total)
SELECT CAST(ABS(CAST(CAST(FirstDate AS DATETIME) AS INT) - CAST(CAST(SecondDate AS DATETIME) AS...LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 8, 2017 at 2:09 pm
This appears to work
DECLARE @mytable TABLE(ColumnA INT, ColumnB CHAR(1))
INSERT...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 10:08 am
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 8:36 am
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER BY ColumnB) +
DENSE_RANK() OVER(PARTITION BY ColumnA ORDER...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 8:33 am
Actually, let me clarify it a bit more and simplify the situation more succinctly: LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 5:45 am
SELECT a.*
FROM dbo.ComplexQuery AS a
WHERE COUNT(DISTINCT ColumnD) OVER(PARTITION...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 5:28 am
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
March 3, 2017 at 5:27 am
While I've most likely forgotten a number of them, these are the ones that stick out in my mind most readily:
BASIC (DEC...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
February 24, 2017 at 6:53 am
If, however,...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
February 10, 2017 at 3:16 pm
Since Steve was kind enough to re-post this in today's daily email, I just now was able to read this posting. Nice job Gail!
While the purpose of the...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
February 10, 2017 at 1:28 pm
Blech! I knew the right answer but clicked the wrong option. Goes to prove that jumping too quickly to answer without double-checking can be hazardous!
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
January 4, 2017 at 5:40 am
The team did identify a method of pushing the data to SQL Server but this approach requires coordinating the stored procedure execution on SQL Server to occur AFTER the data...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
December 5, 2016 at 9:31 am
That's the thing I like about you Jeff. You're always full of optimism and hope! 😛
However, I've not given up hope yet. Who know, since support for XML...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
December 5, 2016 at 9:17 am
Carlo Romagnano (9/22/2016)
Aaron N. Cutshall (9/22/2016)
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 22, 2016 at 7:59 am
I got the responses correct except that I also included "Command(s) completed successfully." -- which does flash briefly due to the master table creating successfully (doing them individually shows that...
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
September 22, 2016 at 6:56 am
Viewing 15 posts - 181 through 195 (of 397 total)