Viewing 13 posts - 46 through 58 (of 58 total)
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...
December 15, 2011 at 2:00 pm
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...
December 15, 2011 at 9:39 am
Yup. i got it. Thanks a lot for your time.
December 15, 2011 at 9:08 am
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...
December 15, 2011 at 8:56 am
Thanks so much. It worked. I really appreciate it.
December 14, 2011 at 12:58 pm
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.
December 7, 2011 at 12:11 pm
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...
December 7, 2011 at 11:32 am
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...
December 7, 2011 at 11:10 am
That is not possible actually.I have to do it in T-SQL :(. The requirement is like that.
December 7, 2011 at 10:36 am
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)))
...
December 7, 2011 at 10:35 am
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....
December 7, 2011 at 9:42 am
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...
October 27, 2011 at 9:29 pm
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...
October 27, 2011 at 9:18 pm
Viewing 13 posts - 46 through 58 (of 58 total)