Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
stevenbe1
Starting Member
2 Posts |
Posted - 2010-12-16 : 10:34:26
|
Using an ssis package I am passing a date variable %TIME_DIM% which has a format of 2010.dec. I want to use this variable as part of a sql where clause.I am looking for a way to convert the 2010.dec to 201012%. The where clause s/b 'where time like %TIME_DIM%' Can anyone suggest a way to accomplish this? |
|
|
|
|