tag:blogger.com,1999:blog-2379842053067321961.post6201625947436484052..comments2024-03-29T04:59:05.284-07:00Comments on Welcome To TechBrothersIT: SSRS Tutorial 13 - Use Query Builder Features in Report Wizard to create SQL Query for ReportAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2379842053067321961.post-60688440799042901272019-10-27T15:40:28.940-07:002019-10-27T15:40:28.940-07:00It would have been helpful if you would have provi...It would have been helpful if you would have provided the scripts to create and populate the dbo.Region and dbo.Person table. Here they are: <br />--CREATE AND POPULATE TABLE dbo.Region<br /><br />CREATE TABLE [dbo].[Region](<br /> [RegionID] [int] NOT NULL,<br /> [Region] [varchar](100) NULL,<br /> [RegionCD] [varchar](100) NULL<br />) ON [PRIMARY]<br />GO<br /><br />INSERT INTO [dbo].[Region]<br /> ([RegionID]<br /> ,[Region]<br /> ,[RegionCD])<br />VALUES<br />(<br />1<br />,N'Asia'<br />,N'AS'<br />)<br />,<br />(<br />2<br />,N'Europe'<br />,N'EU'<br />)<br />,<br />(<br />3<br />,N'North America'<br />,N'NA'<br />)<br /><br />GO<br /><br />--CREATE AND POPULATE TABLE dbo.Person<br /><br />CREATE TABLE [dbo].[Person](<br /> [id] [int] NOT NULL,<br /> [SalesPersonFName] [varchar](50) NULL,<br /> [SalesPersonLName] [varchar](50) NULL,<br /> [RegionID] [int] NULL<br />) ON [PRIMARY]<br />GO<br /><br />INSERT INTO [dbo].[Person]<br /> ([id]<br /> ,[SalesPersonFName]<br /> ,[SalesPersonLName]<br /> ,[RegionID])<br /> VALUES<br /> <br />(<br />1<br />,N'Aamir'<br />,N'Shahzad'<br />,1<br />)<br />,<br />(<br />2<br />,N'M'<br />,N'Raza'<br />,1<br />)<br />,<br />(<br />3<br />,N'Christy'<br />,N'Ladson'<br />,1<br />)<br />,<br />(<br />4<br />,N'John'<br />,N'Rivers'<br />,1<br />)<br />,<br />(<br />5<br />,N'Najaf'<br />,N'Ali'<br />,2<br />)<br />,<br />(<br />6<br />,N'Sukhjeet'<br />,N'Singh'<br />,2<br />)<br />,<br />(<br />7<br />,N'Chirag'<br />,N'Patel'<br />,2<br />)<br />,<br />(<br />8<br />,N'Aleena'<br />,N'Aman'<br />,2<br />)<br />,<br />(<br />9<br />,N'Petra'<br />,N'Henry'<br />,NULL<br />)<br />,<br />(<br />10<br />,N'Rita'<br />,N'Roger'<br />,3<br />)<br />,<br />(<br />11<br />,N'Tamara'<br />,N'Tony'<br />,3<br />)<br /><br />GOAnonymoushttps://www.blogger.com/profile/03873218152457127311noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-42374087866072348732019-05-30T09:49:44.202-07:002019-05-30T09:49:44.202-07:00Very good video about building SQL query within SS...Very good video about building SQL query within SSRSHazem Zayterhttps://www.blogger.com/profile/02640651304916862321noreply@blogger.com