The best way to get this answered is to post the actual SQL that is dynamically generated so we can see what the SQL is doing. (Just change exec(@SQL) to...

deleted answer

• This reply was modified 5 years, 2 months ago by Jonathan AC Roberts.

1. Get the count of the number of rows on the table
2. Get the average size of all the columns on the index
3. Multiply the answers from 1. and 2....

Try this:

select i.ItemID 
  from Item i (nolock) 
  left join QueueItemDeactivation qid (nolock) 
         on i.ItemID...

You could create a temporary table, insert all the rows you need into that. Then just select * from the temporary table.

You really need a lot more test data, you can replace later numbers by adding more...

Here is something that could be a start, if you have no other option:

DECLARE @Words TABLE (Words nvarchar(20));
INSERT INTO @Words 
VALUES ('ROAD'),
     ...

The only reason why I got it right was because it has bitten so many people that work in every company that I've ever worked in including me back...

We have a set of SSIS packages for a data warehouse ETL,  all the dtsx packages are in one solution (project) the entire project is checked into source control (currently...

SELECT DISTINCT
       Reg_Text
  FROM dbo.TestTable
 WHERE Reg_Text NOT LIKE '[A-Z][A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9]%'

DECLARE @DateString nvarchar(100)='Wed Jun 29 15:57:45 2019'
SELECT CONVERT(datetime,SUBSTRING(@DateString,5,100))

I would change the WHERE in the last query to:

  FROM staging.sfSurveillanceRecordHeader s1
 WHERE NOT EXISTS (SELECT *
        ...

So yesterday we got a bit of good/bad news...

Good, in that the wife has been called back to work and goes back on Tuesday.

Bad, in that the...

So yesterday we got a bit of good/bad news...

Good, in that the wife has been called back to work and goes back on Tuesday.

Bad, in that the wife got...

If output_response_xml =''

then the expression:

LEN(output_response_xml) - LEN(LEFT(output_response_xml,

CHARINDEX ('>Thank you', output_response_xml))) - LEN(RIGHT(output_response_xml, LEN(output_response_xml) - CHARINDEX ('', output_response_xml))) - 1

Is equal to -1, which will give you the error you have.