Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-06-30 : 10:01:20
|
Hi,I have 10 tables. All tables just have 2 columns, Employee Name and Overall Score. The only difference with each table is the where statement in which they are sorted with different date ranges. Also, Employee Names could be 1 or more. Is there a way to create 1 table that is arranged by this:Employee Name Week1 Week2 Week3 Week 4 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
cutiebo2t
Constraint Violating Yak Guru
256 Posts |
Posted - 2008-06-30 : 10:07:20
|
I prefer my above example. Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-30 : 10:38:49
|
quote: Originally posted by cutiebo2t I prefer my above example. Thanks
you didnt reply to waht i asked. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-06-30 : 10:44:27
|
quote: Originally posted by cutiebo2t I prefer my above example. Thanks
OK. I am going to sleep now. Good night KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|