homebrew01 (7/21/2016)

---

All the "@SQL_CMD" are INSERT statements.

The process is for a simple utility for users. They enter some parameters such as Job#, State, and search string. The Stored Procedure...

Thanks for you feedback.

Please check the following Linked server error not caught by TRY-CATCH

Are the all 4 scripts in Variable "@SQL_CMD" are Select statements ? If they are then that means your SPs is generating multiple result set.

you need to handle it in...

check the following Calculating Totals and Other Aggregates (Reporting Services)

can you share what is your desired output should look like?

Share...

astrid 69000 (7/20/2016)

---

the first version is a guess, more or less, when i run the second version i get

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'Finiti'.

i...

what kind of error you are getting? in both of your versions ?

Btw, In your 1st version (Assuming there is no typo why copy t-sql) you have syntax errors.

Thanks for your feedback. you can also change your following query:

SELECT RIGHT('00' + CONVERT(VARCHAR(2), Datepart(month, Getdate())), 2)

+ RIGHT('00' + CONVERT(VARCHAR(2), Datepart(day, Getdate())), 2)

...

They only Implicit type casting to INT in your complete query it the following line:

WHERE Req.Status <> 100 AND CAST(Req.Processtime as DATE)= '2016-07-18'

As per your Table Definition Field Req.Status is...

Check the following Mystery or Junk data warehouse dimensions . This might help you understand the working.

Remember you are in the best situation to understand the requirements/scenario and...

Phil Parkin (7/15/2016)

---

Thanks for picking that up. It was untested, pre-coffee, and it's a Friday. A dire combination, when it comes...

you are very much welcome 🙂

you can try either of two option i have mentioned above.