Business Intelligence

It contains lots on Business Intelligence scenarios and solutions along with real problems regarding Microsoft Excel, SQL Server Reporting Services, SQL Server Integration & Analysis Services and various databases and also may contain other popular posts.

  • Home
  • SQL Server
    • Interview Questions
    • Topics
    • Issues
    • Important queries
  • Trace mobile number
  • Objective questions
    • C#.NET
  • SSRS
    • Issues
  • SSIS
    • Topics
    • Issues
  • Oracle
    • Topics
  • About

Sunday, 31 May 2015

SQL Server Important queries

Question 1: Write a query which will produce the below output ?








(View answer)

Question 2: Using CTE, how to write a recursive query which will define the organization hierarchy level ?






















(View answer)
Posted by vipul sachan at 16:50
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Subscribe

Blog Archive

  • ►  2017 (1)
    • ►  January (1)
  • ►  2016 (5)
    • ►  December (1)
    • ►  March (1)
    • ►  February (3)
  • ▼  2015 (15)
    • ►  June (5)
    • ▼  May (5)
      • SQL Server Important and common interview queries
      • SQL Server Important queries
      • SQL Server Important and common interview queries
      • SET ANSI_NULLS ON/OFF Setting in Sql Server
      • How to remove any extra column from a CSV file usi...
    • ►  March (2)
    • ►  February (2)
    • ►  January (1)
  • ►  2014 (8)
    • ►  May (1)
    • ►  April (6)
    • ►  February (1)
  • ►  2013 (18)
    • ►  November (1)
    • ►  October (3)
    • ►  September (3)
    • ►  July (3)
    • ►  June (5)
    • ►  May (3)

Popular Posts

  • C#: Read and Write Excel (*.xls and *.xlsx) Files Content without Excel Automation using ADO.NET ?
  • Microsoft sql server error 18456 login failed for user
  • Convert DataTable to List in c#
  • Create Linked Servers (SQL Server)
  • SSRS: Use single transaction when processing the queries
  • IIS Manager Error - HRESULT 0X80070020 - THE PROCESS CANNOT ACCESS THE FILE BECAUSE IT IS BEING USED BY ANOTHER PROCESS
  • Sending an email by using C# Asp.Net
  • Azure Blob Storage handling using c#
  • Run batch file during installation
  • ACCESS TO THE REMOTE SERVER IS DENIED BECAUSE THE CURRENT SECURITY CONTEXT IS NOT TRUSTED
Theme images by Jason Morrow. Powered by Blogger.