Recent content by dba112233

thank you, I understand. Really, it's looking at the server's C drive at that point because you're connected to the server in Analyzer, not (local)

>>>>Is SQL Running on the same computer you are trying to BULK Insert from? Not the server, the user simply has a client install where they're using Analyzer to talk to a remote server to insert records into a table they created Ex. Here at the office, I have a workstation (let's call it...

for some reason, SQL cannot open the file below. I checked the path and in the run prompt it opens fine. It's a synax error I think but the error doesn't say, it's just a generic error: BULK INSERT tablename FROM 'c:\Documents and Settings\sss\Desktop\myfile.txt'

nevermind, I guess I'll just manually add or minus hours

How can I tell the scheduler to run at certain times for specific time zones in SQL Server 2000? I don't see a time zone option, just daily, weekly, etc. then times

In my query below, is HAVING cb.CurrentBalance <> SUM(rf10.rmstranamt10) - SUM(rf.rmstranamt) the same as the value that my CASE statements come up with for [balance] ? Isn't putting straight SUM(rf10.rmstranamt10) - SUM(rf.rmstranamt) overriding what I want to be there which is: HAVING...

figured it out, the user gave me the incorrect business requirements!!

figured it out, the user gave me the incorrect business requirements!!

If I have incoming values of rmstranamt rmstrancde 50.00 51 50.00 51 50.00 51 50.00 51 50.00 51 50.00 51 50.00 51 -50.00...

I sorry, I made a mistake explaining, LET'S start over. If I have incoming values of rmstranamt rmstrancde 50.00 51 50.00 51 50.00 51 50.00 51 50.00 51 50.00...

crap, I should have this instead SELECT RMSFILENUM, RMSTRANCDE, SUM( CASE WHEN rmstrancde IN ('50','51','52','53') AND rmstranamt < 0 THEN rmstranamt WHEN rmstrancde IN ('50','51','52','53') AND rmstranamt >= 0 THEN -ABS(rmstranamt)...

EXACTLY If it's already negative, keep it negative...

Here's the SUM portion of my code: INNER JOIN ( SELECT RMSFILENUM, RMSTRANCDE, SUM( CASE WHEN rmstrancde IN ('50','51','52','53') AND rmstrancde < 0 THEN rmstranamt WHEN rmstrancde IN ('50','51','52','53') AND rmstrancde >= 0...

SUM( CASE WHEN rmstrancde IN ('50','51','52','53') THEN (0 - ABS(DISTINCT rmstranamt)) WHEN rmstrancde IN ('55','56','57','58') THEN ABS(DISTINCT rmstranamt) ELSE DISTINCT rmstranamt END ) As rmstranamt ERROR...

sorry I mean the SECOND INNER JOIN is what I'm referring to