You could use a function, built with PATINDEX

Create Function [dbo].[RemoveAlphaCharacters](@Temp VarChar(1000))

Returns VarChar(1000)

AS

Begin

While PatIndex('%[a-z]%', @Temp) > 0

Set @Temp =...

When you say author, do you mean the person who created the report in BIDS / Report Builder, or the person who deployed it to the server?

Also when you say...

Excel 2010 support 1048576 rows and 16384 columns per work sheet.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

SSRS 2012 uses the 2007-2010 XML rendering engine now for Excel so will export this amount of rows and columns.

If...

You cannot mark your topics as answered on this site.

The solution I gave is a simple cross tab query which is detailed in the links I referenced by Jeff from...

Is the query used to populate the the available / default values for the @Res parameter?

If not please provide the query which is used to populate @Res.

mssqlsrv (9/2/2012)

---

HI,

How can I change collation of all columns in sql 2008.

I am getting error for keys.

Is there any script to drop keys and change collation and then again generate...

deepzzzz (9/3/2012)

---

While Creating database you can specify the collation type you want.

By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS

If you are getting error, you can specify as column name...

Sorry I should of said MCSE BI, 457 and 458 to upgrade to MCSA and then 460 to get MCSE BI.

Then you should just be able to do exam 459...

You could just go down the upgrade route then, doing exams 457 458 to get MCSA and then 460 to get MCSE Data Platform Business Intelligence.

What are your current certifications?

And from what I remember, it doesn't matter which order you sit the exams in, but if you do it in the order you are detailing,...

your expected outcome is not based on the sample data you have provided

SELECT

EnrolmentId,

StudentId,

Name,

MAX(CASE WHEN FeeTypeID = 1 THEN Amount END) AS AdmissionAmount,

MAX(CASE WHEN FeeTypeID = 2 THEN Amount END) AS...

and what is the required output based on this sample data

Take a look at synonyms, they should do what you need.

Based off your sample data the below will union both tables together.

select

fo.path,

fo.foldername,

CONVERT(VARCHAR,fo.foldersize) AS FolderSize,

'' AS FileName,

'' AS FileSize

FROM

@Folders fo

union

select

fi.path,

'',

'',

fi.Filename,

CONVERT(VARCHAR,fi.FileSize)

from

@Files fi

order by 1,4

are you setting the force disconnect of users on the restore to ensure that the database can be restored, otherwise if a user is connected to the database SQL cannot...