Viewing 4 posts - 4,816 through 4,820 (of 4,820 total)
My thought process says when there's no map, make one. Since you appear to be looking at dealing with the Front End, is there any chance you can...
May 29, 2008 at 2:03 pm
There is a way to do this without sorting. I decided to try using REPLACE and ISNULL and an intermediate CTE, with a source table that has all...
May 29, 2008 at 12:23 pm
If it helps any, the PIVOT operator uses an aggregate function to consolidate information from a given column, based on possible values of a 2nd column. For character data,...
May 29, 2008 at 9:02 am
Have you considered the PIVOT operator? SQL 2005 provides this rather convenient method to convert rows to columns (and UNPIVOT to do the reverse). As an...
May 27, 2008 at 7:02 am
Viewing 4 posts - 4,816 through 4,820 (of 4,820 total)