Viewing 7 posts - 1 through 7 (of 7 total)
Thanks! I have been looking for a way to replicate pivots on our old SQL environments and this works quite nicely =)
August 1, 2012 at 4:48 am
Right you are! It was copying the datatype of char (12) from the original table and that was causing the spaces :w00t:
Cheers!
June 17, 2011 at 8:28 am
oh and replacing spaces with full stops:
data1.......data2.data3.....data4...
data1..data2.......data3..................data4...
data1....data2..........data3..data4...
June 17, 2011 at 4:16 am
Yeah, I'm at work so wasn't too sure about sensitive data etc.. I have attempted to desensitise it:
select
identity(int, 1,1) as row_no
, col1
, col2
, col3
into #1
from table20
where col1 between '2010' and...
June 17, 2011 at 4:04 am
Okay I did put uneven spacing but this text editor seems to have formatted it for me!
June 17, 2011 at 3:35 am
That's it yes, I think that actually answers my question though - it was my logic that was wrong!
Will have another go at it. Ta very much
May 27, 2011 at 1:27 am
Viewing 7 posts - 1 through 7 (of 7 total)