3 different people have now responded with 4 different guesses as to what you're trying to do here. 😛 Please try to explain better.

It is often a...

shalyn_bronson22 (9/29/2009)

---

SELECT top 5 Customers.ContactName, Orders.OrderDate,

(UnitPrice * Quantity) as Order_Cost

FROM Customers, Orders, [Order Details]

...

Try this. Note that criteria in your WHERE clause applies to your entire query. Moving it to the left join stops these rows from being filtered.

SELECT officename...

Of course you did, that's what you selected :hehe:.

Are you trying to build a string that is FirstName + MiddleName + LastName?

If so, you're using the wrong function.

SELECT FirstName +...

I'm not familiar with Jasper, but the usual way around this is to split the string into 4000 character chunks and concatenate them in your dynamic sql.

So you'd split your...

What's the error? Also, why are you selecting a variable from a table?

This works fine:

declare @string1 varchar(100)

set @string1 ='FirstName MiddleNameLastName '

select substring(@string1,1,10) FIRST

Patindex works on varchar(max). (I just tested it on strings over 10k)

Are you certain that is what's causing the truncation? Patindex doesn't truncate anything, it just searches and...

The double quotes might be messing you up. Use single quotes.

This fails on my 2K8 server on 80/90/100 Compatibility levels. I'm honestly not sure how you have it working on yours.

--CREATE DATABASE Test

--GO

ALTER DATABASE Test SET COMPATIBILITY_LEVEL = 100

GO

USE...

See below.

PP-564103 (10/2/2009)

---

Roust_m (10/1/2009)

---

bitbucket-25253 (10/1/2009)

---

Do not know why you would want to create an SP and not know if it would function, but yes it can be done for example:

CREATE PROCEDURE...

J-F Bergeron (10/1/2009)

---

Well, if you really want to use the exists clause, you need to add a condition with the first table #T1.

Here's how you can do it:

SELECT *

FROM ...

This is a stab in the dark. It likely won't work(or be obnoxiously slow), but try it.

SELECT DISTINCT

RTRIM(F.Fund_Number) AS Fund_Number,

...

Yikes.

Is the date you're looking to pass in always going to be a date only? (ie. no time)

Nice, I wondered if it might do that. ...