Viewing 15 posts - 5,311 through 5,325 (of 6,395 total)
take a look for a tool called RSScriptor that will do the job for you
April 5, 2012 at 4:09 am
best way is to restore the backup to a new database name and then copy the data from the backup to the live DB, you wont be able to use...
April 5, 2012 at 3:43 am
couple of things and sorry if you cant do this either but you only detail no changes to the current databases.
could you not create a secondary version of the DB,...
April 5, 2012 at 1:57 am
what happens if you tell it that the remote path is not a variable and then set the expression on the remotepath property of the actual FTP task
April 4, 2012 at 7:38 am
Daniel Bowlin (4/4/2012)
anthony.green (4/4/2012)
ChrisM@Work (4/3/2012)
anthony.green (4/3/2012)
4DayWeek 😀FollowedByAnother :-))
2DayWeekNextWeek 🙂
Wow, that's almost not worth it. Nice.
Very true, but I wouldnt know what to do with myself for the two days...
April 4, 2012 at 7:03 am
yeah, looks right, just make sure you wrap stings with " " then hit evaluate expression to see if it does what you want it to do
"/pub/Cell_Availability/" + (DT_WSTR, 4)...
April 4, 2012 at 6:56 am
no it wont work as you are not adding in the "-" inbetween the date parts
the below will only give you /pub/Cell_Availability/20120404
April 4, 2012 at 6:41 am
ChrisM@Work (4/3/2012)
anthony.green (4/3/2012)
4DayWeek 😀FollowedByAnother :-))
2DayWeekNextWeek 🙂
April 4, 2012 at 6:03 am
Thanks for the clarification Gail, much appreciated as always
April 4, 2012 at 5:13 am
Sorry Gail, maybe my terminology is a bit off.
Please correct me if I'm wrong, but when there is a column which is required in the result set which is not...
April 4, 2012 at 5:07 am
wrap the dates in a convert/cast function using a format code
eg
CONVERT(DATE,MAX(DATE),103)
CAST(MAX(DATE),DATE,103)
April 4, 2012 at 5:03 am
Might need a bit of work to get it to how you want it, but the basis is the same
DECLARE @sql NVARCHAR(MAX)
SELECT @sql = REPLACE(
CAST(
(
SELECT 'USE ' + QUOTENAME(name) +';'...
April 4, 2012 at 4:53 am
you will need business intelligence development studio installing on your machine to develop the RDL files, this can be installed via the SQL media if not already done so
April 4, 2012 at 4:49 am
Viewing 15 posts - 5,311 through 5,325 (of 6,395 total)