have you tried, opening the report viewing the report properties tab and setting the Localization > Language> to en-GB

you could try this

IF (SELECT count(column1,) from dbo.table) >2

BEGIN

SELECT column1,column2

FROM dbo.table

END

ELSE

BEGIN

PRINT 'not enough...

Hi,

The statement

SELECT @MyString = 'foo'

is populating the variable with the value 'foo' to return this value you would then need to select the variable

SELECT @mystring

BOL reference:

in the above SQL code.

• What is the advantage of using the latter method?

This allows the script to be called from the cmd line tool sqlcmd.exe with variables passed in...

you could try this.

SELECT ISNULL(a.Member,a.leader) as [Name]

FROM

(

SELECT leader,NULL as [Member]

FROM #tblLeaders

UNION ALL

SELECT

...

you could change the way you present the parameters in the report instead of having 3 parameters.

Parameter 1 | Parameter 2 | Parameter 3

Some value | some...

This is a great article, thank you.

Just in case this helps anyone else, I've just been testing this suggestion and there were a couple of things which are worth noting;...

the way that the period is stored makes this more troublesome, if the period and year were split out then this would make it easier. I've included a script below...

can you do a string replace on the areas you need to substitue in your parameters e.g

$Instance = "SQLInstance"

$template_Power = $template_Power.Replace("<instanceName></instanceName>","<instanceName>$Instance</instanceName>")

$template_Power > C:\Program Files\Commvault\simpana\Base\template_restXML.xml

what version of SQL / SQL snapin are you using?

I have tested your script on a SQL2012 instance with the following installed

Name ...

you could try using the below adding your server name into the variable

$Server = "SERVERNAME"

Set-Location SQLSERVER:\SQL\$Server\DEFAULT\AvailabilityGroups(get-childitem).Name

you could use the row_number function to do this for you

SELECT ROW_NUMBER() OVER(ORDER BY name) as [cntr], name, country FROM persons WHERE lastname='Jones'

http://msdn.microsoft.com/en-us/library/ms186734.aspx[/b]

one way could be, within the Role(s) set up for users on the database to set the Data Source access to be None?

in the second expression you are missing the =3 section from your IF statement so it is not able to evaluate the outcome, if you add this back in do...

does the following do the job for you, this would work in 2005 but I'm not sure if it would in 2000 or not.

USE DatabaseName

GO

EXEC sp_helpfile

GO

books online link to sp_helpfile