If you check BOL it says somewhere in there that variables used with the EXECUTE statement get reduced to 4000, what you can do it break your code up.

so...

It's hard to say really,

The size of the tables is a factor.

The indexes on the tables are factors.

How many you have is also a factor.

And obviously how they used.

If you...

Almost impossible to help unless we can see some code.

please read the link below for for advice on posting

--DELIMIT FUNCTION

--I've made it inline so it performs better when it's joined to

CREATE FUNCTION [dbo].[fn_StringtoTable]

(

@String NVARCHAR(MAX) ,

@Delimiter CHAR(1)

)

RETURNS TABLE

AS RETURN

(

SELECT SUBSTRING(@String+@Delimiter, n,

CHARINDEX(@Delimiter, @String+@Delimiter, n) -...

Ah I see ok cool I'll look into it

CREATE PROCEDURE p2

(@empid varchar(255) = NULL ,

@dept varchar(255) = NULL,

@age varchar(100) = NULL)

as

SELECT *

from CTS_emp

WHERE (@empid = eno or @empid is null)

AND

(@dept = dept or @dept is null)

AND

(@age =...

thanks I'll let you all know how I do

I hope you not just saying that cause I'm South African 🙂

no seriously, thanks Gail, you made my day, coming from you that is big confidence booster 🙂

wish me luck...

cool thanks.

I've work with SQL for a few years and with regards to the SQL side and UI of SSMS I think I'm pretty knowledgeable.

I've just done some demo questions...

how long would you say it takes to study for this exam say if you can do 2-4 hours a day?

HI Jack.

OK I've check the:

"Default Connection options" for both servers.

The only difference is that the live server has "concat null yeilds null"

When I check the options under the properties for...

thanks everyone for the help. I'm going to move the first issue to a new topic as I don't think it's related to FOR XML PATH('') so the heading is...

Thanks for the answer to the second question 🙂

With regards to the first question.

The space that is being trimmed or not being trimmed is from the Concatenation

', ' part of...

the Collations on both servers and both db's are the same "SQL_Latin1_general_CP1_CI_AS"

🙁

I'll have a look at the collation and get back you .

Thanks

Chris