nmcgowan (11/2/2012)

---

It appears to be finding the correct db now as i get the following but still get an error performing the update

use [DJesus_eCristal]

GO

Msg 102, Level 15, State 1, Line...

Nice job with the ddl and sample data. However, it is much preferred to just include in your post so we don't have to download a file and unzip it...

You're welcome. Glad that worked for you.

So you are all good...

David92595 (11/1/2012)

---

Hello,

I'm new to SQL, specifically T-SQL, I've done some research online and have a general idea of triggers. But I wanted to ask the community for any really good...

You can use a cte in a view so this should work for you.

;with FLOWTEST as

(

SELECT A.COMPKEY, B.HYDR_ID, B.DATE, B.hydr_gpm, B.gpm_20, B.gpm_10, B.gpm_0, B.staff_id, B.shift,

B.static, B.residual, B.pitot, B.pitot2, coeff,...

igloo21 (11/1/2012)

---

Sean Lange (11/1/2012)

---

I don't see anything wrong with this syntactically. What do you mean by "it's just not picking up by looking at p.State"? One thing you might do...

I don't see anything wrong with this syntactically. What do you mean by "it's just not picking up by looking at p.State"? One thing you might do to help you...

SQL_path (11/1/2012)

---

Gurus,

A quick q how do you enable search like this below . It returned nothing for me.

I was using set Replace(@search,'%','[%]') with my first code %+@search+% before.

now...

This is a bit unorthodox but I think it would work in your case. Given that you can't expect great performance out of this due to the strange way you...

Wow I have no idea why I put that plus in my code. :blush:

Definitely don't need it.

select * from #ITEM where item_desc like @search

select * from #ITEM where item_desc like + @search

Here is proof:

set @search='cake%'

select * from #ITEM where item_desc like + @search

set @search = '%cake'

select * from #ITEM...

From your description it is very unclear what you are trying to do. Can you post ddl (create table scripts), sample data (insert statements) and desired output based on your...

ddl, sample data and desired output please. See the first link in my signature.

Not sure what you mean exactly by task but...