March 10, 2014 at 9:44 am
I got task, Please help me out
The objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance of Analysis Services, and follow the specifications as specified in the “Report Specs” sheet.
At the end of the test, you will be expected to demonstrate your code, and discuss the design, implementation, limitations, and potential future enhancements.
Please check image for more details..thanks
March 10, 2014 at 9:50 am
koti.raavi (3/10/2014)
I got task, Please help me outThe objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance of Analysis Services, and follow the specifications as specified in the “Report Specs” sheet.
At the end of the test, you will be expected to demonstrate your code, and discuss the design, implementation, limitations, and potential future enhancements.
Please check image for more details..thanks
Is this a test or just homework? Either way...what have you done? We are not going to do your homework for you, you don't learn anything that way. We can however help you figure it out.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 10, 2014 at 9:54 am
I can understand but i have got very less time..It would be really helpful if you can give some hints or tips..which makes the work done faster.Thank You.!!
March 10, 2014 at 9:56 am
See my response on this other thread.
http://www.sqlservercentral.com/Forums/FindPost1549320.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2014 at 10:00 am
koti.raavi (3/10/2014)
I can understand but i have got very less time..It would be really helpful if you can give some hints or tips..which makes the work done faster.Thank You.!!
Tests are designed to evaluate what YOU know about a topic, not how well you can google and beg somebody else to provide an answer for you. I can ensure you that just because you didn't spend the time studying prior to your test is no emergency for me. Good luck on your test.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 10, 2014 at 10:05 am
Sean Lange (3/10/2014)
koti.raavi (3/10/2014)
I can understand but i have got very less time..It would be really helpful if you can give some hints or tips..which makes the work done faster.Thank You.!!Tests are designed to evaluate what YOU know about a topic, not how well you can google and beg somebody else to provide an answer for you. I can ensure you that just because you didn't spend the time studying prior to your test is no emergency for me. Good luck on your test.
How very nicely put.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2014 at 10:20 am
Hi Mate I know that i'm doing wrong..but thing is like if i get some idea how to do it i can finish as early as possible. Well i can do task my self..the only problem is haven't much time and very important to me..I always do mistakes while doing fast..so i don't want to make complicated..thanks
March 10, 2014 at 10:28 am
koti.raavi (3/10/2014)
Hi Mate I know that i'm doing wrong..but thing is like if i get some idea how to do it i can finish as early as possible. Well i can do task my self..the only problem is haven't much time and very important to me..I always do mistakes while doing fast..so i don't want to make complicated..thanks
Then maybe you should spend your valuable test time working on the test instead of trying to figure out how to cheat. Keep in mind that this is a professional site and that long after you are out of school this thread will be there with history that you were openly trying to cheat on your exams. Not going to look so good to a potential future employer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply