Could be due to output size limitation set in the query analyzer.

Note that when you say for xml the output comes as a single column value.

In query analyzer...

Have you seen this?

http://www.sql-server-performance.com/rd_optimizing_sp_recompiles.asp

There is a good article on performance and sp_recompilation.

Just thought it might help..

Thanks Antares686

This looks much better. You are standards man

If col1 is key to table1 and it is in ascending order always then you can use construct similar to following

SELECT a.COL1,(SELECT Sum(b.col1)

...

<<I am still getting records which has event date or note_type_fk =29. >>

Again it looks to me that this is because of logical error.

As per the sql if ref.referral_id is...

Try using subquery instead

UPDATE Table1

SET Table1.NumOfImages = (Select COUNT (Table2.KeywordID)

FROM Table2

WHERE Table2.KeywordID = Table1.KeywordID)

FROM Table1

<<Is this used like sp_executesql Store procedure name(But not working)>>

Please dump the sample code which you are trying to run.

Somebody will be able to help resolve the problem.

Regarding RECOMPILE

--------------------

You...

Query analyzer has many limitations in formating results

- The maximum number of characters allowed are only 8192 per column

(where for xml tries to...

Have a look at the following KB article

http://search.microsoft.com/search/results.aspx?View=msdn&st=a&s=4&c=0&qu=q315159

...

Are you trying to connect to sql*ser using the User's credencials (windows login id)?.

I have IIS and Sql*Server on separate PCs.

I used the following configuration

Anonymous Access unchecked.

...

<<I want to show all the peopleid's that has a clinical calltype>>

But the sql does not reflect the above because of or clause

AND(( cltyp.name= 'Clinical' And ev.event_date is null

AND en.note_type_fk...

AS per BOL documentation (Look for Update described in BOL), the update query where in the there is more than one value for update is categorized as undeterministic and hence...

Sorry for mis-guiding you.

It looks like the syntax ignores Data Source, Initial Catalog etc attributes. It does not even raise error even if there is a error in attribute name.

I...

To use windows authentication you need to provide Trusted_connection and Integrated Security attributes in connection string

Try the following

SELECT a.*

FROM OPENROWSET('SQLOLEDB',

'Data Source=vypar;Trusted_Connection=Yes;Initial Catalog=pubs;Integrated Security=SSPI;',

pubs.dbo.authors) AS...

Do you have latest service pack installed.

Microsoft site says there were few problems with indexed views that resulted from SP1. SP2 has fixes to these.

Have a look at this site