Recent content by bcardona

how can i export a project from vss 6.0 to vss 8.0, not the whold database just certain projects. thanks in advance

how can i grab or search querysting for just http:// i.e if the querystring was http://www.google.com, i want to search the string for just http://. thanks

i guess this should work fine, i havent tried it yes, but im using sql 2005. let ya know and thank you.

Denis, no not yet, i create a new procedure, copy your code and the just execute it, is that correct, sorry for the basic question, but procedures are new to me.

Denis, what do you mean two dmvs, the code you put there, would replace what i had?

thanks guys, what is trying to be achieved is to see what session 144 is, i guess this is locking up the db, anyway can i just copy all the code and save it as a procedure then execute it or do i have to break it up into 2 seperate. sorry but im new with this. thanks

we are using sql server 2005 and im not familiar with stored uncommented procuedures, i was just handed and have no idea how to create or run it, any help is appreciated, i included the entire code. DECLARE @PID DECLARE @LOCKS TABLE ( spid int, dbid int, ObjId int, IndId int, Type...

we were going to go with that software, but we have too much invested with ecometry, but thank you.

i guess, you might call it that, its a third party that our sites after our sites and before our db, you send it some variables, i.e customer name,address etc.

does anyone here or know of a forum to ask about ecometry.

bborissov , thank you very much, that code was it, thanks everybody for your time and help.

bborissov my front end is an asp page, back end is sql server, its a 3 step process, user puts in a id number, it then displays the results which is multiple id numbers, those id numbers then get submitted via a html form to the delete page, here is the code. this is my original sql statement...

MIKE, here is the query delete from table WHERE CAST(id As varChar(20))IN('"&stredp&"')" stredp is the variable i use i.e stredp=request.form("id") i send these values and nothing gets deleted ('88597, 88598, 88599, 88600, 88601, 88602, 88603, 88604, 88605, 88606, 88607, 88608, 88609...

MIKE, SORRY I WAS TRYING TO ANSWER SOMEONE WHEN THEY ASKED ABOUT EXACTLY WHAT I WAS DOING, YES YOUR ARE EXACTLY RIGHT WITH THIS You want to delete records from that table where the ID field equals '88501' or '88534' or '88535', etc. SORRY I SHOULD HAVE SAID SQLSERVER, ALSO IM USING ASP TO DO...

heres how it works, someone enters a number, based on the results, i put the values into a form, once they make sure the results are correct, they hit submit the form with the multiple values to the delete page. so the sql statement looks like this. delete id from table where CAST(EDPNO As...