Too Many Selects??
I'm having a problem with my code. It works but one part at a time Code:
View Replies
ADVERTISEMENT
How Can I Combine These SELECTs?
Right now i have multiple record sets. Im using the following Select statements:
How can I combine ClaimNbrSQL, ClaimCovSQL, and ClaimantSQL to pull data based on ClaimdraftSQL.
They have different Where_parts because one field is not accounted for in the innerjoins for the the last 3 selects. Anyone know of a better way of doing this? The problem is the queried table is not matched up correctly. For example if there are 2 rows where dft_mirco_ecd_nbr are blank, the ClamiantSQL is off by 2 rows. Code:
Multiple Selects
I need to retrieve data from an Oracle Database. The values to be retrieved are comming divided by commas, every time I try to run the select I�ll get an error.
View Replies View RelatedSearches My Selects
I have this code in a procedure, and it basically will select all the quotes from a certain 'manager' and if the date is more then 7 days, it will archive the quote (by placing a 'Y' in it)
Declare @tempDate varchar(20)
SELECT @tempDate = DATEDIFF(day, SaveDate, getdate())
FROM QuoteFeedBack
WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'
if (@tempDate > 7)
UPDATE QuoteFeedBack Set Archive = 'Y'
WHERE TerritoryManager = @Manager and Archive <> 'Y' and QuoteNumber = '3'
Now this code works, but instead of specifying the QuoteNumber, I want it to scan through all the records for that manager. Basically searching all the quotenumbers that have not been archive yet.
Load Selects From Database
I have some countries, states and cities (three levels) loaded in a database. I have to put them in some form "selects" through a site.
All these data is not probably to change frequently. What would be the best option to load it from? I mean, should I load the data always from the database, even though they are not constantly changing and almost always remain the same? Should I use a XML file to load the data from there?
I don't want to hardcode them, because they appear in more than one form, and it could be a nightmare to update
Retrieve Date From Db And Use Selects To Reflect Day, Month, Year Seperately
I have a form which allows a user to select a 'commencement date' using separate day, month and year drop downs. The date is then submitted to db in DDMMYYYY format(as required).
I now need to allow user to edit this date if they need to. So, I retrieve the date from db as ie. 30101968. I now need to place the first 2 digits (30) into strDay, second 2 digits into strMonth and last 4 into strYears so that I can reflect these values in the their relevant drop downs.
Does anyone know how to 'grab' those specific values?