yes. i think SQL Server Compact, but you can only use/access that database with a .NET or compact .NET on Windows Mobile;

if you are looking for something to sue...

either of these will do what you asked...they are functionally the same i think.

WHERE COLOR='RED' OR COLOR='GREEN'

WHERE COLOR IN('RED','GREEN')

now if you want where the product has BOTH, you have to...

also, using sys.columns is just an easy way to find a lot of items;

if you doi this:

--SQL 2005= 419

--SQL 2008= 483

select count(*) from model.sys.columns

that shows me that on my...

one of Jeffs other fine examples is creating a CTE Tally table that doesn't touch any existing tables, but creates it all on the fly;

there's not really much of a...

Nakul Vachhrajani (6/30/2011)

---

steveb. (6/30/2011)

---

Nakul Vachhrajani (6/30/2011)

---

A new table may not be feasible in all cases. If you have triggers deployed by interfacing applications, then dropping and recreating the table...

i just noticed that and fixed it; copy my code example again...i edited it to be syntactically correct, but with that code block at the end slightly changed to have...

ok correct me if i'm wrong, but the business logic is basically saying :

if this date is not null [do stuff]

ELSE

if this other date is not null [do stuff]

etc for...

ok i thought Unicode is just chars 1 to 255, but as i started pushing the limits of my example below, I get all sorts of unique chinese characters.

is...

ahh but you are missing the joins to the INSERTED table;

Every UPDATE in that trigger updates every row in the table with the current value calculated...NOT just for the row...

wow there is so much wrong witht he trigger, i don't know where to start.

it's not designed for more than a single row, so that's one.

every update updates the entire...

i doubt this helps much, but it was fun to look at;

i hate nested OR's and parenthesusi, i get dizzy trying to look through them.

can you compare this query to...

ok the more i look at this the more i get a glimmer of udnerstanding;

i think in that table two columsn represent theDate and TheTime.

CHDE = 1110627 --the date: 2011...

something else that struck me:

(A.CHDE > 1110627 AND A.CHDE < 1110628)

-- this is a Julian-ish date, century 111 month 06 day 27

--isn't that exactly the so someDatefield =1110627 instead?

(A.CHDE...

i had ideas like sturner to fiddle with, but i have no idea whether db2 supports some of the things i'd try.

for example, isntead of selecting the entire tables aliased...

What did you try?

did you try right clicking on SQL S3erver Managment Studio, selecting "run...