Lowell (3/4/2014)

---

in a similar post a couple of years ago, i did a TSQL example that looked at the first x bytes and compared them to known values to find...

That looks a lot like a byte array. This is the typical way of storing binary type data in the database. I don't think there is a way to determine...

curious_sqldba (3/4/2014)

---

Thank you taking time in replying.

So if you copy paste the ouput in excel you will see that just first two words are together and all the other one's...

Seattlemsp (3/4/2014)

---

Thanks your both's responding!

The goal it to find the record which the Matter and Cateogry has exact the Group assignment.

That's all the information I can think about. What's infomration...

curious_sqldba (3/4/2014)

---

Sean Lange (3/4/2014)

---

curious_sqldba (3/4/2014)

---

Sean Lange (3/4/2014)

---

curious_sqldba (3/4/2014)

---

Jack Corbett (3/4/2014)

---

Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in...

SQLRNNR (3/4/2014)

---

That query would work well.

I have seldom seen this kind of requirement. When I have, it is something we throw in the presentation layer. A common place...

Or you could use shortcut this a little bit using aggregates.

select min(someval) as someval,

isnull(min(Category), 'No such Category') as Category

from #sometab

where Category = 'Unknown'

It kind of depends on if you...

curious_sqldba (3/4/2014)

---

Sean Lange (3/4/2014)

---

curious_sqldba (3/4/2014)

---

Jack Corbett (3/4/2014)

---

Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the REPLACE, like...

curious_sqldba (3/4/2014)

---

Jack Corbett (3/4/2014)

---

Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the REPLACE, like this:

DECLARE @data NVARCHAR(MAX)...

This is a classic example of why you shouldn't shove multiple data elements into a single column. It is a serious PITA to work with.

Not surprising. You have...

curious_sqldba (3/4/2014)

---

Jack Corbett (3/4/2014)

---

Can you post the code you are using. I just tested using this:

DECLARE @data NVARCHAR(MAX) = 'EXEC Proc_gen @PsID=12, @kID=-1, @ID=3183';

SELECT @data AS...

DaveK2014 (3/4/2014)

---

the udf is designed to get us the buyers names from the system and then we can only take the first 30 or the system goes boom. Some of...

Also you have a scalar function in there.

left(dbo.udfBuyers(tbClient.ID), 30)as Buyers

This can be a very serious performance killer. Not sure what that function does but turning that function into an iTVF...

DaveK2014 (3/4/2014)

---

Here is the sqlplan and a PDF of the actual store procedure. like I said running each piece separate is fast and running them together without the union all...