tag:blogger.com,1999:blog-2379842053067321961.post3692067292843159953..comments2024-03-28T23:30:56.697-07:00Comments on Welcome To TechBrothersIT: SSRS Tutorial 05 - Intro to Embedded Data Sets and Shared Data Sets in SQL Server Reporting ServicesAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2379842053067321961.post-10392276887787089752019-09-17T15:29:40.817-07:002019-09-17T15:29:40.817-07:00To create dbo.Sale table:
CREATE TABLE dbo.Sale
...To create dbo.Sale table:<br /><br />CREATE TABLE dbo.Sale<br /> (<br /> PersonName VARCHAR(100),<br /> SaleYear INT,<br /> SaleMonth VARCHAR(15),<br /> SaleAmount INT<br /> )<br /><br />go<br /><br />insert into dbo.Sale<br />Select 'Aamir',2012,'January',100<br />Union All<br />Select 'Aamir',2012,'February',200<br />Union All<br />Select 'Aamir',2012,'March',900<br />Union All<br />Select 'Aamir',2012,'April',456<br />Union All<br />Select 'Aamir',2012,'May',123<br />Union All<br />Select 'Aamir',2012,'June',332<br />Union All<br />Select 'Aamir',2012,'July',543<br />Union All<br />Select 'Aamir',2012,'August',765<br />Union All<br />Select 'Aamir',2012,'September',900<br />Union All<br />Select 'Aamir',2012,'October',100<br />Union All<br />Select 'Aamir',2012,'November',500<br />Union All<br />Select 'Aamir',2012,'December',100<br />Union All<br />Select 'Aamir',2013,'January',20<br />Union All<br />Select 'Raza',2011,'February',1001Anonymoushttps://www.blogger.com/profile/03873218152457127311noreply@blogger.com