Priting a pyramid by using TSQL

Hi Team,

I have been observed that many of the interviews people are asking printing the pyramid like below by using SQL server.

 

So I am giving a script to that one

DECLARE @lclMaxLevel INT=5
DECLARE @lclPrintCount INT =0

WHILE @lclMaxLevel > 0
  BEGIN
      PRINT Space(@lclMaxLevel)
            + Replicate('*', @lclPrintCount)
            + Replicate('*', @lclPrintCount+1)

      SET @lclMaxLevel=@lclMaxLevel - 1
      SET @lclPrintCount=@lclPrintCount + 1
  END

Output as follows:

Let me know if you have any doubts on this.

Thanks
SQL Srinivas

***New MS SQL SERVER Development Batch from 16th June***

Team,

We are going to start a new batch for MS SQL SERVER development(TSQL &TSQLProgramming) on 16th June at 10-11 PM ISD.

Please find the below Course content

MS SQL SERVER DEVELOPMENT COURSE CONTENT

let your friends/relatives/colleagues, near and  dear know if any one are in need the same.

Thanks
ADMIN

***New MSBI SSAS Batch from 6th June***

Hi Team,

I am glad to inform you that we are going to start a new MSBI-SSAS(including MDX) batch on 6th June 2015.Please find the below details.

Batch Type-weekend(only on Sat and sunday)

Number of hours per day--3(3+3)

Prerequisites--Nothing(basic SQL is fine)

timings--6 to 9PM ISD

Number of hours- SSAS+MDX(15+7)--in max of 25 hours You will become experts in SSAS and MDX queries.

Let me know if you need any more information on this.

Thanks
Admin Team