But the problem here is I dont have an update statement. All the calculations are coming from the source data. If the source data changes then some of the numbers...

I have an other issue with the same stored procedure. I need to get the value for cut date variable from a column in a table. The column is file...

Yup. i got it. Thanks a lot for your time.

I found what the issue is. Now I have a different issue with the same sp. This is my actual code

USE [rlk_test]

GO

/****** Object: StoredProcedure [dbo].[usp_Dashboard] Script...

Thanks so much. It worked. I really appreciate it.

Thanks again Lowell. That worked. It is a very big code and I didn't look for a GO. That was my mistake.

Thanks for your time.

Ohh. Thanks a lot. That worked :).

I have an other issue. This is in my other code. I have declared a variable at the beginning and it works fine...

It is actually work related. They are very rigid about this and they just want to do it in T-SQL and they need to change the date parameters in the...

That is not possible actually.I have to do it in T-SQL :(. The requirement is like that.

Thanks for replying.

My code looks something like this

select

convert(varchar(500),upper(substring(ea2.last_name,1,1))+lower(substring(ea2.last_name,2,499)))

+', '+

convert(varchar(500),upper(substring(ea2.FIRST_NAME,1,1))+lower(substring(ea2.FIRST_NAME,2,499)))

...

The requirement just changed. I want all the column names in my first row. How to get all the column names in the first row and then the data?...Please help....

This is a bit senior position.I never worked on SSIS.I worked as a SQL Server Developer.I have knowledge on all tasks and transformations.I dont know if they ask me to...

Thanks so much.I have some knowledge in Data Modeling and Pretty good knowledge in SSIS.But I never attended a face to face interview.I thought of asking what kind of questions...