Blue_boy, Please read the original post in this thread. Thanks for your help but you appear to have misinterpretated my question.

Your question is not very clear, because a) You never specified if the data in TableA has been inserted already and then you want to update the 6th column of TableA [ As you specified that the first 5 fields of TableA will have values supplied from the Stored Proc which indicates that the 6th column will have values from TableB ] with the values from TableB. b) The Table Structure of both the tables are absent. c) What will be the ultimate output [ Any rough sketch will make the picture more clear] d) Whether Table2's column will have predefined value or not. If not whether the values needs to be inserted at runtime in TableB and then it has to be fetched and next to be inserted in TableA? e) Any dependency is lying between the two tables(e.g. Referential Integrity Constraint) However, I am assuming that TableA has the following structure TableA Col1 Col2 Col3 Col4 Col5 Col6 All are Varchar(50) types. N.B.~ Col6 will have the value from TableB TableB RandomCol Again Varchar(50) And my Stored Proc is as under: ALTER PROCEDURE InsertRecordsIntoTableA -- Add the parameters for the stored procedure here ( @VarCol1 AS VARCHAR(50), @VarCol2 AS VARCHAR(50), @VarCol3 AS VARCHAR(50), @VarCol4 AS VARCHAR(50), @VarCol5 AS VARCHAR(50) ) AS BEGIN -- VARIABLE DECLARATION DECLARE @RANDOMCOLUMNVALUES VARCHAR(50) -- STEP 1: DECLARE A CURSOR DECLARE MYRANDOMCURSOR CURSOR FOR SELECT RANDOMCOL FROM TABLEB -- STEP 2: OPEN THE CURSOR OPEN MYRANDOMCURSOR FETCH MYRANDOMCURSOR INTO @RANDOMCOLUMNVALUES -- STEP 3: START THE LOGIC WHILE @@Fetch\_Status = 0 BEGIN -- STEP 4: INSERT THE COMBINED RECORDS INTO TABLE A INSERT INTO TABLEA(COL1,COL2,COL3,COL4,COL5,**COL6**) VALUES(@VarCol1,@VarCol2,@VarCol3,@VarCol4,@VarCol5,**@RANDOMCOLUMNVALUES**) -- STEP 5: GET THE NEXT RECORD FETCH MYRANDOMCURSOR INTO @RANDOMCOLUMNVALUES END --STEP 6: CLOSE THE CURSOR CLOSE MYRANDOMCURSOR --STEP 6: DEALLOCATE THE CURSOR DEALLOCATE MYRANDOMCURSOR END Hope this answers you question. If not, please tell your problem precisely with necessary description It can even be solved without using CURSOR and with a while loop Please be specific about your question so that others can understand properly. :) Niladri B

Hi still someway off what im asking help with but thanks anyway.

I managed to come up with a very similar solution to this but a little simpler since i only need to add a column and populate it, rather than adding new rows. Ill post the details later. Thanks again for all the help everyone!

Your question is not properly visible.please post it properly. himanshu

The block of code inside the IF & ELSE statement should be within BEGIN and END block. Like this: IF @key IS null --address book doesnt exist just so create default BEGIN INSERT INTO tbl_AddressBookMaster ([addMaster_UserId], [addMaster_Title], [addMaster_Description], [addMAster_NoRecipients]) VALUES (@tmp_custID, 'Default', @tmp_Description, 0) SELECT @newSignUpID = SCOPE_IDENTITY() --add addresses to second table INSERT INTO tbl\_AddressBookAddresses (\[adds\_ABMId\], \[adds\_Email\], \[adds\_RecipientForename\], \[adds\_RecipientSurname\]) VALUES (@newSignUpID, @tmp\_Email, @tmp\_Forename, @tmp\_Surname) ** END** ELSE --default already exists **BEGIN** --add addresses to second table INSERT INTO tbl\_AddressBookAddresses (\[adds\_ABMId\], \[adds\_Email\], \[adds\_RecipientForename\], \[adds\_RecipientSurname\]) VALUES (@key, @tmp\_Email, @tmp\_Forename, @tmp\_Surname) **END** Niladri Biswas

Rob, Ive started to develop things a bit more now towards where i need to be going. However im now having trouble with something a bit more complex, please take a look at the new thread: <a href="http://www.codeproject.com/Messages/3078712/Stored-Procedure-with-complex-ish-IF-ELSE.aspx"> http://www.codeproject.com/Messages/3078712/Stored-Procedure-with-complex-ish-IF-ELSE.aspx [^] Thanks!

Hey... you are not running a query. Just check the value of password, send DbNull.Value from here and check in the stored Proc : If @password IS NULL BEGIN -- Update only the UserName END ELSE BEGIN -- UPDATE both username and password. END :rose::rose: Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions Create .NET Templates

Hi, Thanks for the response. I realised i was entering a string rather than a binary. I was simplytesting the procedure in the SQL editor to test it in preparation for use with my website. The coding of the website passes in a hashed string, hence the SQL / procedure set-up. P.s. I did mention in the orginal post that it was an SQL2005 DB. I deleted the post once i realised my foolish mistake. Thanks again.

One question about the data. munklefish wrote: This is calculated by finding rows that overlap (by Datestamp + Duration) as follows: ROW DATESTAMP [START] DATESTAMP + DURATION [END] CHANNEL A 2009-01-02 12:11:27 2009-01-02 12:11:27 + 75 = 2009-01-02 12:12:42 9 B 2009-01-02 12:11:52 2009-01-02 12:11:52 + 20 = 2009-01-02 12:12:12 10 C 2009-01-02 12:11:55 2009-01-02 12:11:55 + 23 = 2009-01-02 12:12:18 6 Because rows B & C are active while row A is still active and the channel ids are unique, then 3 channels are simultaneously active. If the duration of row C was 50 secs (for example) then only 2 channels would be active together (ie. 9 & 10). If row C has duration 50 secs which is 27 seconds more than in the example data, doesn't it still overlap between rows A and B. So why is it interpreted that it's not simultaneously active? The need to optimize rises from a bad design.My articles[^]

You may try like following code snippet //Extract relative URL by chopping www. from begining private string newUrl = System.Text.RegularExpressions.Regex.Replace("www.domain.com/files/test.jpg", "^www\.", String.Empty); //Redirect to new URL Server.Transfer(newUrl); Hope I answered you correctly :) dnpro "Very bad programmer" My Latest Articles RichTextBox Control with Find functionality LogViewer - A Simple Log Listening Utility

Why don't you give a sample of the tables you are trying to pull from and the relevant fields that are in those tables. I'm guessing you are going to have a statemnet that will include a Group By clause and Sum function, but we can't create it for you without specifics. It may end up to be something like this: SELECT User, Valid, SUM(Hours) FROM MyTableName GROUP BY User, Valid

Something like this?: function getData() { var els = document.getElementsByTagName("option"); for(i=0;i<els.length;++i)> // Do what you want with the option element (els[i]) here } } Hope this helps, --Perspx "The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia

munklefish wrote: But sorry to waste your time. No problem

SQL 2005 Although im trying to do the convert on when uploading an Excel sheet to SQL2005 using BulkCopy. See below: protected void Page_Load(object sender, EventArgs e) { // Connection String to Excel Workbook //string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BLAH\qs_upload.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BLAH\qs_upload.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; // Create Connection to Excel Workbook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { OleDbCommand command = new OleDbCommand("Select * FROM [quality_standard$]", connection); //OleDbCommand command = new OleDbCommand("Select qs_Id, qs_Organisation, Convert(varchar,qs_Start,111), qs_End FROM [quality_standard$]", connection); connection.Open(); // Create DbDataReader to Data Worksheet using (OleDbDataReader dr = command.ExecuteReader()) { // SQL Server Connection String string sqlConnectionString = "REMOVED" // Bulk Copy to SQL Server using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString)) { bulkCopy.DestinationTableName = "tbl_QualityStandard"; bulkCopy.WriteToServer(dr); } } } }

try this declare @date as varchar(15) set @date = '2008-04-16' select * from tbl_QualityStandard where qs_Start >= convert(varchar(15),cast(@date as datetime),103) and qs_Start <= convert(varchar(15),(cast(@date as datetime)-365*2),103) I Love T-SQL

This is a great tip for something else I was working on. Thanks for posting it digimanus. digimanus wrote: creat an order object class. fill the class for each order as soon as one order is filled add the order to an ArrayList. In the session object you can objects. So you can add an ArrayList to 1 session0bject. In the second page cast that session object to an ArrayList and you can reach your data.

Before you attempt resolving this problem on hand, seriously consider a re-design of your database query approach. Your application is vulnerable for SQL Injection attacks. Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson