I was thinking the exact same thing.

Having that issue right now, the problem comes not when the type is in the code, but when it's a parameter. An easy way to find problems would be like...

Jacob Wilkins (2/12/2016)

---

No need to use window functions. A simple CROSS APPLY will do the trick.

SELECT [OrderNumber]=OrderID,

[User]=x.[User]

FROM dbo.Orders CROSS APPLY (SELECT...

blurred

http://www.sqlservercentral.com/Forums/Topic1760779-2799-1.aspx

I was going to comment on that thread, but I got lost with some...

I would actually remove THEYEAR, THEMONTH & Month-Year columns and leave them as formatted values in SSRS.

Here's an option:

CREATE TABLE POSTING(

POSTING_ID INT IDENTITY(1,1),

...

If we're possitive, maybe the server rack...

djj (2/12/2016)

---

My comment also. I was thinking you stopped transaction...

Ed Wagner (2/12/2016)

---

Grant Fritchey (2/12/2016)

---

jasona.work (2/11/2016)

---

Ed Wagner (2/11/2016)

---

jasona.work (2/11/2016)

---

No, that's one of my domain controllers.

It's an older...

Here's some sample data (which you should have posted) and a shorter version of your query.

What should the results look like for this data?

CREATE TABLE POSTING(

POSTING_ID...

There's actually a good method to validate table names.

This is a generic example that you need to adapt to your needs. An invalid table name won't do anything.

DECLARE @table_name sysname...

Does this means that an article on this could be interesting?

Did you try something like this?

SELECT o.*,

COALESCE( NULLIF( o.t_wght, 0), x.t_wght, 0)

FROM [TBRTEK002] o

OUTER APPLY (

...

I'd encourage Scott's suggestion. You might be missing something in the code that can be improved.

micang (2/10/2016)

---

Orlando Colamatteo (2/9/2016)

---

The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the syntax is more readable than any of the...