I gang

SQL Query Help Needed

I need help on approaching a report I have to develop.

I have two tables.

One is registration for a conference.

- fields of concern are Sess1, Sess2, Sess3, Sess4, Sess5 and Sess6

Second is a list of sessions.

- two main fields ID and SessionName

My goal here is to design a query that would:

- Read each individual unique ID from Sessions Table then report the Session Name and Count it appears for each from the Registration Table (the ID could appear in any of Sess1 thru Sess6 fields; but only one of them)

Should be simple enough but admittedly I am not a SQL guru and was hoping someone could help me out and save me a bunch of headaches trying to figure this out.

Thanks

Færdigheder: .NET, ASP, Databehandling

Se mere: penhall, n query, need sql help, help guru, guru report, guru net my, guru help, asp. net guru, asp net guru, getafreelancer message sql query help needed, on sql, sql, SQL Query, sql guru, sql c, simple query, report sql, query table, help name, help me name, report needed, design simple sql, table report design, save report, net guru

Om arbejdsgiveren:
( 7 bedømmelser ) Whitehorse, Canada

Projekt-ID: #300714

Tildelt til:

YankoNik

Dear Sir, We would love very much to be given the opportunity to work with you on this project. We are expert. We can do this according your requirements. Please see PMB.

$30 USD in 0 dage
(1 bedømmelse)
1.0

12 freelancere byder i gennemsnit $38 for dette job

sikandermandal

Please See PMB.

$100 USD in 0 dage
(22 bedømmelser)
5.4
pritidiy

Hello, I am very interesting with your project. I am experience in MsSQL Database, I am a Programmer using MSSQL Server as Database.I usually developed a complex report s using query or Store procedure. Please send Mere

$30 USD in 0 dage
(0 bedømmelser)
0.0
patingsadagat

let us start the project.

$30 USD in 0 dage
(0 bedømmelser)
0.0
dnuske

Hello, I work for [url removed, login to view] I can help you, just accept my offer and then I start. Thanks in advance! Daniel Nuske [url removed, login to view]

$50 USD på 1 dag
(0 bedømmelser)
0.0
mtd429

Hi, Currently, I am involving in developing real estate project relating to MS SQL Server 2005. So I have a lot experience in writing complex queries to generate customised reports. Therefore your project is good matc Mere

$30 USD på 1 dag
(0 bedømmelser)
0.0
dungbq

Hi Penhall! Can send to me details of 2 tables? And,what do you use them for ?? I have seen a proplem in your table's design. If possible, i'll help you to redesign them.

$30 USD in 0 dage
(0 bedømmelser)
0.0
chint1000

Would be delievering according to your requirements.

$30 USD in 0 dage
(0 bedømmelser)
0.0
wangxdinet

I am an IT Engieer in China. I am family with windows, Linux and network management. I have used .NET from 2002 and MSSQL from 2000.

$35 USD på 1 dag
(0 bedømmelser)
2.1
sorajeev

Hi, I can help you on your task. See your PM. Thanx!

$30 USD in 0 dage
(0 bedømmelser)
0.0
EmailSolutions

Please check PMB for details, Thank you

$30 USD in 0 dage
(0 bedømmelser)
0.0
avi4friend

I dont think for this small query, someone should charge :) you can easily get solution on google or let me know i can send it for you. thanks

$30 USD på 1 dag
(0 bedømmelser)
0.0