SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Look up tables to generate a report!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Kingdom
1 Posts

Posted - 11/30/2012 :  06:32:06  Show Profile  Reply with Quote
Hi Gurus,

I'am quite new to SQL but keep using it :)

I need some help with generating a report from few tables as in the following example. It would be helpful if anyone can explain me how to do this job:

Table 1:
Quote Color Grade
1111 001 111
1112 002 222
1113 003 333
1114 004 444
1115 005 555

Table 2:
Id Color
001 Green
002 Violet
003 Red
004 Black
005 Orange

Table 3:
ID Grade
111 Grade A
222 Grade B
333 Grade C
444 Grade D
555 Grade E

Quote Color Grade
1111 Green Grade A
1112 Violet Grade B
1113 Red Grade C
1114 Black Grade D
1115 Orange Grade E

I'll be using this on a mass scale for about 20 to 30 tables :) in a VBA module.

Thanks in advance,


Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 11/30/2012 :  06:57:38  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
Create a stored procedure to deliver the data to the report.
create proc s_rpt
select t1.Quote, t2.Color, t3.Grade
from Table1 t1
join Table2 t2 on t2.ID = t1.Color
join Table3 t3 on t3.ID = t1.Grade
order by t1.Quote

(You know you've mispelt Colour? :) )

Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000