Script to create TotalSale Table with Data for Practice

Use below script to create SaleTotal Table with Data so you can practice the demos done in SSRS Video Tutorial

CREATE TABLE [dbo].[TotalSale] (
    [id] [int] NOT NULL
    ,[SalePersonFName] [varchar](100) NULL
    ,[SalePersonLName] [varchar](100) NULL
    ,[ProductName] [varchar](100) NULL
    ,[ItemsSold] [int] NULL
    ,[SoldPrice] [float] NULL
    ,[SoldDate] [date] NULL
    ,[City] [varchar](100) NULL
    ,[State] [varchar](100) NULL
    ,[Country] [varchar](100) NULL
    ,[Region] [varchar](100) NULL
    )

INSERT [dbo].[TotalSale] (
    [id]
    ,[SalePersonFName]
    ,[SalePersonLName]
    ,[ProductName]
    ,[ItemsSold]
    ,[SoldPrice]
    ,[SoldDate]
    ,[City]
    ,[State]
    ,[Country]
    ,[Region]
    )
VALUES (
    1
    ,N'Aamir'
    ,N'Shahzad'
    ,N'TV'
    ,1
    ,700
    ,CAST(N'2015-07-15' AS DATE)
    ,N'Charlotte'
    ,N'NC'
    ,N'USA'
    ,N'North America'
    )
    ,(
    2
    ,N'M'
    ,N'Raza'
    ,N'Cell Phone'
    ,2
    ,800
    ,CAST(N'2015-07-15' AS DATE)
    ,N'Charlotte'
    ,N'NC'
    ,N'USA'
    ,N'North America'
    )
    ,(
    3
    ,N'Christy'
    ,N'Ladson'
    ,N'TV'
    ,3
    ,1600
    ,CAST(N'2015-04-02' AS DATE)
    ,N'High Point'
    ,N'NC'
    ,N'USA'
    ,N'North America'
    )
    ,(
    4
    ,N'John'
    ,N'Rivers'
    ,N'Laptop'
    ,5
    ,2400
    ,CAST(N'2014-03-09' AS DATE)
    ,N'Jersey City'
    ,N'NJ'
    ,N'USA'
    ,N'North America'
    )
    ,(
    5
    ,N'Najaf'
    ,N'Ali'
    ,N'Computer'
    ,1
    ,300
    ,CAST(N'2015-06-20' AS DATE)
    ,N'Karachi'
    ,N'Sindh'
    ,N'Pakistan'
    ,N'Asia'
    )
    ,(
    6
    ,N'Sukhjeet'
    ,N'Singh'
    ,N'TV'
    ,2
    ,900
    ,CAST(N'2015-06-21' AS DATE)
    ,N'ChandiGar'
    ,N'Punjab'
    ,N'India'
    ,N'Asia'
    )
    ,(
    7
    ,N'Chirag'
    ,N'Patel'
    ,N'Cell Phone'
    ,5
    ,1500
    ,CAST(N'2015-06-23' AS DATE)
    ,N'AhmadAbad'
    ,N'Gujrat'
    ,N'India'
    ,N'Asia'
    )
    ,(
    8
    ,N'Aleena'
    ,N'Aman'
    ,N'Laptop'
    ,2
    ,800
    ,CAST(N'2015-05-25' AS DATE)
    ,N'Lahore'
    ,N'Punjab'
    ,N'Pakistan'
    ,N'Asia'
    )
    ,(
    9
    ,N'Petra'
    ,N'Henry'
    ,N'TV'
    ,10
    ,5000
    ,CAST(N'2015-04-08' AS DATE)
    ,N'Paris'
    ,N'Île-de-France'
    ,N'France'
    ,N'Europe'
    )
    ,(
    10
    ,N'Rita'
    ,N'Roger'
    ,N'Laptop'
    ,7
    ,2100
    ,CAST(N'2015-04-11' AS DATE)
    ,N'Paris'
    ,N'Île-de-France'
    ,N'France'
    ,N'Europe'
    )
    ,(
    11
    ,N'Tamara'
    ,N'Tony'
    ,N'Cell Phone'
    ,2
    ,1200
    ,CAST(N'2015-03-03' AS DATE)
    ,N'Frankfurt'
    ,N'Hesse'
    ,N'Germany'
    ,N'Europe'
    )

No comments:

Post a Comment