mmm that is going to be tricky ...

Could you not just join your other tables to the dynamic query:

--TEST DATA

--**************************************

CREATE TABLE contactinfo

(

person_id INT,

question VARCHAR(1000),

answer VARCHAR(2000)

)

CREATE TABLE personinfo

(

person_id...

Ok I hope I'm understanding what you saying but sorry if I've misunderstood:-)

This code you will see that if you add extra rows with different questions to the table before...

could you post the actual execution plan?

This can be done dynamically without having to change the code.

Could you supply some sample data and what the output should be please 🙂

thanks

Welcome to SSC 🙂

I hope find all the help you need here.

Please could I ask that you read the link in my sig about how to make the best posts,...

I'm sorry but I have to back up Gianluca Sartori here.

He has tried to help the OP at the beginning of the thread with some suggestions on changing the order...

Glad I could help 🙂

DECLARE @Date DATETIME

SET @Date = '2009-05-01 13:43:15'

SELECT REPLACE(CONVERT(varchar(13),@Date,10),'-','')

Check out the CONVERT function in BOL

also depends if you have SET ANSI_WARNINGS ON or not

IS this query only supposed to return the correct phone numbers?

If this is case I think I will work on a short circuit case statement in the where clause...

I've tried using scalar functions that don't access data and Gail is correct that most of the time they perform poorly.

I've tried to break this query down for the mil...

could you show us you SQL ?

I'm sure about why you getting error.

However if there is a certain query or table that you have identified as being a poor perform, throw the code at us and...

I agree, this was a very useful thread and I think alot things have been cleared up 🙂

awesome Gail found us he he he