Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amritversa
Starting Member
4 Posts |
 Posted - 2006-01-04 : 00:56:36
|
| there is a prblem with data in pivoting the table.problem is like this--there is some data 'xy' and some data 'xy '. when i m giving 'xy' as a pivot key value it doesent recognise 'xy ' and viseversa..i can't reduce the size of the datatype coz there is some data of diffrent size as 'abcd'.this data is loaded from excel sheet to sql sever table.wht can i do for this problem.is there any method to truncate the indivisual data, i m using nvarchar datatype for this. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-01-04 : 06:43:30
|
| Post your sample code, a couple of rows of source data and an example of the resultset you seek. |
 |
|
|
amritversa
Starting Member
4 Posts |
Posted - 2006-01-05 : 00:04:25
|
| this is related to pivoting task in the analysis servises.this is with respect to place where i have to give the pivot key value.i m writing this code.. for input of the pivoting option..select dept , role,count(*) as count1from master where Date=(select datefield from dateinfo where dayname='Today')and role in ('ABCD' , 'XY', 'YZ', 'ZA')group by dept, roleorder by dept.i m pivoting the table count1 on the basis of role... |
|
|
|
|
|
|
related to pivoting