YOU (not us) need to debug your code - this means going step by step through it and seeing if each step has the data you are expecting.

not going to...

• This reply was modified 3 years, 2 months ago by frederico_fonseca.

you would need to use a different tool for it (DBCC SHOWCONTIG ) - but how many do you have with compat 80? and can't you change them to compat...

dup post - see reply on https://www.sqlservercentral.com/forums/topic/code-correction-4#post-4175569

your issue is because you have databases on that 2008R2 instance that are compatibility level 80 (sql 2000)  where dm_db_index_physical_stats didn't exist.

if you wish to confirm change your code as...

have you even bothered reading the link that ratbak provided? your reply clearly indicates you didn't.

you are using a software for which thee vendor has a forum of its own - their forum is where you should be asking this question, not here, neither on...

something like this:

waitfor delay '00:00:03' --pause for 3 seconds GO 3 -- run 3 times

this will result in 3 separate result pane.  i'd like to keep it in the...

• This reply was modified 3 years, 2 months ago by frederico_fonseca.

you can - combination of your query, plus a waitfor, plus a GO xxxx where xxx is the number of times you wish the queries before it to execute

or a...

• This reply was modified 3 years, 2 months ago by frederico_fonseca.

correct way to check dates is to use the date - FORMAT turns them to strings so only one format would allow for that compare (YYYY-MM-DD)

so use the following construct...

I have a big sql script that i am doing a flatfile destination on to create a csv.  I have case statements and about 4 columns that I have...

on the original query the left outer join was being used

  DELETE R FROM #RESULTS_DEM AS R 
    INNER JOIN dbo.Dem_trans AS DEM
ON...

whoever decides they do not wish to use the XML PATH functionality should be fired -...

you don't delete it - just put your solution here for others to see in case they have the same issue.

and the query supplied can likely be replaced with a single one

insert into DBO.StockData
select t.SYMBOL
     , t.TRADE_DATE
     , t.VALUE1
...

thank you for this.

I am a rookie so excuse the ignorance.  I need to re-calculate the index after a certain calculation is done.   I thought that using the...