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.
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...
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...
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...
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...
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...
July 29, 2015 at 6:04 am
Agree.
Richard Warr (7/28/2015)
SELECT Value
FROM...
July 28, 2015 at 5:40 am
Too bad you couldn't make it. There were some great sessions.
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...
May 14, 2015 at 5:51 am
sestell1 (3/23/2015)
Rune Bivrin (3/23/2015)
March 23, 2015 at 11:06 am
Thanks for the question.
Glad to see over 80% got this right (so far)
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...
March 10, 2015 at 11:13 am
Viewing 15 posts - 1 through 15 (of 146 total)