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
Hi I am the author of myLittleAdmin : so yes ! it is worth installing it ! 🙂 I just drop these couple of lines to remind you there 3 licences of myLittleAdmin (full version) to win in the QOD this week ! Do not hesitate to contact me if you need more info about […]
2003-06-17
1 reads
2003-06-17
Maybe if you replace columns thismonth and thisyear by convert(int, convert(char(6),getdate(),112)) as ThisYearMonth you could gain on grouping/sorting. You could also test performance with full-outer-join. (might be bit messy select-clause)
2003-06-17
1 reads
Hi Did you read my sample chapter? I highly recommend it. I would say most run an active/active. I would run say the reporting DB (logshipped or a nighly copy refreshed) on one and the live oltp db on the other, this is a classic senario. The issue here is more to do with sql […]
2003-06-16
thanks steven, what is the easiest way to change all my 100+ triggers and add the "not for replication option"?
2003-06-15
Yuo could think outside the box... create a temp table with the values for your IN clause, and then do a join. For example, if you want: where col1 IN (2,5,7) create a one column table that contains three records with these values, and then say: where col1 = #tmp.Col Depending on your particular case, […]
2003-06-13
1 reads
Remove guest from msdb and do not give him access to this database. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-13
2003-06-13
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-12
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