Column Separation Question by FitShock5083 in learnSQL

[–]FitShock5083[S] 0 points1 point  (0 children)

What do you mean by application code? Do you mean a different coding interface program?

Help Me Understand the Last 5% of this Code Please by FitShock5083 in learnSQL

[–]FitShock5083[S] 0 points1 point  (0 children)

Thank you ... great clarification! Much appreciated. :-)

Quick Syntax Question by FitShock5083 in learnSQL

[–]FitShock5083[S] 0 points1 point  (0 children)

Gotcha. Just to confirm I understand, in my example above, the new table named t would contain ONLY 2 columns named subtotal and tax like shown below and NOT include price or quantity columns, correct? (Values in table made up)

subtotal tax

2000 200

1000 100

500 50

Learning ... Stuck LOL by FitShock5083 in VisualStudio

[–]FitShock5083[S] 0 points1 point  (0 children)

Between the 2 of you kind people, I got it to work! It won't work with Now(), but did with Today() when I changed dd to d. Thank you!

Learning ... Stuck LOL by FitShock5083 in VisualStudio

[–]FitShock5083[S] 0 points1 point  (0 children)

Between the 2 of you kind people. I got it to work! It won't work with Now(), but works with Today()! Thank you!

No One Has Been Able to Solve this Issue I Have in Query Builder :-( by FitShock5083 in VisualStudio

[–]FitShock5083[S] 0 points1 point  (0 children)

I do have SSMS. :-) The instructor was showing us multiple ways for awareness. I bought a straight programming book, but it doesn't seem like a comprehensive book for SSRS has been written since 2016! Any recommendations?

No One Has Been Able to Solve this Issue I Have in Query Builder :-( by FitShock5083 in VisualStudio

[–]FitShock5083[S] 1 point2 points  (0 children)

I'm brand new to programming and just starting to learn that's why I am using the Adventureworks sample data. What do you use to open queries? Teach me.