Can you help me on this?

  • 1) In my table i have two columns i.e Name and marks,if i do aggregation on those two tables... what will be the output ?
    2) We have 3 Diff Servers i.e Server1,Server2,Server3 and we have 3 Diff tables on these 3 Servers and we have a common column between these tables and i want you to put the Combined data in a resultset.Here,problem is that we do not have linked servers between these servers. So, can we findout the resultset ?
    3) I have Excel File with 10,000 records and all are with error.How do you import the file in to table without failing the SSIS Package?
    4) I have created pkg with 32bit machine and the server where iam deploying it is 64bit machine ? How to handle it ?
    5) I have a Scenario where client gives excel file on a particular location,now you have to create report on top of that excel sheet,so insert the data and create ssis package.what steps will you follow to get that excel file data into sql table? One day your job fails and client has forgot to paste that excel sheet there,in that scenario what will you do?
    6) I have a report and there are 3 diff prompts on the report and its a simple plain report and now client says that when ever he runs the report i mean i enter the text,run the report and text is displayed on the report.How?
    7) Suppose i have one report and a dataset in that to display the reports but, there is one column in that dataset that requires calculations using one common value and that value is also coming from database.So,by writing complex logic query iam getting that single value in calculations.So,tellme how we can do that in SSRS ?
    8) Can we declare variable in SSRS that we can populate using query before report loads?

  • This all looks like homework and why have you posted it 3 times?

    Thanks

  • Please don't post the same question in 3 different forums. Direct answers to this post here: https://www.sqlservercentral.com/Forums/2014435/Can-you-help-me-on-this

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • NorthernSoul - Monday, December 24, 2018 4:16 AM

    This all looks like homework and why have you posted it 3 times?

    Thanks

    That was a mistake.
    Can you help me here?

  • We are happy to help, but not do the work for you. What have you done?  There are some questions and notes in the post in the T-SQL forum.

    1. Show some sample DDL and data here. What did you try?

    For others, these are somewhat generic questions, with often could have be partially answered with some research. We would expect you to do some of that and ask questions for specific items you do not understand.

  • Krishh - Monday, December 24, 2018 4:20 AM

    NorthernSoul - Monday, December 24, 2018 4:16 AM

    This all looks like homework and why have you posted it 3 times?

    Thanks

    That was a mistake.
    Can you help me here?

    I've replied on your thread I linked to. Steve has locked the other 2, but his point mirrors mine; I could only give very broad answers or "yes/no", with no detail on how to achieve it. If you want to respond to my comments other topic, please do so here and we can try to help you further, but we need (a lot) more information here.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Hi Guys,

    These are the interview questions i faced in Msbi.
    Please help me?

  • You should do some research to try and understand. Us answering these questions for an interview doesn't help you or an employer. If you have specific questions on any of these after doing some work, ask those.

  • Krishh - Monday, December 24, 2018 9:27 AM

    Hi Guys,

    These are the interview questions i faced in Msbi.
    Please help me?

    If these are questions you faced in an interview and couldn't answer, that tells me you need to do more research on your own as well as practicing with the technologies to learn more.  Asking us for answers really doesn't help you learn.  While researching and practicing you run into things you don't understand, come here and ask specific questions to help your understanding.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply