Käynnissä

SQL Query Help

I am populating a radiobuttonlist control for a conference registration. The client has now asked that a max number criteria be added. (so it is either disabled or delisted from the radiobuttonlist control once a max number for each session is reached).

Currently, I am building the control using the query:

SELECT '<a href=javascript:Start(''[url removed, login to view]' + CAST([url removed, login to view] AS NVARCHAR) + ''')>' + [url removed, login to view] + '</a> - <font color=' + [url removed, login to view] + '>' + [url removed, login to view] + '</font>' AS SessionName, [url removed, login to view], [url removed, login to view]

FROM Sessions INNER JOIN Themes ON [url removed, login to view] = [url removed, login to view] INNER JOIN SessionBlocks ON [url removed, login to view] = [url removed, login to view] WHERE ([url removed, login to view] = 2) ORDER BY [url removed, login to view], Title,SessionName

- the sessionname above is just me making it a hyperling to a popup details page.

at this point, the tables as used above are:

Sessions

Themes

SessionBlocks

New to the database is now a table called Rooms which has a primary key of RoomNumber and is a foreign key in the Sessions table field called Room. [url removed, login to view] has the max number of registrants allowed.

The field to count for each record is in a table called 00_MainRegistration the [url removed, login to view] is stored in a field such as FridayAM.

Basically, it would have to count the number of times that the [url removed, login to view] is in the FridayAM field and compare it to the [url removed, login to view] figure.

Hope that makes sense but can clarify further if needed.

Taidot: .NET, SQL

Näytä lisää: penhall, n query, max.sense, key criteria, on sql, SQL Query, query table, clarify, Cast, sql javascript, javascript net sql, foreign key, javascript cast, help using, sql select select, query page, sql select order, sql select, max help, using session aspx, query query, color control, SQL stored, sql query help, query javascript select

Tietoa työnantajasta:
( 7 arvostelua ) Whitehorse, Canada

Projektin tunnus: #487741

Myönnetty käyttäjälle:

cyberiarob

I would have absolutely no problem providing the query that you need. I have a lot of experience writing very complex SQL queries. I am in the Central time zone, so the minimal time difference would enable any necessa Lisää

30 $ USD 1 päivässä
(1 arvostelu)
1.0

2 freelancers are bidding on average $30 for this job

brittogladez

Please Read PM

30 $ USD 1 päivässä
(1 arvostelu)
1.2