Viewing 15 posts - 6,256 through 6,270 (of 8,761 total)
Eugene Elutin (1/21/2015)
...
Elementary;-)
😎
Not quite so, try ('1.0.100')
😉
:pinch:
January 21, 2015 at 5:11 am
Eugene Elutin (1/21/2015)
add one more sample and see what will happen:('12.1.1')
...
Elementary;-)
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
THREE_PART_NUM VARCHAR(10) NOT NULL PRIMARY KEY CLUSTERED
);
INSERT INTO @SAMPLE_DATA (THREE_PART_NUM)
VALUES
...
January 21, 2015 at 4:49 am
Tex-166085 (1/21/2015)
I need to return the max value from a fieldwhich contains a three part numeric, stored as a varchar. For example
1.0.0
1.0.1
1.1.0
1.2.1
2.0.0
2.1.1
etc
These represent processes, and sub tasks. ...
January 21, 2015 at 4:14 am
Quick solution using the DelimitedSplit8K[/url] function
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
SD_TEXT VARCHAR(100) NOT NULL
);
INSERT INTO @SAMPLE_DATA (SD_TEXT)
VALUES ('PL:TW RR:1.8%,PL:TX RR:0.9%')
;
;WITH FIRST_SPLIT AS
(
...
January 21, 2015 at 1:47 am
twin.devil (1/20/2015)
.. unstoppable urge for asking from OP is WHY 🙂
One of those $M questions, boils down to trying to apply a technology specific solution to an incompatible problem.
😎
pietlinden (1/20/2015)
January 21, 2015 at 12:38 am
wannabe1 (1/20/2015)
how to join 2 heap tables with out any common fields.
It depends on the data in those tables and the properties of that data, there aren't any other options...
January 20, 2015 at 10:51 pm
Slight changes to accommodate for the multiple "State"
😎
USE tempdb;
GO
SET NOCOUNT ON;
declare @temp as table
(
ID int identity,
TS datetime2,
Speed decimal(4,1),
IgnitionOn bit
)
insert @temp select '1/17/2015 12:00',5,0
insert @temp select '1/17/2015 12:02',0,0
insert @temp select '1/17/2015...
January 20, 2015 at 1:33 pm
Jeff Moden (1/19/2015)
Eirikur Eiriksson (1/19/2015)
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks...
January 20, 2015 at 11:53 am
Jeff Moden (1/19/2015)
Eirikur Eiriksson (1/19/2015)
January 20, 2015 at 9:58 am
ashokputta9 (1/19/2015)
1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%") into LowendRR ("PL:TW RR:1.8%") and HighendRR ("PL:TX RR:0.9%")
2.Split the LowendRR ("PL:TW RR:1.8%") into LowendPL...
January 19, 2015 at 10:14 pm
Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into that implementation, that's straight forward with...
January 19, 2015 at 10:03 pm
ryanabr (1/19/2015)
I am using SQL Azure and I it looks like the LEAD and LAG keywords are not supported....
January 19, 2015 at 9:40 pm
Jeff Moden (1/19/2015)
Jack Corbett (1/19/2015)
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines...
January 19, 2015 at 1:31 pm
Grant Fritchey (1/19/2015)
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be...
January 19, 2015 at 9:13 am
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you...
January 19, 2015 at 5:30 am
Viewing 15 posts - 6,256 through 6,270 (of 8,761 total)