L TRIM removes all the white space from the starting of the pattern and R TRIM removes all the white space at the end of the pattern.:-)

CREATE TABLE Emp(

EmpName VARCHAR(9),

Age INT,

MaritalStatus char(1))

INSERT INTO Emp VALUES ('Abhinav',40,'S')

INSERT INTO Emp VALUES ('Dhvani',20,'M')

INSERT INTO Emp VALUES ('Nehal',20,'M')

INSERT INTO Emp VALUES ('Sunil',95,'M')

INSERT INTO Emp VALUES ('Suvrendu',40,'M')

INSERT INTO Emp VALUES ('Bill',11,'S')

INSERT...

create table marks

(

student name nvar char(50),

marks int

)

Insert into marks(student name,marks) values('ma ha',67)

Insert into marks(student name,marks) values('tuba',78)

Insert into marks(student name,marks) values('Deena',70)

Insert into marks(student name,marks) values('Oriya',90)

Insert into marks(student name,marks) values('saga',98)

select * from...

sorry,I cant understand your doubt but i think this may provide solution to you.

Declare @product ID int

Declare @product Type char(10)

Declare @product Rank int

Declare cc...

That not possible ,we can call function with in the store procedure.

Thats not possible to call store procedure inside the function,we can call function with in the store procedure

Cross apply is very difficult than join ...i think there is no data available depends upon your requirement give the table of contents connected with this query.

Ur code is unable to understand specify your doubt and use clear SQL query.