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!
-
MSSQL syntax
this is a sql syntax from microsoft access... TRANSFORM Avg(dbo_tbl_000_ClassPrice_CSL.PriceAmount) AS AvgOfPriceAmount SELECT dbo_tbl_000_ClassPrice_CSL.ClassName FROM dbo_tbl_000_ClassPrice_CSL GROUP BY dbo_tbl_000_ClassPrice_CSL.ClassName PIVOT Format([EffectiveDate],"Short Date"); can...- addrianne
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
help in creating custumized crosstab using vb9 CR
or just hide it instead..:(- addrianne
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
help in creating custumized crosstab using vb9 CR
Please help me with this.. CLASSNAME Effective Date Price Deck A Economy 2/28/2009 446.75 Tourist 2/28/2009 705.00 Deck A Economy 3/3/2009 350.00 Tourist 3/3/2009 850.00 i used the wizard in crystal...- addrianne
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
