HI There,

What compatability mode are you in 80 or 90?

Thanks

Chris

OK ...

I'm getting confused now, the results change all the time, sometimes the one is faster the sometimes the other one 🙁

Please provide the query?

HI All,

Here is a little test I have just done.

SELECT TOP 1000000 *

FROM CTSTest a

INNER JOIN CTSTest b

ON b.RowNum = a.RowNum

SELECT TOP 1000000 *

FROM CTSTest a,CTSTest b

WHERE b.RowNum =...

Hi Grant,

I don't think you should give up so easily because I posted a few months ago about ON and WHERE clause and the consensus was that it can makea...

Thanks for that.

I'm actually look for more of an Analytical question rather than tech skills questions...

For example giving them puzzles to see what there approach to problem solving is like.

Very strange, it seemed to work for me I think he he he

well good to see you got it working thats the most important thing 🙂

HI,

This is because when you concatenate your variable to your dynmaic string you are adding this:

o'Brain

You want to be adding o''Brain

This means that once you have your variable you should...

DECLARE @vcSearch VARCHAR(100)

DECLARE @vcObjectName VARCHAR(100)

DECLARE @vcObjectType VARCHAR(100)

SELECT

@vcSearch = ''

,@vcObjectName = ''

...

Thanks Jeff 🙂

ooops now I see...

that only works for 2005,

for 2000 you need to use syscomments and thats when Jeffs beware comes into place

HI Jeff,

Sorry you lost me on the column name there?

he he he

no problem.

I've extended it as follows:

DECLARE @vcSearch VARCHAR(100)

DECLARE @vcObjectName VARCHAR(100)

DECLARE @vcObjectType VARCHAR(100)

SELECT

@vcSearch = ''

,@vcObjectName = ''

,@vcObjectType = ''

SELECT DISTINCT

so.Name,

CASE WHEN so.xtype = 'p' THEN 'PROCEDURE'

WHEN...

Hi,

Instead of scripting all you procedures you could use this:

SELECT

o.Name as [Procedure Name],

c.text as [Procedure Text]

FROM sysComments c

INNER JOIN sysObjects o

ON o.Id = c.Id

WHERE

[o].xType = 'P'

AND

c.text LIKE...

HI ,

I guess the first question is, do you have to use dynamic SQL and why?

Secondly why do you not want to use the REPLACE function?

Thanks

Chris