Viewing 15 posts - 4,741 through 4,755 (of 8,761 total)
Grant Fritchey (8/13/2015)
Lynn Pettis (8/13/2015)
Ed Wagner (8/13/2015)
I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.
Having been working in...
August 13, 2015 at 9:24 am
Jacob Wilkins (8/13/2015)
August 13, 2015 at 9:19 am
Quick suggestion on parsing the XML
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @INPUT XML = '<input>
<pair>
<acct_no>23423</acct_no>
<tran_dt>9-11-2015</tran_dt>
</pair>
<pair>
...
August 12, 2015 at 11:18 pm
Ed Wagner (8/12/2015)
SQLRNNR (8/12/2015)
whereisSQL? (8/12/2015)
Ed Wagner (8/12/2015)
Eirikur Eiriksson (8/12/2015)
Ed Wagner (8/12/2015)
Steve Jones - SSC Editor (8/12/2015)
brokeSpending
spree
Candy
Crush
saga :crying:
Series
Sequence
August 12, 2015 at 12:55 pm
busraker (8/12/2015)
August 12, 2015 at 12:54 pm
SQLRNNR (8/12/2015)
Lynn Pettis (8/12/2015)
I don't know about others but I am really tired of people thinking that using vulgarity is appropriate in a professional environment and this is...
August 12, 2015 at 12:38 pm
Welsh Corgi (8/12/2015)
Brandie Tarvin (8/12/2015)
Welsh Corgi (8/12/2015)
Brandie Tarvin (8/11/2015)
Welsh Corgi (8/11/2015)
Unfortunately I get your code to work.
On behalf of everyone who is wondering...
Why is it unfortunate that you got...
August 12, 2015 at 12:23 pm
Lynn Pettis (8/12/2015)
August 12, 2015 at 12:16 pm
GilaMonster (8/12/2015)
Lynn, I think that may have been unnecessarily antagonistic.
Agree, given the shortage of Silver Spoons since the last shipment hasn't arrived end yet.
😎
Edit: speech to text bug.
August 12, 2015 at 10:29 am
Ed Wagner (8/12/2015)
Steve Jones - SSC Editor (8/12/2015)
brokeSpending
spree
August 12, 2015 at 9:07 am
WayneS (8/12/2015)
Eirikur,Since you're doing a performance test, how does this compare?
Close to identical to the CTE version in performance and funny enough the QUERYTRACEON 8607 output tree differs only in...
August 12, 2015 at 8:06 am
Ed Wagner (8/12/2015)
djj (8/12/2015)
Ed Wagner (8/12/2015)
Eirikur Eiriksson (8/12/2015)
Revenant (8/11/2015)
SQLRNNR (8/11/2015)
dearthsincerity
naïve
Clueless
Valley Girl
1980s
Orwell
August 12, 2015 at 6:30 am
Quick solution, similar to Kutang Pan's but slightly more flexible
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
Campaign CHAR(2) ...
August 12, 2015 at 6:25 am
thbaig (8/12/2015)
A strange issue is reported in production where one of stored proc is executing in variable time. Sometime with the same input it takes 5 sec and sometime more...
August 12, 2015 at 2:52 am
Viewing 15 posts - 4,741 through 4,755 (of 8,761 total)