Microsoft SQL Server Forum

I am a beginner and trying to get the following results: All records from page0 where records on page4 do not have a Role of 'DCA Specialist'. Page0 is the one record table and Page4 is the table with the many records. The issue is: I getting records that have 'DCA Specialist' on page4. The Serial Number in Page0 joins to the...

I have the following example, which is reaching the max recursion. Declare @example table (RowID varchar(20), RelID varchar(20)) Insert Into @example Select 'Rec1', 'Rec5' Insert Into @example Select 'Rec1', 'Rec6' Insert Into @example Select 'Rec5', 'Rec1' Insert Into @example Select 'Rec5', 'Rec2' Insert Into @example Select 'Rec6',...

In the last few days I have developed a small database within SQL Server, with the aim of improving my knowledge. For now, I need to create a view (for the analytics team), to which the following data should be reported in the view. ➤ Order ID ➤ Date and time of order creation ➤ Customer's first and last name ➤ Delivery date ➤ Item code...