Something like this?

DECLARE @varPercentage INT = 50;

INSERT INTO @varTable2 (myColumns)

SELECT TOP (@varPercentage) PERCENT myColumns

FROM @varTable1;

I assume @varTable1 and @varTable2 are table variables?

In contrast with Jeff, I know (quite) a lot about SSIS.

DO NOT USE SSIS FOR THIS.

Use dynamic SQL for this (as Jeff mentioned).

If I would need to do this in...

Personally, I would also choose for the 2012 exams.

Your knowledge will be up to date and ready for the future (SQL Server 2012 will be released soon).

And, if you know...

Easy one to start the week. Thanks!

I know I know 🙂

But when...

Sounds weird when taken out of context 😀

kevaburg (10/19/2013)

---

Personally I would...

Typically you would use Analysis Services as a back-end for PerformancePoint.

Unless there are any Enterprise features of SSAS that you need, I would think standard edition would suffice.

BI edition is...

Created your table, your function and executed the query without a problem.

Which version of SQL Server are you using?

Most of the time you will get the order in which the rows were inserted, unless you use indexes.

It is however not 100% garantueed that you will always get the...

Weird indeed.

Can you post table DDL and some sample data, so that I can replicate the exact same set-up?

Do you execute both statements at the same time?

If yes, try creating the function first and then execute the statement with cross apply.

I took your code and modified it to...

Sorry to hear that.

Let this be an incentive to implement a backup plan.

Restore a backup. I hope you have backups.

vigneshlagoons (10/18/2013)

---

Hi Jony,

I use this query and I get to see duplicate rows showing up for each row.

CREATE PROC Rep

AS

DECLARE @ReportingViews varchar

DECLARE @User varchar

SET @ReportingViews= CASE WHEN EXISTS(SELECT...