Thanks alot!

David, when you said 'Update each column one at a time', does that mean that I will have to do a loop?

Well, yes, I don't know if I have any other choice than to do this.

David, do you remember that you helped me with the sql statement with the date columns...

Thanks, I know what you guys are talking about.

Thank you.

Users will be added by granting SQL Server logins access to the database.

Is it possible for  you to show me an example of the built-in functionality for SQL Server in...

Yup, I am trying to implement my own application authentication. Once the users are authenticated, they will get to access the application.

I will be having intranet and internet users. which...

Thanks, David! You are a life-saver!

David,

Thanks so much! I hope I am not asking for too much by asking you to point me in the right direction if...

Well, that is one way to do it.

But, I was hoping that this can be done in stored procedure.

Hello Jesper,

Simply put, User need to give 2 inputs:

1)View Mode (I'll start with Weekly)

2) StartDate as 04/08/2005 (dd/mm/yyyy)

I am hoping the stored procedure will create a temp table which will...

Ok, I don't really have the exact table definition but, I suspect that it will be something similar to this.

TABLE JobHeader (

 [JobNo] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [JobDesc] [varchar]...

Hi David,

Thanks, I will try to see if this will work for me.

Try this

DECLARE @Mode varchar(10), @StartDate datetime, @sql varchar(4000)

SET...

Hi Jesper,

I want to be able to pass the data retrieved to .Net which will (hopefully) display the results somewhat like the following.

Hi Jamie,

What's dynamic SQL? Is it possible if you can show me an example? I am fine with using square brackets in my column name.

Thanks.