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
Here's an alternative: IF EXISTS ( SELECT * FROM Clients C INNER JOIN InvoiceHeader I ON I.ClientID=C.ClientID INNER JOIN Addresses A ON A.ClientID=C.ClientID WHERE I.InvoiceNr=@InvoiceNr AND A.PrimaryAddr=1 ) BEGIN SELECT COALESCE(LTRIM(COALESCE(Salutation,'') + ' ' + FName + ' ' + LName), BusinessName) AS ClientName, A.* FROM Clients C INNER JOIN InvoiceHeader I ON I.ClientID=C.ClientID INNER […]
2003-06-17
1 reads
If you know VBScript you could consolidate all the info into one file from the all source files in the directory and then just do one import. Just another take on the problem
2003-06-17
It would be better to unsubscribe, drop and recreate the publication in the subscriber, instead modifying the sys tables by hand.
2003-06-17
1 reads
Use DTS to import the csv file. Look in Books OnLine for tutorials on how to use this tool from Enterprise Manager.
2003-06-16
You could try setting the recovery model to simple prior to running the nested transactions, and then resetting the option after the transaction has completed. When the simple recovery model is used, transactions are truncated from the log. SQL Server keeps a track of current transactions, and then removes them from the log on checkpoint. […]
2003-06-14
2003-06-13
1 reads
yes. you need to login as the service account and install a mapi client on the server.
2003-06-11
Hi Frank, This script is what I use to compare the data in two different tables...worked out fine for me... http://qa.sqlservercentral.com/scripts/contributions/458.asp
2003-06-11
1 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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