Time Management App

  • Thread starter Thread starter Stuart Ferguson
  • Start date Start date
S

Stuart Ferguson

I am currently writing a Time Management application which requires that
each weekday be split into morning, afternoon and evening (each with a
start and end time), i need to store these into a SQL Server database,
at the moment I am using a Stored Procedure to insert the data however
this requires 48 paramaters to send each individual start and end time
for each day and was wondering if there was a better way for this to be
done.
 
Stuart Ferguson said:
I am currently writing a Time Management application which requires that
each weekday be split into morning, afternoon and evening (each with a
start and end time), i need to store these into a SQL Server database,
at the moment I am using a Stored Procedure to insert the data however
this requires 48 paramaters to send each individual start and end time
for each day and was wondering if there was a better way for this to be
done.
Click to expand...

I am assuming you have 48 columns in your table. You should probably
normalize the table. What are the columns you currently have so we can give
you some suggestions?

SP
 
Stuart Ferguson said:
I am currently writing a Time Management application which requires that
each weekday be split into morning, afternoon and evening (each with a
start and end time), i need to store these into a SQL Server database,
at the moment I am using a Stored Procedure to insert the data however
this requires 48 paramaters to send each individual start and end time
for each day and was wondering if there was a better way for this to be
done.
Click to expand...

http://rosca.net/writing/articles/xml_parameters.asp
 
Back
Top