I'd put it in function and then pass the function the three date values

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufn_MaxDate] (@DateA DATETIME, @DateB DATETIME, @DateC DATETIME)

RETURNS DATETIME

BEGIN

DECLARE @ReturnDate DATETIME,

BEGIN

...

in ASP the data is returned in a recordset, and then we code against that recordset. Again, I'm not sure how JSP uses data returned from the database. ...

Actually I would need to see the structure of all of the tables used in that query, I see you are using an outer join when setting the meal choice....

What is the structure of your ses table that you are pulling the meal choice from?

Agree with Lynn, the referential integrity is needed to provide the solution, without it you would end up

with a messy cartesian product. Now once you have set up the...

IN that case I would make my checkboxes generic. That being done, you can then pass the

needed information in the same type of case statement after setting the...

The error in your code is that you are not limiting the code for the meal choice table to only the checked one. This can be a good proc...

Sharma

Unfortunately, I don't know JSP, I'm a ASP/.NET developer. However, I did do a google search and the following url appeared to have very good information on working with...

as stated above, views are used to simplify complex queries that are used repeatedly. I use views for report writers who have difficulty with the join syntax and of...

CREATE PROCEDURE usp_ReturnRecords

AS

BEGIN

SELECT

id,

name,

address,

phoneno,

email,

salary,

FROM

contacts

END

Then when calling the stored proc use:

EXEC usp_ReturnRecords

You have to turn identity insert on and off as each table is loaded. Of course that will slow you down because you will only be able to load...

SSIS is probably the most simple way. If the field names are not the same, simply click on the edit mappings button when you get to that screen and...

Please ensure you check with management on data recovery and acceptable loss. If all data is bulk loaded from another source then you should use bulk logged or simple...

Check with your network admin. 36 hours for 50gigs seams very slow. Of course it is all bandwidth dependent.

The more switches between server a and...

Anjon

Everything you need to do is in the script at this link

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/

In the backup retention table, you set the time period increment and the number of backups you want to...