Recent content by Coder7

Hello. I am trying to insert spaces into a column that is data type 'v'. I insert ' ' and when I look at the table data after the insert, the data value is <> instead of being spaces. Do any of you know how to get spaces into a V data type? Thanks for any and all help, gurus!! :)

REALLY great pointers, Sheco - exactly what I needed, thanks! This code was written by someone else so I'm going through it now to see exactly what it's doing. I'll let you know what I find out.

Thanks..one less thing to look at. I'm going through the asp now so I can post some specific code here. Really appreciate your reponse....have a great weekend!

Have you ever heard of a listbox (select) that stopped displaying any values in it? I have a production application that has not be changed in any way. The data, however has increased and there are huge amounts of data now being returned from the sql server database that are supposed to...

Thanks for taking the time to respond!! I was sick last week and working to make code review deadline and not at my peak haha. Turns out I missed defining 2 variables related to the call to the database which is why the sp didn't fire. I got someone at work to help me. I just wasn't...

Hello. My stored procedure sp_Tx_Del_Maint works in query analyzer but the rows aren't being deleted when I call the sp from my asp page. I have displayed the input parameter value and it is correct. I have tried to execute working production stored procedures from my asp page and they don't...

Thanks for the great info Katy. Have a great week!

Good morning everyone! I have looked and cannot find a way to rename a DTS package. Is it correct there is no rename capability in SQL Server 2000? Thanks! :)

Thank you Mr. Denny. That worked perfectly. Can you tell it's the first time I'm working with decimal data type? haha. I have read alot but I missed this (obviously). ----------------- Another question, if you don't mind. Would it be better to define @s1 and @s2 as integers rather than...

Hello. Would one of you great people please help me? When I run this query, @score s/b 66.7 but 67 is printing (so I am assuming that the value that's being returned for @score = 67) but I can't figure out why. I appreciate your help, as always :) -------------------- Declare @s1 FLOAT...

Hello gurus. My brain is twisted trying to get this to work and I could really use your help, please. If there is a duplicate value for the max(chg_eff_date), then I must also use the max(sel_seq_nbr) to get the correct row. Here's the data, the results I need and my query (currently getting...

Pattycake, Now THAT looks promising. I've already added the ifs and am testing but I'll check out your suggestion and revert my sql if I have time (and I just might!) because you're solution is clean and succinct and and probably more efficient. WTG :) THANKS!! I'll let you know.

Good morning Esquared. The coalesces are good as is...none of those columns are nullable so there's no reason to check if the value is null or not. I was just trying to find a SIMPLE way to handle the sup_tso_id which is a nullable field that I now need to use as an input parameter to meet a...

Hi NoCoolHandle. I really appreciate your input, thanks alot! I like the coalesce so that's staying (for everything but sup_tso_id) but you have given me food for thought with the wildcard with isnull so I'm playing around with that. Currently I'm not getting any rows back but I'll see if I...

Good afternoon all. I've read the posted threads on this topic but none match my case and I'd really appreciate your help. I use coalesce in my search query which, until now, worked great because none of the columns in the search criteria were nullable. My new search criterion (sup_tso_id) is...