Do you need to physically save the file or just to mail it? >>>>>>>>>> Yes I need both physically save the file and also send mail

"save by userId" mean file name for excel and email the file to same userid email in the file.

Thanks for your response.

Thank you so much for all your help I really appreciate it.

try this one...........

DECLARE @product table(ProductID int)

DECLARE @ProductRelation TABLE (FirstProductID int,SecondProductID int)

INSERT INTO @product

SELECT 1

UNION ALL

SELECT 2

UNION ALL

SELECT 3

UNION ALL

SELECT 4

UNION ALL

SELECT 5

UNION ALL

SELECT 6

UNION ALL

SELECT...

create table #T1(ID int, Name varchar(15), Number int)

insert into #T1 values (1, 'Ashley', 12345)

insert into #T1 values (2, 'Bob', 54321)

insert into #T1 values (3, 'Tom', 12345)

Try this one..................................

create table #T2(ID...

try this one............

SELECT

CASE WHEN CAST(substring(Customer.STARTDATE,2,2) AS VARCHAR(2)) = '98' THEN CAST(substring(Customer.STARTDATE, 4, 2) AS VARCHAR(2)) ...

How about this..............

DECLARE @BIRTH_DATE DATETIME, @STPR_START_DATE DATETIME

SET @BIRTH_DATE = '2008-02-29'

SET @STPR_START_DATE = '2013-02-28'

SELECT CASE WHEN YEAR(@STPR_START_DATE)%400 != 0 AND DAY(@STPR_START_DATE)= 28 THEN

DATEDIFF(YEAR, @BIRTH_DATE, @STPR_START_DATE) - CASE WHEN MONTH(@BIRTH_DATE)*100 +...

DECLARE @BIRTH_DATE DATETIME, @STPR_START_DATE DATETIME

SET @BIRTH_DATE = '1975-01-07'

SET @STPR_START_DATE = '2013-01-06'

SELECT DATEDIFF(YEAR, @BIRTH_DATE, @STPR_START_DATE)

Result: 38

SELECT DATEDIFF(YEAR, @BIRTH_DATE, @STPR_START_DATE) - CASE WHEN MONTH(@BIRTH_DATE)*100 + DAY(@BIRTH_DATE) > MONTH(@STPR_START_DATE)*100 + DAY(@STPR_START_DATE) THEN 1...

What is STPRD.STPR_START_DATE? Student Program Start Date

DATEDIFF(YEAR,P.BIRTH_DATE,STPRD.STPR_START_DATE) - CASE WHEN MONTH(P.BIRTH_DATE)*100 + DAY(P.BIRTH_DATE) > MONTH(STPRD.STPR_START_DATE)*100 + DAY(STPRD.STPR_START_DATE) THEN 1 ELSE 0 END AS AGE,

Just follow the sample code, hope it will help you to get start.............................................

declare @index integer

set @index = 1

DECLARE @C_YEAR VARCHAR(4)

SET @C_YEAR = 1995

DECLARE @TEMP_TOTAL...

Try to [Refresh Fields] icon from Design a Query.