Can you tell me why the first example isnt deterministic? I can see that the parent relationship can change over time but what rule is exactly violed that are mentioned in BOL? : Whether a user-defined function is deterministic or nondeterministic depends on how the function is coded. User-defined functions are deterministic if: The function […]
2003-06-18
Not to one up Jay here (sorry joke about another thread). But here is another alternative. SELECT COALESCE(LTRIM(COALESCE(Salutation,'') + ' ' + FName + ' ' + LName), BusinessName) AS ClientName, A.* FROM Clients C INNER JOIN InvoiceHeader I ON I.ClientID=C.ClientID INNER JOIN Addresses A ON A.ClientID=C.ClientID AND (CASE WHEN A.AddrTypeID=@BillingAddressID THEN 1 ELSE A.PrimaryAddr […]
2003-06-17
2 reads
2003-05-21
If I understand, you are getting the criteria from a list box from a screen. My suggestion is: create procedure [dbo].[query] @ProgramType char(1), @AccountName char(1), @ProgramStatus char(1) as select ProgramId ProgramType AccountName ProgramName ProgramBudget ProgramStatus from <table> where ProgramType like @ProgramType and AccountName like @AccountName and ProgramStatus like @ProgramStatus If in your list box you […]
2003-05-20
5409045121009 Thanks once more. What I'm doing -- before launching each page, but only after trying to give more attention in reviewing the texts and commands (of course!!!) -- is, at MMC, right-clicking over my site, disconnecting-and-(re)connecting IIS. Wish it -also-helps!!! Dalton
2003-05-11
1 reads
SUM(a.FUEL_SALES*.0775) AS FUEL_TAX, b.AMOUNT AS FUEL_MAN FROM CSCSHBAL a LEFT OUTER JOIN CSCRDTTL b ON (b.CARD_NAME='FUELMAN' AND a.DBR_DATE=b.DBR_DATE AND a.STORE_ID = b.STORE_ID) WHERE (a.STORE_ID LIKE @STORE_ID AND a.DBR_DATE>=@START_DATE AND a.DBR_DATE<=@END_DATE) This code got me this result: STORE_ID DBR_DATE TAXABLE_SALES NON_TAXABLE_SALES FUEL_SALE FUEL_TAX FUEL_MAN -------- --------------------------- ----------------- ---------------------------------- 7700 2003-03-27 1709.01 1183.70 14282.966025 1199.923975 NULL 7703 […]
2003-05-06
2003-05-05
1 reads
WHERE invoicedate BETWEEN DATEADD( mm, -6, CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME ) ) AND CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME ) Although I would recommend running GETDATE() one time prior to running this statement and using […]
2003-05-02
If you are talking about JOIN condition, it is better and more correct in the JOIN clause, not in the WHERE clause. It is also better to limit your result as soon as possible. Consider this: SELECT col1, col2 FROM t1 JOIN t2 ON t1.c3 = @variable AND t1.c4 = t2.c5 Having ON t1.c3 = […]
2003-05-02
I was going to use Isdate() but it doesn't work on Datetime types, does it? Developer Developer Developer Developer Developer Developer Developer *jumps around like a moron* Developer Developer
2003-05-02
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers