MSSQL2011
Tuesday, December 14, 2010
IS - Expressions
@[User::ExceCreateTolPath]
+@[User::ClientName]+_NewPlace_+((DT_WSTR
, 4) YEAR( Getdate() ) +Right("0"+ (DT_WSTR, 2) MONTH( Getdate() ) ,2) +Right("0"+ (DT_WSTR, 2) DAY( Getdate() ) ,2) )+"_"+ @[User::SchoolOPEID] +".xls"
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment