Using copy/paste from your post, I tried the query on my database (which is SQL Server 2012, so not the same version) and it ran without error.

Can you repost the...

Actually, int has a higher precedence than string, so the implicit conversion should be from string to...

Jeffery Williams (4/14/2016)

---

Here is code that works like intended. (EXCEPT it does not insert the results into a table)

When you run this you get a table of results back in...

shoab.shah (4/14/2016)

---

Hi All.

Currently in one of our project we have a situation.

The server computer is Windows Server 2008 Standard SP2. Processor is Xeon (R) 2.13 Ghz. SQL server 2008...

shezi (4/13/2016)

---

I want to insert only unique tracerNo field if it doesn't exist. Here is my code. This is not working for some reason. When I run this nothing get...

ianharris2 (4/13/2016)

---

Thanks for your reply Scott.

Yes, you're right of course, I will look at optimising the indexes based on the usage and other stats gleaned from the DMVs. I was...

Reading your code, it is not clear what you want. As others already said, the error comes from a structure that looks like this:

SELECT ... FROM (INSERT ... SELECT ...)

That...

dpsql (4/14/2016)

---

Thank you for responding Hugo!

That works on getting the report to show up with a specific letter.

How can I get it where the reviewer...

lotusnotes (4/14/2016)

---

Ok. Thanks guys.

If you use an alias od.orderid it still lets you do it & the overall code still works & returns no rows.

You would hope to...

WHERE ColumnName LIKE 'D%'

krypto69 (4/13/2016)

---

Sure I did and the grouping is fine.

But after putting in the piece of junk dashboard software - I now think what I really have to have is...

In addition to the replies you already have - first, before doing anything at all to change the state of the database, take a full backup with the copy-only option...

Rong

Carrier

BWFC (4/13/2016)

---

Hugo Kornelis (4/13/2016)

---

If you can indeed not make...