Viewing 15 posts - 1,141 through 1,155 (of 2,458 total)
First, below is a simple and easy solution that is much less complicated than a loop-based, multi-variable solution. It also performs quite well (for when performance does matter).
DECLARE @rng-2...
-- Itzik Ben-Gan 2001
December 1, 2015 at 9:28 pm
I think there are three problems:
1. The genuine need for talented data pros is growing much faster than the supply of talented data pros.
2. Many (perhaps most) companies...
-- Itzik Ben-Gan 2001
December 1, 2015 at 9:02 pm
Brandie Tarvin (11/30/2015)
Luis Cazares (11/30/2015)
Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
And now my head...
-- Itzik Ben-Gan 2001
November 30, 2015 at 1:40 pm
jmpatchak (11/21/2015)
/****************************************************************************************
(1) Setup DDL
****************************************************************************************/
IF OBJECT_ID('dbo.Chooser') IS NOT NULL DROP TABLE dbo.Chooser;
IF OBJECT_ID('dbo.Book') ...
-- Itzik Ben-Gan 2001
November 21, 2015 at 6:19 pm
omegadev21 (11/20/2015)
Jeff Moden (11/20/2015)
Ah... maybe I missed it. Is this the data example?
Given the field CLIENT_DATA of data type VARCHAR(MAX) with data:{"LASTNAME":"Doe","FIRSTNAME":"John","EMAILADDRESS":"something@email.com","USERNAME":"exusername","PHONENUMBER":"15555555555"}
@jeff Moden, yeah that's the sample...
If only I...
-- Itzik Ben-Gan 2001
November 20, 2015 at 10:48 pm
This seems like a fun little exercise and this kind of thing sharpens your skills for sure. +1000.
Here's what I put together. Note that I cleaned up your DDL....
-- Itzik Ben-Gan 2001
November 20, 2015 at 7:41 pm
There's a bunch of ways to do this using T-SQL, a CLR, Powershell, cmdexec, etc. You should copy an attachment of what the text file looks like (you don't need...
-- Itzik Ben-Gan 2001
November 20, 2015 at 5:10 pm
I wonder how popular this kind of solution is...
Did anybody come across something similar?
I'm currently on a project migrating an Oracle-based data warehouse / Cognos Reporting solution over to...
-- Itzik Ben-Gan 2001
November 20, 2015 at 5:04 pm
A purely T-SQL solution:
Consuming JSON Strings in SQL Server[/url] by Phil Factor
-- Itzik Ben-Gan 2001
November 20, 2015 at 4:46 pm
Jacob Wilkins (11/20/2015)
CREATE TABLE Query_Test
(
CPU INT ,
ApplicationName VARCHAR(100) ,
...
-- Itzik Ben-Gan 2001
November 20, 2015 at 4:35 pm
This should do the trick. I just cooked this up and only had like 10 SSIS pacakages available to test against so there is likely more stuff you can extract....
-- Itzik Ben-Gan 2001
November 20, 2015 at 3:56 pm
<removed> Mistaken.
-- Itzik Ben-Gan 2001
November 20, 2015 at 1:36 pm
We have one particular report that contains 18 datasets, all stored procedure based, that needs to be studied for performance reasons, especially. Every now and then this particular report gets...
-- Itzik Ben-Gan 2001
November 20, 2015 at 12:10 pm
Sapen (11/20/2015)
Database mirroing, logshipping, replication, clustering from version...
-- Itzik Ben-Gan 2001
November 20, 2015 at 10:05 am
This is where a Tally Table is a good thing. I run into this kind of problem and want to know why 2 strings are not equal. This would probably...
-- Itzik Ben-Gan 2001
November 19, 2015 at 7:27 pm
Viewing 15 posts - 1,141 through 1,155 (of 2,458 total)