Viewing 15 posts - 6,496 through 6,510 (of 8,761 total)
twin.devil (12/3/2014)
Koen Verbeeck (12/2/2014)
Eirikur Eiriksson (12/2/2014)
π
DECLARE @STR VARCHAR(100)='My name is Shiva';
DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN...
December 3, 2014 at 9:21 am
Quick thought, use a calculated column for an "active" flag, here is an example, not a full solution but should be enough to get you passed this hurdle
π
USE tempdb;
GO
SET NOCOUNT...
December 3, 2014 at 1:04 am
Quick sample code, not a complete solution but should be enough to get you passed this hurdle
π
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID('dbo.TBL_DETECT_DUPES') IS NOT NULL DROP TABLE dbo.TBL_DETECT_DUPES;
IF OBJECT_ID('dbo.SVFN_COUNT_DETECT_DUPES_CODE') IS NOT...
December 2, 2014 at 11:59 pm
swoozie (12/2/2014)
1) remove the references to the extra table from the XSD = didnt work
2) Change the name of the column in the XSD still...
December 2, 2014 at 11:39 am
Ed Wagner (12/2/2014)
Eirikur Eiriksson (12/2/2014)
Luis Cazares (12/2/2014)
Sean Lange (12/2/2014)
David Burrows (12/2/2014)
Luis Cazares (12/2/2014)
...it can be easier to start from scratch if we can understand the problem, than fix a complete...
December 2, 2014 at 11:17 am
Luis Cazares (12/2/2014)
Sean Lange (12/2/2014)
David Burrows (12/2/2014)
Luis Cazares (12/2/2014)
...it can be easier to start from scratch if we can understand the problem, than fix a complete piece of s...
I have...
December 2, 2014 at 10:07 am
+1
This is very annoying to say the least, hope it gets corrected!
π
December 2, 2014 at 6:53 am
Koen Verbeeck (12/2/2014)
Eirikur Eiriksson (12/2/2014)
π
DECLARE @STR VARCHAR(100)='My name is Shiva';
DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT...
December 2, 2014 at 6:17 am
Just and only for fun, here is a slightly twisted solution, recommend following Koen's suggestion
π
DECLARE @STR VARCHAR(100)='My name is Shiva';
DECLARE @XSTR VARCHAR(MAX) = 'SELECT(SELECT CHAR(32)+Y.XN FROM(SELECT ROW_NUMBER() OVER (ORDER BY...
December 2, 2014 at 6:07 am
Sean Lange (12/1/2014)
December 1, 2014 at 3:35 pm
Sean Lange (12/1/2014)
Matt Miller (#4) (12/1/2014)
Ed Wagner (11/25/2014)
Eirikur Eiriksson (11/25/2014)
Ed Wagner (11/25/2014)
Eirikur Eiriksson (11/24/2014)
Jeff Moden (11/24/2014)
Evil Kraig F (11/24/2014)
Jeff Moden (11/24/2014)
Eirikur Eiriksson (11/24/2014)
December 1, 2014 at 3:20 pm
.Netter (12/1/2014)
The link you provided keeps coming up as bad request?
Fixed the link, sorry about that;-)
π
December 1, 2014 at 3:07 am
Quick thought, you might want to look at sparse columns as the fourth alternative in addition to the options
aaron.reese mentioned, recent discussion on the subject on this thread
π
Edit: fixed...
November 30, 2014 at 11:51 pm
Further on Jeff's reply, here is a sketch / pseudo code showing how a cursor-less equivalent could look like. Note: this may NOT work as it is, some tweaking with...
November 30, 2014 at 11:10 pm
Jampandu (11/29/2014)
Instead of computing every time, I am planing to insert all the unique sequences into one look up table.
CREATE TABLE Lkup_UniqueSequenceValues
(
Id bigint identity(1,1)...
November 30, 2014 at 12:50 am
Viewing 15 posts - 6,496 through 6,510 (of 8,761 total)