Viewing 15 posts - 4,861 through 4,875 (of 8,731 total)
Why would you need something like that? The only option is to use dynamic SQL.
It seems as well that you have a design problem. If you can change the design...
June 1, 2015 at 11:24 am
Do you need to get Server/component compound that change from bad to good and again to bad? Or would you include the ones that go from good to bad and...
June 1, 2015 at 11:07 am
To start, you're using 2 tables instead of 1.
Even if you weren't, the subquery used in the CROSS APPLY will be executed once per row (as shown by the...
June 1, 2015 at 11:01 am
Do you need information from April somewhere else in your report?
If you don't you should probably change the query to obtain your resultset. We could help you with that if...
June 1, 2015 at 10:21 am
I'd do it as YB mentioned, but using SSIS. You have your parameter and a variable that should work as an expression where you use conditional (condition?true:false) to evaluate if...
June 1, 2015 at 10:01 am
I'm not sure what are you doing and why you're using so many self-joins.
But, to answer your question, dbo.QABSNew is ambiguous because you are referencing it twice in your FROM...
June 1, 2015 at 9:56 am
thisisfutile (5/29/2015)
jshahan (5/28/2015)
Just picked up from The Thread that old Joe has been banned from SSC.
You picked up from this thread that Joe is banned? Maybe I scanned it...
May 29, 2015 at 12:41 pm
I'm not sure if you've seen this, but it made me laugh and wanted to share it with you.
http://geekandpoke.typepad.com/geekandpoke/2011/01/nosql.html
May 29, 2015 at 10:20 am
Take a look at this thread.
http://www.sqlservercentral.com/Forums/Topic1688498-3077-1.aspx
May 29, 2015 at 10:10 am
Please share your test with us when you have it. 🙂
May 28, 2015 at 3:59 pm
Are you aware of the difference between 6 months and 180 days? It's a small change, but it can make a difference if you have the requirement wrong.
May 28, 2015 at 2:22 pm
AFAIR, it has always been like this and it will give troubles as well when you use SELECT * and you change the order or number of columns in the...
May 28, 2015 at 2:06 pm
It's funny how Aaron and Dwain have different conclusions. I trust that they both know what they're doing, so I would just repeat the tests myself.
However, I might end up...
May 28, 2015 at 1:48 pm
You could check this article by Dwain Camps https://www.simple-talk.com/sql/t-sql-programming/calculating-values-within-a-rolling-window-in-transact-sql/
May 28, 2015 at 1:14 pm
Have you tried with sp_refreshview?
May 28, 2015 at 10:33 am
Viewing 15 posts - 4,861 through 4,875 (of 8,731 total)