arnold-491793 (11/22/2009)

---

select alan8,

case

when rtrim(aladd1) <> '' then len(aladd1) + 9 else 0 end as vladd1 ,

case

...

u r welcome 🙂 . In future,...

Sure Lutz, that one part(expected result) of the whole episode lies with the OP. Cant really help there 🙂

Due to the fact that you've spent quite a lot of time on SSC I thought you would know what a 'consumable' formt is.Even Lutz's link would have directed you....

Can we have some test data in consumable format please?

MY bad! go with Vikas, that is the right solution for you.

ohh sorry, i dint understand completely that catid is a comma seperated value. Does this help?

Create table #t(t varchar(10))

INSERT INTO #t VALUES ('1,2,3')

INSERT INTO #t VALUES ('3,4,5')

Select * from #t

Where...

Select * from products where catid = '1'

Go through the link provided by Dugi. You will get what you want!

I think you need Instead of trigger. A trascript from the BOL

INSTEAD OF

Specifies that the trigger is...

What if the file is already there? That command is for opening the file, no?

one way you can do it is using CLR procedure/function. Check the file existence using .net code (vb/c#) and return 1/0 based on ur check there.

You gotta add system.drawing into your CLR assemblies first using SSMS under database-> programmability->Assemblies. Then add that reference into your SQL Server Project that you are working on.

There would...

With no test data and create table script, cant help much but dont you think you need 'Group By' clause rather than this cursor. I dont think you need a...

you'd get quicker and various responses if you post the request like this. Please follow the link. Thanks.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Ohh by the way, why are you using cursor here? Are you trying to create running total?