Certainly Table 1 (Source Table) = WE Field = [exp] Table 2 (Destination Table) = Request_Header Field = [gsp_log_no] I am trying to update Table...
Would you be so kind as to provide an example.. i.e. an example of what the code should look like.. Thanks
Good morning I was hoping you could assist with the following problem. I am trying to impout/update a table with exp dates from one table into...
Good afternoon Ladies & Gentlemen I have the following ASP Code which seems to have a problem. Could one of you good people please take a look and...
Good morning good people. I have a stored proceedure which sends a confirmation email after collecting information. The stored proceedure sends the...
I just need to update the [ALS] column with the math results. Pharoah35
Bambola Thanks again for your assistance. However when I implement your suggested changes, I get the following error message Server: Msg 141, Level...
Bambola Thanks so much for your responce, However if you could provide an example of a Declare statement (syntax). That would be greatly...
Good morning All I was hoping you could assist me with this issue. I am attempting to update a table with the results of the math at the end of the...
Dear Twan Thank you so very much for your assistance. That really did the trick. Pharoah35
Good morning good people. I am having a bit of a problem with the following T-SQL Syntax. I was hoping that one of you kind Ladies or Gentlemen...
Good morning Thanks for your assistance on this one. However I am not as proficient in SQL as you ladies & gentlemen. Could you be so kind as to...
Hello Thanks again for the assistance.. The [Line Items] table does not have a QOA column. Also when I remove the 's from 'QOA'*([RET-PRC])/100, as...
Hello Thank you so much for your reply, What type of value would you be suggesting. Could you give me an example. 'QOA' = CASE <Value To Comapare>...
Help, I get the following error when trying to execute the following stored proceedure when adding the math at the bottom. Server: Msg 245, Level...
Thanks for your responce. I will provide as much information as I can. Table: SB, Field: Serial# (Contains the Serial Number of the item purshased....
Hello Ladies & Gentlemen I am having some trouble linking data in a view. I was hoping someone could help me. I have the following Tables with the...
Hello Ladies & Gentlemen I was wondering if someone knew of an easy way to remove duplicate entries from a SQL 2000 table? Any assistance would be...
Good morning Ladies & Gents The following Stored Proceedure had been returning results then sudenly stoped. Would you be able to decipher what may...
Hello<br /><br />I am attempting to import data from an Excel spreadsheet into SQL 2000<br />I have 1 spreadsheet with 6 column headings<br /><br...
Separate names with a comma.
