Viewing 10 posts - 1 through 10 (of 10 total)
"If you do it more than once in a year - you need to rethink you approach to T-SQL programming, and probably take some lessons on how to do it...
January 12, 2016 at 7:45 am
Yes. I also use CTE's to "clean up my code". Especially if it is something being called multiple times within the select. I do not think there is...
January 11, 2016 at 11:43 am
Never be afraid to ask for help. Read about all the topics you can. I find that eventually things will start to click. Immerse yourself.
You had one...
January 8, 2016 at 7:29 am
Agreed. I have watched some of the Microsoft virtual academy labs and they state that the are moving everyone to the ise.
August 23, 2015 at 8:52 am
This is great! I would love to start using powershell more!
Question - Do you need to load the function every powershell session? Or, can they be stored somewhere...
August 19, 2015 at 6:39 am
Yes. Please provide more detail.
TABLE A
COLUMN 1 , COLUMN 2, COLUMN 3
TABLE B
etc.....
April 3, 2015 at 6:00 am
How many records? I find that right clicking on an empty table and selecting edit top 200 rows. From there, you can past the contents of the excel...
March 30, 2015 at 5:48 am
Hello,
Are the tables in access imported into a sql server instance? Access sql likes to put a lot of unnecessary '(' in code.
March 25, 2015 at 5:21 am
I know that this is not the perfect answer. This requires use of the kimbal date dimension. If you have that, it's super simple. Use analytic functions. 🙂
SELECT...
February 21, 2013 at 1:28 pm
Viewing 10 posts - 1 through 10 (of 10 total)