You should start looking at the collation of character columns within the database looking for conflicts. From the one error message you posted it looks like there is a...

erics44 (6/10/2016)

---

I have 2 servers PROD and UAT

all dev has been done on Prod recently, ive just started here and I want to do my dev on UAT (no dev...

erics44 (6/10/2016)

---

Hi

I am trying to update a much out of date UAT database from the current production.

There are however lots of collation issues.

the database collation is the same, the tables...

Jacob Wilkins (6/10/2016)

---

Well, the attached plans aren't for acceptably-performing query with UDF and unacceptably performing query with UDF.

They're for query with UDF and query with inline equivalent.

It's expected that...

Sean Lange (6/9/2016)

---

This still is not really very clear what you are trying to do but here is my shot in the dark. You are looking for rows where BOTH...

Looks like Sean does have the crystal ball today.

SilverBack (6/9/2016)

---

IKm looking for two columns to in SSRS as Parameters.

So @StartD needs to be a column A in a Table and @EndD needs to be Column B in the...

SilverBack (6/9/2016)

---

This is a date between statement do you read I said I am looking for a way to do something like this? I have

no idea if it possible? I...

mcfarlandparkway (6/9/2016)

---

TY Champion,

These variables...

< different rant >

Repeating what you posted and providing NO explanation does not help with clarity.

< /different rant >

SilverBack (6/9/2016)

---

I thought I did. I am trying to find a way to use a Between statement with two different columns. The database I am working

with is highly encrypted and...

< rant >

Geez people. Try answering the question we ask instead of just expecting us to answer your question with no effort on your part.

< /rant >

mcfarlandparkway (6/9/2016)

---

Hello Insane,

I understand,...

SilverBack (6/9/2016)

---

In SSRS normally I would do a Date Parameter Statement like such:

Select

ek.effdate As StartD

ek.effdate As EndD

Where

ek.effdate between @StartD and @EndD

But I need something to work along the lines of...

mcfarlandparkway (6/9/2016)

---

Hello,

I need to know what is the logic that is going on each statement.

SET @Pay = (SELECT MAX(Id)...