I would not recommend this solution, since it depends on settings that can...

Hi,

I'd like to warn you that calling a stored procedure from trigger is one of the worst possible solutions. I should know it, the ERP system we are using does...

Hello Phil,

it would help us a lot in identifying the problems and arriving at a solution if you post a table definition + sample data together with your question.

Also,...

Aah.. so CURDATE returns string... that's what I suspected. Fine, can you replace the CURDATE function with any of the mentioned (GETDATE(), CURRENT_TIMESTAMP) converted to character data?

Example:

SELECT CONVERT(VARCHAR(10), GETDATE(), 110)

The...

Hello,

you didn't specify the error you are getting when it doesn't work... however, I suppose this will be a problem caused by language/dateformat setting (default date format is set within...

Garadin (12/12/2008)

At the time an invoice was generated, you'd look at your most recent record for Dollar > Euro conversion, calculate the amount in Euros and store those numbers with...

I think that the main point is:

So, as has already been mentioned, you don't need to insert...

Hello,

please specify what "if delete executes" means. Generally, delete statement will execute successfully, even if there are no rows to be deleted - but I suspect that what you mean...

There are two ways to solve this problem. Either contact the vendor of your system and require changes, or (if it is a report) build this report outside the system.

We...

OK, thanks :-). I'm not a native speaker, so I didn't catch that... for some reason I thought that previous 7 days are required. BTW, what does "store hours" mean?...

What do you mean by "empty row"?

Your procedure - as far as I can see - returns just one value. If the BEGIN-END block is skipped, returned value is ''...

That depends whether you need data from the last 7 days (like if you need to...

Johann Montfort (11/24/2008)

---

I tried the following

SELECT fileId, langid

FROM TableA ta

WHERE NOT EXISTS

(SELECT fileID, langID FROM TableB tb)

However this is not returning any results. Can you tell me what I am...

Hi,

as far as I can tell, LEFT is unnecessary here - in fact, the query performs as with INNER JOIN, because there is condition in the WHERE clause that works...

I know it's disgusting how we repeat the same thing over and over, but please, could you read this : How to post data ?

It saves...