|
|
|
Valued Member
 
Group: General Forum Members
Last Login: Yesterday @ 11:52 PM
Points: 59,
Visits: 391
|
|
Hi All,
I have the foll issue. Please help me in resolving this as I have to complete the task by today....
create table candidate(CandidateID Int primary Key, CandidateName Varchar(50))
Go
Create table submittal(SubmittalID int, CandidateID Int, BillRate Money, PayRate Money, Notes Varchar(4000) Null, Resume Image, Primary key(SubmittalID, CandidateID))
Go
Insert Candidate Values (1, 'Ravi')
Insert Candidate Values (2, 'Ram')
Insert Candidate Values (3, 'Ragu')
Insert Candidate Values (4, 'Ganesh')
Insert Candidate Values (5, 'Aravind')
Insert Candidate Values (6, 'Kumar')
Go
Insert Submittal Values (1,1,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Insert Submittal Values (2,2,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Insert Submittal Values (3,4,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Insert Submittal Values (4,5,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Insert Submittal Values (5,6,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Insert Submittal Values (6,3,100,80,'Submitted on Oct 2.......', 0xD0CF11E0A1B11AE100000000)
Go
I have a proc that searches for all the resumes posted for a specified number of days....
As the resumes are stored in IMAGE field, it takes around 2 hrs for executing.
I also tested without the IMAGE field, it took not even a minute....
Any ideas, greatly appreciated....
Buddy
Priya
|
|
|
|
