Forum Replies Created
Viewing 15 posts - 4,756 through 4,770 (of 8,761 total)
-
RE: Today's Random Word!
Revenant (8/11/2015)
SQLRNNR (8/11/2015)
dearthsincerity
naïve
-
RE: charindex/substring to replace varying amounts of '/'
For giggles here is yet another slightly modified version. The difference doesn't look much but it is an improvement over the first one of roughly 20% and 5-10% over Luis's...
-
RE: PRINT bug ?
mar.ko (8/11/2015)
WHILE @@FETCH_STATUS = 0BEGIN
FETCH NEXT FROM C_tables INTO
@ColName
,@ColOrdPosit
,@TabSchema
,@TabName
,@ColDataType
,@ColDefaultVal
;
PRINT @ColName + ' ' +STR(@ColOrdPosit) + ' ' +@TabSchema + ' ' +@TabName + ' ' + @ColDataType +...
-
RE: SSIS Job Fails for No Reason
Michelle-138172 (8/11/2015)
I have a job that runs an SSIS package. The job seems to be able to run through the package successfully, but at the end it errors out saying... -
RE: Are the posted questions getting worse?
Didn't think I was geeky or nerdy but 30min after "just looking at few things", this was the MRU list
😎
-
RE: Are the posted questions getting worse?
SQLRNNR (8/11/2015)
Just curious if anybody knows what a "SPAM DIG" happens to be? Is that like a clam dig?In simple terms, blacklisting
😎
-
RE: Pull top 3 max values for each account
Sean Lange (8/11/2015)
maria.witkowski (8/11/2015)
Not sure which is more efficient?? The table has about 40k rows in it. But I will try both! Thank you again!I don't think that Eirikur...
-
RE: Use of Default keyword as the parameter default - what value is it ?
mar.ko (8/11/2015)
@pvColumnName??VARCHAR(100) = Default,??However, I am unable to determine what is the value for Default.
Is it '' ?
Default is not permitted as a constant - below fails to parse:
WHERE t2.TABLE_TYPE...
-
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (8/11/2015)
Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.Would have been more if "someone"...
-
RE: Pull top 3 max values for each account
Quick alternative to Luis's fine solution
😎
USE tempdb;GO
SET NOCOUNT ON;
DECLARE @SAMPLE_DATE TABLE (account INT ,dates DATE);
INSERT INTO @SAMPLE_DATE(account,dates)
VALUES
(1234565, '2015/01/01')
,(1234565, '2015/02/15')
,(1234565, '2015/02/16')
,(1234565, '2015/08/01');
SELECT TOP (3)
SD.account
...
-
RE: Are the posted questions getting worse?
SQLRNNR (8/11/2015)
Grant Fritchey (8/11/2015)
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!Big Trouble in Little China.
That was quick.
Nothing better than a whole hog chop...
-
RE: Today's Random Word!
eccentricDBA (8/11/2015)
whereisSQL? (8/11/2015)
Revenant (8/11/2015)
Ed Wagner (8/11/2015)
Luis Cazares (8/11/2015)
Ed Wagner (8/11/2015)
djj (8/11/2015)
Eirikur Eiriksson (8/11/2015)
Ed Wagner (8/11/2015)
TomThomson (8/10/2015)
SQLRNNR (8/10/2015)
centrifugeacceleration
Velocity
Inertia
Energy
Force
Dark Side
Sith
Emperor
Darth Sidious
Dark Helmet
Asthma
-
RE: Are the posted questions getting worse?
Jeff Moden (8/11/2015)
Ed Wagner (8/11/2015)
Sean Lange (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with... -
RE: charindex/substring to replace varying amounts of '/'
Quick suggestion
😎
USE tempdb;GO
SET NOCOUNT ON;
DECLARE @sourcedata TABLE(STR_DATA VARCHAR(100) NOT NULL);
INSERT INTO @sourcedata(STR_DATA)
VALUES
('/@836d254c/v1/HOME/INDEX' )
,('/@836d254c/v1/ASSIST/SPECIAL' ...
-
RE: Are the posted questions getting worse?
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:ATTRIBUTE1 nvarchar(1)
ATTRIBUTE2...
Viewing 15 posts - 4,756 through 4,770 (of 8,761 total)