Viewing 15 posts - 1 through 15 (of 146 total)
This is why I never use aproximate values.
Being in a financial field, I've never really had the need to use those.
---------------
Mel. 😎
August 13, 2015 at 6:21 am
I based my answer on the part about the style which says that the default is 6 digits.
I believe this is the actual reason why we get that result. Can...
---------------
Mel. 😎
August 10, 2015 at 6:02 am
...Even if a rowset were returned, the the rowset could be sorted as the last action of the select statement, ie after the assignment, so not assigning the value from...
---------------
Mel. 😎
July 29, 2015 at 11:28 am
Of course. I learned that lesson a looooong time ago 😀
Sean Lange (7/29/2015)
SqlMel (7/29/2015)
I ALWAYS use Top 1 when assigning values to...
---------------
Mel. 😎
July 29, 2015 at 11:26 am
I mostly do this to read parameter values that I have set up in tables so in all the cases I can think of I only get returned one row...
---------------
Mel. 😎
July 29, 2015 at 11:26 am
Good question and something to keep in mind always.
I ALWAYS use Top 1 when assigning values to variables even though in all cases I can think of I use a...
---------------
Mel. 😎
July 29, 2015 at 6:04 am
Agree.
Richard Warr (7/28/2015)
SELECT Value
FROM...
---------------
Mel. 😎
July 28, 2015 at 5:40 am
Too bad you couldn't make it. There were some great sessions.
---------------
Mel. 😎
June 4, 2015 at 8:04 am
I knew I had this from the start since I've made the mistake of not putting the GO statement before calling the SP, as shown in batch 1.
After that, it...
---------------
Mel. 😎
May 14, 2015 at 5:51 am
sestell1 (3/23/2015)
Rune Bivrin (3/23/2015)
---------------
Mel. 😎
March 23, 2015 at 11:06 am
Thanks for the question, Steve.
---------------
Mel. 😎
March 13, 2015 at 6:06 am
Thanks for the question.
Glad to see over 80% got this right (so far)
---------------
Mel. 😎
March 11, 2015 at 6:19 am
Very good question, Tom.
It was easy for me since I knew beforehand that the foreign key would be ignored and the temp table would be created.
Hope to see more questions...
---------------
Mel. 😎
March 10, 2015 at 11:13 am
Viewing 15 posts - 1 through 15 (of 146 total)