the only problem with your query is that there are lot more emps in employee table than in userlog table. So if we do inner join on userlog we are...

create table employee(employee_no int identity,company_id int,empl_first varchar(50), empl_last varchar(50))

create table company(company_id int identity,company_name varchar(50), Reference_id varchar(50),Employee_count int)

create table Leave (leave_no int identity, Requestdate datetime, company_id int)

create table userlog(employee_no int, uname...

Thanks David and John... it makes lot of sense to me now.... thanks for the help.. things look so much clear now....

David --> your query was good.

John --> your...

John, Great work. Its working like a charm. Only confusion at this point is that the last statement whether I do

order by max(cont_section_id) or order by min(cont_section_id), I get...

I did the steps you had mentioned and fired these queries :

select * from dbo.TestPerformance

WHERE convert(datetime,CharDate) >= convert(datetime,getdate())

gave 2992 records in about 5 secs in sql server 2005

select *...

Yeah, I guess I will stick to date comparision. Here is what I have done :

convert(datetime,task_date) >= convert(datetime,getdate()).

lets say task_date is datetime type column and I use select convert(varchar(10),task_date,101) as...

Thanks everyone. The reason I want decimal with 2 decimal places is because its a standard for all of our clients & we use it to import the data in...

bcp testjan11..ws_initiate_session format -c

-f C:\Documents and Settings\amohammed\My Documents\ajas.fmt -T

I remember it asks for field termination and i used the tab option. So my .fmt file is like this......

thanks a lot everyone... can we say money(10,2)... I really want only 2 decimal places.... will this work???? i know i should read manual as someone pointed out but trust...

ok, I think ltrim(rtrim(colvalue)) can remove spaces but cannot remove empty values that just have tabs or even a value which has a tab on the left or right side...

The column represents some amount like deduction amount (insurance appl). The values we expect in that column should be in 9999999.99 format. I am inclined towards decimal(10,2). Anyone has any...

ok... what would you suggest. Shall I change the datatype for the column from float to decimal(8,2) or shall I alter the float to have something like this float(8,2)???

What do...

NO. Are you saying the record is saved as 33.87 but when its displayed, sql server shows approximate number data i.e 33.8699999???

I am so lost... plz clarify anyone..........

Hi,

Ram your query is almost like mine except that you have used functions.... As for Lowell, I am not sure if I want to do Full-Text Search....

Yeah but the whole idea is to store the 2 col's returned by SELECT in the variables... i guess this will not work. I should look in the direction of...