Viewing 15 posts - 5,851 through 5,865 (of 8,753 total)
Looks like the only thing missing is actually to execute the dynamic sql
😎
EXEC (@sql);
April 3, 2015 at 5:20 am
Quick solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
GO
DECLARE @strname varchar(50) = '3 April 15 abcd Oh rrrrrrrAAAAdd HJHJG';
DECLARE @SAMPLE_DATA TABLE
(
SD_ID INT NOT NULL
,SD_TEXT...
April 3, 2015 at 5:01 am
Ravid_ds (4/3/2015)
Hi Experts,Can you please share your experiences on what basis should we decide to go with Page or ROW Compression?
Quick answer, it depends.
😎
Start by reading through these articles
...
April 3, 2015 at 3:20 am
Quick point, the temporary table resides in the tempdb, change the db part of the object_id function's parameter to point to it.
😎
/* Any User Database */
USE Test;
GO
/* The temporary table...
April 3, 2015 at 1:27 am
Quick thought, use READPAST rather than dirty read
😎
April 2, 2015 at 3:38 pm
whereisSQL? (4/2/2015)
Eirikur Eiriksson (4/2/2015)
Revenant (4/2/2015)
Ed Wagner (4/2/2015)
djj (4/2/2015)
whereisSQL? (4/2/2015)
SQLRNNR (4/2/2015)
BWFC (4/2/2015)
ExhibitionExhibitionist
Voyuer
Voyager
Space
Balls
shooting
stars
voyage
April 2, 2015 at 3:33 pm
Revenant (4/2/2015)
Ed Wagner (4/2/2015)
djj (4/2/2015)
whereisSQL? (4/2/2015)
SQLRNNR (4/2/2015)
BWFC (4/2/2015)
ExhibitionExhibitionist
Voyuer
Voyager
Space
Balls
shooting
April 2, 2015 at 2:29 pm
djj (4/2/2015)
Ed Wagner (4/2/2015)
Eirikur Eiriksson (4/2/2015)
Revenant (4/2/2015)
BWFC (4/2/2015)
ExhibitionArt
Conceptual
Abstract
Impressionism
Footprint
April 2, 2015 at 8:56 am
Revenant (4/2/2015)
BWFC (4/2/2015)
ExhibitionArt
Conceptual
April 2, 2015 at 7:54 am
Quick advice, use the DelimitedSplit8K [/url]function if you are on SQL Server 2008 or dbo_DelimitedSplit8K_LEAD[/url] if you are on 2012 and later
😎
April 2, 2015 at 7:27 am
djj (4/2/2015)
crookj (4/2/2015)
Ed Wagner (4/2/2015)
Eirikur Eiriksson (4/2/2015)
BWFC (4/2/2015)
djj (4/2/2015)
Eirikur Eiriksson (4/2/2015)
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
Basement
Cellar
Wine
Italy
Colosseum
Death
Tourist
April 2, 2015 at 7:20 am
BWFC (4/2/2015)
djj (4/2/2015)
Eirikur Eiriksson (4/2/2015)
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
Basement
Cellar
Wine
April 2, 2015 at 6:05 am
MVIT (4/2/2015)
April 2, 2015 at 3:49 am
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
April 2, 2015 at 2:02 am
I think you answered this question already
😎
My fears are that going the BizTalk route will over complicate the process as a whole.
April 1, 2015 at 11:05 pm
Viewing 15 posts - 5,851 through 5,865 (of 8,753 total)