Viewing 15 posts - 18,886 through 18,900 (of 26,484 total)
A little hard to help you. It would help if you could provide the DDL for the tables, sample data that is representative (made up) of your actual data,...
September 11, 2009 at 9:32 am
I have to agree with Seth. there really isn't enough information in your post to really help you. If you could provide your code, DDL for the tables,...
September 11, 2009 at 8:42 am
Silverfox (9/11/2009)
September 11, 2009 at 8:27 am
vallolet04 (9/10/2009)
ALTER FUNCTION fn_ImporteconDescuentoFinal (@Importe float(8),@Cliente varchar(10))
RETURNS...
September 10, 2009 at 3:34 pm
Zaza (9/10/2009)
I've tried addingand Tablename = 'SALE' in my query but if a sale does not have a memo, it will disregard the sale alltogether
Thanks for your help though
Please show...
September 10, 2009 at 3:21 pm
What database are you in when you run the ALTER DATABASE?
September 10, 2009 at 3:17 pm
Dave Ballantyne (9/10/2009)
Select top 1 * from rates where end_date >= Inputdate order by end_date
Based on the sample data, I'd drop the = from the >= in the where clause.
September 10, 2009 at 12:29 pm
I'm not sure about this at all. It has been a while since I was in a database class, but I seem to remember in most of them that...
September 10, 2009 at 12:09 pm
Not having anything with which to test it, I think this is what Jeff was thinking:
ALTER FUNCTION fn_ImporteconDescuento (@Importe float(8),@Cliente varchar(10))
RETURNS Float(8)
AS
BEGIN
Declare @AuxImporte Float(20);
...
September 10, 2009 at 12:54 am
How does the id tie into this? From what I can tell it is nothing more than a row identifier. Am I wrong?
September 10, 2009 at 12:36 am
Couple of things first.
One, read the first article I reference in my signature block about asking for assistance. Please following the instructions in that article on what and how...
September 10, 2009 at 12:12 am
All I'm saying is that how you build the query is based on what the question asked. The OP indicated (right or wrong) that what he posted as was...
September 9, 2009 at 9:30 pm
I'm going to go with "it depends." Which result set is the correct one? Only the user knows for sure:
IF EXISTS(SELECT name FROM sysobjects WHERE name = N'test_maintable'...
September 9, 2009 at 8:59 pm
Sergiy (9/9/2009)
No, you should leave criteria on "FROM" table in WHERE:WHERE c.contest_id = 2
Only criteria on LEFT JOIN table go into ON.
I think it is a wash either way...
September 9, 2009 at 7:22 pm
CirquedeSQLeil (9/9/2009)
Lynn Pettis (9/9/2009)
September 9, 2009 at 4:18 pm
Viewing 15 posts - 18,886 through 18,900 (of 26,484 total)