Viewing 9 posts - 16 through 24 (of 24 total)
Can you please check your data types. Are those valid ones?
May 26, 2010 at 7:46 am
Just to provide the Input..
CREATE TABLE Employees
(
Emp_ID int Not Null,
Emp_Status Char(2) NULL,
Emp_Identity Varchar(5) NULL
)
INSERT INTO Employees
Select '121210','A','A321' UNION ALL
Select '121211','L','B321'
SELECT...
May 25, 2010 at 8:03 pm
This issue is not on client side. i personally working on some data and came up with this issue. Thanks for your info abt functions, i will get rid of...
May 19, 2010 at 6:10 am
You are right jeff, But I had very few number of records(Around 3000). so i am using the functions.
Sahasam...
May 17, 2010 at 7:22 am
Sorry Guys, this is already posted in TSQL 2008 Forums.I am unable to delete this guys, so never mind bt this post..Please Ignore.
May 17, 2010 at 7:08 am
Matt, the one you mentioned is a very simplified Format. Matt, From your solution i known the usage of partition by Operation. Thank you.
May 17, 2010 at 6:49 am
I did this in some other way.
I created 3 functions and used those 3 funcions in the procedure directly by passing a parameter.
First Function Which represents first column, i retrieved...
May 17, 2010 at 6:44 am
This is the beginner book i followed, I improved my skills a lot in SSIS.
Microsft SQL Server 2005 Integration Services step by step by Paul Turkey, Joe Kasprzak, Scott...
April 29, 2010 at 1:15 pm
Viewing 9 posts - 16 through 24 (of 24 total)