Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Column Names on the fly
Nigel, Thanks for the reply. That is the approach I have taken now. Ian- Jjinks
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Column Names on the fly
I wish to add a new column each month and store data. Explanation of what I would like to do: I have an existing table with the following columns: CustomerNumber Jan-02 Feb-02 . . . Dec-03 I now have the data for Jan-04 (9000 rows) which shows customers who purchased in Jan-04, I wish to add...- Jjinks
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
CognosScript code to return Current Month Value
In a macro I want to get the value of the "Current Month" this is a category in the All Years dimension of a cube (not neccesarily the current month I run the macro). Example: If the cube was run in March 03 then the "Current Month" value would be "Feb/2003"...- Jjinks
- Thread
- Replies: 1
- Forum: Cognos solutions
