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 2 years, 5 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 2 years, 5 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...

just created a login and tried it. It gave some good layman explaination. Once thing, I wanted to ask,...

what else is the code doing e.g. the full code of sp_crm_lead_account_matching?

Your call has other parameters and you are using output variables that are not used on the query you...

without even knowing which CRM vendor this is I would suggest the following

• change CTFT to 50 - default of 5 is normally way wrong.
• speak with the vendor and...

will this give you what you need? https://www.sqlservercentral.com/scripts/script-db-level-permissions-v4-3

Intellisense telling you it thinks there is an error isn't the same as having an error.

so do you GET an error when you execute the code?

does the index not get...