aw lol, stupid of me, don't mind my example, I misread your sample given :hehe:

Hi again,

Is this some kind of assignment?

DECLARE @tbl TABLE (ID INT)

DECLARE @value NVARCHAR(MAX), @isEven BIT, @half INT

INSERT INTO @tbl

VALUES (1),(2),(3),(4),(5),(6)--,(7)

--TRY ADDING 7 OR MORE NUMEBRS

-------------------------------------------------------------

-- Proper approach (I think)

-- THIS...

Are those the only columns? :hehe:

Hi there,

did you want something like this?

DECLARE @tbl table (id int,word nvarchar(max))

DECLARE @value nvarchar(max)

--sample table and data

insert into @tbl

values (1,'the'),(2,'big'),(3,'brown'),(4,'fox'),(5,'jumps'),(6,'over'),(7,'the'),(8,'lazy'),(9,'dog'),(10,'and...'),(11,'fin!')

set @value='2,10,5,4' -- filter parameters (try adding zero ex. '2,5,0,4')

set @value=@value+','

;with...

HI there,

Is this what your looking for?

SELECTg.group_name

,m.last_name

,m.first_name

FROM groups g

INNER JOIN members_groups mg ON (mg.group_id=g.group_id)

INNER JOIN members m ON (mg.member_id=m.member_id)

Im a cheapskate LOL :hehe:

anyways, i don't really need it right now, just trying out things. might buy it if I already need it.

Thanks anyway... ^__^

Found out that this is a limitation of express edition... hmmm... but still, does anyone know any workaround to this

This is a miss post sorry. cant delete

Hi there,

Fix my last query, no need for a temp table anymore (just imagine the temp table here is your table)

Declare @tbl Table

(

...

Hi there,

Hope this helps. This ain't the best solution though. I'll try to find a better one if I have the time.

Declare @tbl Table

(

id int identity,

customer nvarchar(10),

product nvarchar(10),

[date] datetime,

sale nvarchar(10)

)

Insert...

^__^ Hi there,

uhmmm, i'm not usre if i understood the problem right...

i turn Ben's code to dynamic sql (which i always avoid using)

from Ben's code, are you saying you want...

Nice, I like how you teach people Paul 🙂

^__^ Welcome... Glad I could help!

oh!

Thanks guys ^__^

(forum noob here hehehe!)

Hi there,

Try CASTing them into numeric/decimals first

SELECT ROUND( CAST(-0.6401 AS DECIMAL(10,4)), 0 )

SELECT ROUND( CAST(-0.6401 AS DECIMAL(10,4)), 1 )

SELECT ROUND( CAST(-0.6401 AS DECIMAL(10,4)), 2 )

SELECT ROUND( CAST(-0.6401 AS DECIMAL(10,4)), 3...