Viewing 15 posts - 6,241 through 6,255 (of 8,753 total)
ramana3327 (1/21/2015)
Need to change some columns datatype from nvarchar to varchar.Just need to drop the indexes that are on that column.
Do we get any problems from changing nvarchar to varchar
Here...
January 21, 2015 at 2:42 pm
GilaMonster (1/21/2015)
January 21, 2015 at 2:18 pm
Sioban Krzywicki (1/21/2015)
I have a bit of an announcement and a question.
I'm Transgender. I've come out as a woman in nearly every aspect of my life now and am...
January 21, 2015 at 2:11 pm
ryanabr (1/21/2015)
You are the MAN! look me up if you are ever in Minneapolis, I owe you a beer (keg really...) !Thanks again!
No worries, glad to help.
One of my favourites...
January 21, 2015 at 2:03 pm
Quick suggestion, use FOR XML PATH to concatenate the output into one dynamic sql string
😎
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.Control_Table') IS NOT NULL DROP TABLE dbo.Control_Table;
CREATE TABLE [dbo].[Control_Table](
[Server_Name] [varchar](50) NOT NULL,
[Database_Name]...
January 21, 2015 at 1:48 pm
I've been working on performance tuning and optimization of few special purpose functions which where derived from the DelimitedSplit8K function, wanted to share some of the findings related to the...
January 21, 2015 at 1:08 pm
This is possibly an overkill but can easily be extended
😎
USE tempdb;
GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATA TABLE
(
THREE_PART_NUM VARCHAR(50) NOT NULL PRIMARY KEY CLUSTERED
);
INSERT INTO @SAMPLE_DATA (THREE_PART_NUM)
VALUES
...
January 21, 2015 at 5:32 am
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
Viewing 15 posts - 6,241 through 6,255 (of 8,753 total)