Viewing 15 posts - 16 through 30 (of 41 total)
I would still stick to char(10) and maybe consider a date column on the table so you know when you loaded the specific numbers into your system (in case there...
November 5, 2003 at 1:25 pm
I do a lot of work with phone number filtering on a daily basis. The structure for every column I have throughout the system that holds...
November 5, 2003 at 9:15 am
So, I checked the BOL... it seems like the ELSE clause is required, even if left empty...
"ELSE else_result_expression
Is the expression returned if no comparison operation evaluates to...
October 2, 2003 at 1:52 pm
One other option that made my life MUCH easier: I had the opportunity to follow the concepts of spreading files around the server. In other words,...
September 8, 2003 at 11:07 am
Jeff, that's likely the case. I have been noticing a correlation between by local user app crashing and these processes sitting there... In rechecking my app,...
August 26, 2003 at 12:59 pm
I don't think it's specific to that application. I have two different main applications running that my local users use, and both applications occasionally have processes...
August 26, 2003 at 10:02 am
Hmm... well, lets see if we get any toher responses before we decide its normal
August 25, 2003 at 11:51 am
This is an easy one... I have had this problem before, and essentially it is because you don't have some kind of unique identifier on the record. ...
August 11, 2003 at 8:53 am
How about:
SELECT <rows>, COALESCE(<nullcolumn>, 'ZZZZ') AS <nullcolumn>
FROM <table>
ORDER BY <nullcolumn> ASC
July 14, 2003 at 9:06 am
Maybe I'm being overly simplistic here or this has already been tried, but why not something like this:
SELECT SUM(CurrencyColumn) AS DollarSum
WHERE CurrencyColumn NOT NULL
Point taken. And I'm not offended... no autopsy, no foul.
June 23, 2003 at 10:28 am
Yeah, thanks, Dalec for your insight. I wasn't shifting the blame to the NetAdmin (did I hit a nerve, though?), I was implying that I made...
June 23, 2003 at 9:24 am
Actually, I was assured by the NetAdmin that my server was being backed up (the partitions that hold my MDF's and LDF's) as part of the backup...
June 22, 2003 at 12:40 pm
Steve,
I'm not offended, and I use the forums daily. That won't stop.
There are a few billion people on the planet, and all have different opinons, and...
June 19, 2003 at 10:05 am
As I saw in another posting set, the data guys outlined what they really wanted, and the people that would fit with that group likely responded. ...
June 18, 2003 at 5:47 pm
Viewing 15 posts - 16 through 30 (of 41 total)