1 T0 30 Multipler - SQL SERVER

-

Select Convert(Varchar,[1]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([1]* Rno)) ,
Convert(Varchar,[2]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([2]* Rno))  [2] ,
Convert(Varchar,[3]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([3]* Rno))  [3] ,
Convert(Varchar,[4]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([4]* Rno))  [4] ,
Convert(Varchar,[5]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([5]* Rno))  [5] ,
Convert(Varchar,[6]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([6]* Rno))  [6] ,
Convert(Varchar,[7]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([7]* Rno))  [7] ,
Convert(Varchar,[8]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([8]* Rno))  [8] ,
Convert(Varchar,[9]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([9]* Rno))  [9] ,
Convert(Varchar,[10]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([10]* Rno))  [10] ,
Convert(Varchar,[11]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([11]* Rno))  [11] ,
Convert(Varchar,[12]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([12]* Rno))  [12] ,
Convert(Varchar,[13]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([13]* Rno))  [13] ,
Convert(Varchar,[14]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([14]* Rno))  [14] ,
Convert(Varchar,[15]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([15]* Rno))  [15] ,
Convert(Varchar,[16]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([16]* Rno))  [16] ,
Convert(Varchar,[17]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([17]* Rno))  [17] ,
Convert(Varchar,[18]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([18]* Rno))  [18] ,
Convert(Varchar,[19]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([19]* Rno))  [19] ,
Convert(Varchar,[20]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([20]* Rno))  [20] ,
Convert(Varchar,[21]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([21]* Rno))  [21] ,
Convert(Varchar,[22]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([22]* Rno))  [22] ,
Convert(Varchar,[23]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([23]* Rno))  [23] ,
Convert(Varchar,[24]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([24]* Rno))  [24] ,
Convert(Varchar,[25]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([25]* Rno))  [25] ,
Convert(Varchar,[26]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([26]* Rno))  [26] ,
Convert(Varchar,[27]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([27]* Rno))  [27] ,
Convert(Varchar,[28]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([28]* Rno))  [28] ,
Convert(Varchar,[29]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([29]* Rno))  [29] ,
Convert(Varchar,[30]) + ' X ' + Convert(Varchar,Rno) + ' = ' + Convert(Varchar,([30]* Rno))  [30]

from
(
Select * from
(
Select Top 30 RNO From
(
Select ROW_NUMBER() Over (order by name) Rno from sys.columns
) Col
) Col
PIVOT
(
Max(RNO) For RNO IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30])  
) as PVT
) AllData


Outer Apply
(
Select Top 10 RNO From
(
Select ROW_NUMBER() Over (order by name) Rno from sys.columns
) Col
) Col

Comments

Post a Comment

Popular posts from this blog

Shared / Static Class in vb.net/C#

-
Image
Shared / Static Class in vb.net/C# VB.net     : Shared C#            : Static You can’t create object of Shared Class Below Image show Properties and Method are not visible for Shared/Static Class Public Class Form1     Private Sub Button1_Click(sender As Object , e As EventArgs ) Handles Button1.Click         'Module is VB.net are Shared Type Class.         'Shared Class Example is ARC.Tools.GRIDManager         'When Class s Defined as Shared There no need to create object of Class.         'If you just want to create a class that you can't inherit, in C# you can use         ' Sealed, and in VB.Net use NotInheritable.         'The VB.Net equivalent of s...
Read more

Xamarin Forms : PopUp Page with RG.Plugins.Popup

-
Image
How to Show PopUp Page In Xamarin Forms Step 1 First, we need to add the Third Page Plugin to achieve the same. [ Rg.Plugins.Popup ] Go to Manage Nuget Packages - > Search for Rg.Plugins.Popup Once the plugin is installed in the Project We need to configure same in Android and IOS Projects In Android   - Go to MainActivity.cs Code:     Rg.Plugins.Popup. Popup .Init( this , savedInstanceState); In IOS –   Go to   - AppDelegate.cs Code : Rg.Plugins.Popup. Popup .Init(); Now Back to Main Project (PCL) Step – 1 :   Add Page in Project Once Added Page Change the Tag of Page Default Page has Content page as Tag which needs to be replaced with PopUpPage Class  :  Default Page:- Class < ContentPage  xmlns ="http://xamarin.com/schemas/2014/forms" Change To < pages : PopupPage  xmlns ="http://xamarin.com/schemas/2014/forms" This is how it should Lo...
Read more

Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)

-
Image
  Error While importing Excel Data using SQL Server Import Wizard   - Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with Source - Worksheet$.Outputs[Excel Source Output].Columns[Address] on Source - Worksheet$.Outputs[Excel Source Output]. The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".  (SQL Server Import and Export Wizard)   Error 0xc020902a: Data Flow Task 1: The "Source - Worksheet$.Outputs[Excel Source Output].Columns[Address]" failed because truncation occurred, and the truncation row disposition on "Source - Worksheet$.Outputs[Excel Source Output].Columns[Address]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.  (SQL Server Import and Export Wizard)   - Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with Source - Worksheet$.Outputs[Excel Source O...
Read more