Viewing 15 posts - 5,716 through 5,730 (of 22,211 total)
Brandie Tarvin (8/12/2015)
SQLRNNR (8/11/2015)
August 12, 2015 at 5:14 am
WayneS (8/11/2015)
Any other Threadizens going to the Louisville SQL Saturday next week?
Nope. Omaha this week and then Okie City at the end of the month.
August 12, 2015 at 5:13 am
Lynn Pettis (8/11/2015)
Can't place the movie or show that came from, but love the editing!
Big Trouble in Little China.
August 11, 2015 at 12:10 pm
SQLRNNR (8/11/2015)
Grant Fritchey (8/11/2015)
Sean Lange (8/11/2015)
ATTRIBUTE1...
August 11, 2015 at 11:48 am
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 nvarchar(1)
.
.
.
ATTRIBUTE50 nvarchar(1)
VARCHAR(1)...
August 11, 2015 at 9:43 am
Sure thing, move the WHERE clause to the ON clause and it'll work.
OUTER JOINs are kind of funny in that if you put filtering criteria in the WHERE clause...
August 11, 2015 at 8:26 am
GilaMonster (8/11/2015)
Grant Fritchey (8/11/2015)
Just saw the news. Congrats Gail.
It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted...
August 11, 2015 at 6:57 am
Just saw the news. Congrats Gail.
August 11, 2015 at 6:49 am
Eirikur Eiriksson (8/11/2015)
0xC34F0xC350 Missed it:pinch::-D😎
... by that much.
August 11, 2015 at 6:48 am
GilaMonster (8/11/2015)
Grant would love this query. Views within views within views with a CTE and a temp table for good measure. Parse time is around 45 seconds.
Oooh, 45 seconds is...
August 11, 2015 at 6:47 am
We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them all to make...
August 11, 2015 at 6:34 am
Instead of MAX here, you might try TOP(1)
SELECT
@DateEnd = MAX(MeasureDate)
FROM...
August 11, 2015 at 5:37 am
Oops. Editing this because it was the answer to a different question.
August 11, 2015 at 5:36 am
mohan_padekal (8/11/2015)
First i updated Statistics of DataMaster table then try to execute the script that time getting error
Updating statistics won't change the names of columns. Have...
August 11, 2015 at 3:34 am
Viewing 15 posts - 5,716 through 5,730 (of 22,211 total)