Execution can be very helpful. But without plan, I came up with the following code. You can try;

-- Get the SamplesPartner Meta Table Ids

DECLARE @specimenMetaTableSqlId SMALLINT

DECLARE @specimenMetaTableIncId INT

SELECT @specimenMetaTableSqlId...

Hello,

I am learning PowerPivot so It might be a stupid question. Sorry for that in advance. My question is why do we have to install Analysis Services for using PowerPivot...

The script seems to be embeded with special characters. Please remove tab before + name + in the query right after --Data approach comment and then execute.

-- Data approach

Select @vCols...

@adudley

you can find fnSplit on the net. just google it and you will find the code for it.

@bhatta

This is just an approach of performing a task...

Check this...

http://www.mssqltips.com/tip.asp?tip=1441

Really :w00t:? And how "messed up"?

WHILE loop is there by mistake (was testing something before posting it). Please ignore it.

You are using user defined data types.

I changed the table structure and then inserted the records. Nothing seem to be wrong. Can you please give some details;

CREATE TABLE dbo.LU_OVERVIEW_CONTROL_PAGE

...

Interesting and superb testing. I would definitely check the XML approach on monday morning. Its weekend now.:-)

Thanks.

plz check my last posted query. Its working fine.

Thanks for pointing Doug. Try this;

Declare @vTable Table(id int,val varchar(Max))

Insert into @vTable Values (1,'Atif1 SS')

Insert into @vTable Values (2,'Asif2 SS')

;with wcte (id,val,strpos) as

(

Select id,substring(val,0,case when charindex(' ',val,0) = 0...

Dear paul_ramster,

First of all, thanks for the new version of the query and sharing your knowledge. That is why we (at least I visit this website.)

The point raised by...

Nice one...

Nice one.

As a DB guy, I think both of them are important. As a client, its...