InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:51:24 GMT20http://www.sqlservercentral.com/Forums/Topic1361043-391-1.aspx[quote][b]samtwilliams (9/19/2012)[/b][hr]Can anyoen help with this.Thanks[/quote][code="sql"]DECLARE @variable varchar(100), @command VARCHAR(500)SET @variable = 'E:\MyData\Target\CSV'SET @command = N'Exec dbo.pReport_Update_Unit ''' + @variable + ''''SELECT @command[/code]Wed, 19 Sep 2012 02:08:19 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1361043-391-1.aspxCan anyoen help with this.ThanksWed, 19 Sep 2012 01:46:40 GMTsamtwilliamshttp://www.sqlservercentral.com/Forums/Topic1361043-391-1.aspxI am modifying a script that creates Jobs, is it possible to achieving the following;@command=N'Some Command' + @ANOTHER_VARIABLEI need to tag the contents of another variable to then end of one being set.Can anyone explain how i could achieve this, my real life example is [quote]@command=N'Exec dbo.pReport_Update_Unit ''E:\MyData\Target\CSV''',[/quote]I need the Path including single quotes to be passed in by a variable set further up the script, i expected my script to work or look something like below;e.g.[quote]DECLARE @variable varchar(100)SET @variable = ''E:\MyData\Target\CSV''@command=N'Exec dbo.pReport_Update_Unit '+@variable,[/quote]Tue, 18 Sep 2012 15:42:08 GMTsamtwilliams