Hi,

Use the following Function....

CREATE FUNCTION fn_getrowsfrmCSVstring(@str varchar(max))

returns @rtn table (id int identity(1,1),value varchar(2000))

As

Begin

Declare

@mstr varchar(max),@i INT,@len INT

SELECT @mstr=@str,@len=LEN(@str),@i=1

...

use ORDER BY CboValuesTranslations.cboValueTranslationName Asc

for 1st Select statement and then use union with 2nd select statement.

or

Write a Select on top of Statements and then sort...

Use the following code...

SET @STRSQL = 'SELECT ''' + REPLACE(@P,',',''' as Col,''') + ''''+' as lst'

OR

SET @STRSQL = 'SELECT ''' + REPLACE(@P,',',''' ,''') + ''''

If you are sure...

Hi,

It should work...

Run the below statement and then insert values..

SET IDENTITY_INSERT IdentityProducts OFF

insert into IdentityProducts(productname,categoryid,unitprice)

values

('shad',1,100)

Use Charindex function...

the following example will bring string from first letter to First Space

SUBSTRING( @STR, 1, CHARINDEX(' ',@str) )

U can loop the string until u reach End of...

Did u check SQL Server2 account has permission on Shared Folder?

Once you generated Script, plz remove the ID ...

Bcoz once u execute the same script on Test , SQL Server of test Environment will generate id.

Why dont you can delete the Profile which you are using for Alerts..

Plz go through the link given below...

http://dilipparakala.blogspot.com/2013/02/forgot-sa-password-and-none-of-user-is.html

CREATE Proc usersbyLocation(@locids varchar(max)=NULL)

AS

BEGIN

Declare @STR varchar(max)

SET @STR='SELECTUserID,

UserForename,

UserSurname,

LocationName

fromtUser JOIN

tLocation on tUser.locationID=tLocation.LocationID

Where tLocation.LocationID in ('+@locids+')'

PRINT @locids

Exec (@str)

END

--Test

--Exec usersbyLocation '1,2,3,4,5,6'

Generate Config files for Dev, Test and Prod environment. [ Values to SSIS package variables like File Paths,Server Name , DB name connections,etc..]

SSIS package is same across all environments. which...

Use snapshot for Reporting purpose.

For every minute, you can use log shipping for Ur requirement..

SUBSTRING ( expression ,start , length )

SELECT SUBSTRING( 'Feb 18 2013 3:35PM', LEN('Feb 18 2013 3:35PM')-7, 6)

For Next Step execution based on result from SP:-

Double click on the Connection Arrow as success and constraint as follows

@SSISVariable==1

Just leave with above condition

if condition not satisfied it...

SELECT cls.Cname as Code,Amnt.Currency,ISNULL(Amnt.Amount,'NA') Amount

FROM CLASS cls FULL JOIN Amount Amnt ON cls.code=Amnt.Code

ORDER BY Amnt.Currency

Try the above one...