Viewing 15 posts - 2,671 through 2,685 (of 3,957 total)
Jason-299789 (10/1/2012)
nice once dwain, never thought of that, though I suppose it depends on how much you can change the underlying database structure.
Actually I see this all the time. ...
October 1, 2012 at 4:37 am
dwain.c (10/1/2012)
sqlusers (10/1/2012)
I have created a Default Constraint for my table. But this is not reflected on my table.
EX: Column ImportDate has a Datetime Datatype with NOT NULL Constraint.
I...
October 1, 2012 at 4:33 am
sqlusers (10/1/2012)
I have created a Default Constraint for my table. But this is not reflected on my table.
EX: Column ImportDate has a Datetime Datatype with NOT NULL Constraint.
I have...
October 1, 2012 at 3:58 am
Dev (11/30/2011)
SQLRNNR (6/11/2010)
bitbucket-25253 (6/11/2010)
Default port 1,433
UDP Broadcaster 1,434 ...
October 1, 2012 at 3:55 am
anthony.green (10/1/2012)
I believe that this is the latest, unsure if Steve has added any more since thishttp://www.sqlservercentral.com/Forums/Topic935523-83-1.aspx
IC. Very odd breakpoint there at 1433 and even odder that I should...
October 1, 2012 at 3:52 am
Don't use "status." Use an expiry timestamp instead. Then use that when you query to see whether the entry has expired.
October 1, 2012 at 3:45 am
Steve Jones - SSC Editor (11/26/2007)
Feel free to suggest other levels and/or names
Not suggesting a new level but apparently I've achieved "Default port," whatever that is (see attached). :hehe:
October 1, 2012 at 3:38 am
Laurie beat me to it. Same as hers but no reason for the HiearchyLevel:
;WITH SearchHierarchy AS (
SELECT RegionID, RegionName, ParentRegionID
FROM [ParentRegionList]
...
October 1, 2012 at 3:33 am
Sony Francis @EY (10/1/2012)
CREATE TABLE #Temp (Name varchar(100), value int)
INSERT INTO #Temp
SELECT 'Day1', 12
UNION
SELECT 'Day2' ,6
UNION
SELECT 'Day3' , 10
UNION...
October 1, 2012 at 2:52 am
Why not just STUFF it?
SELECT [StartDateTime], [EndDateTime], [RunTime(Minutes)]
INTO #sampleData
FROM (VALUES('2012-10-01 12:35:26.033','2012-09-30 12:51:05.170',15.650000),
('2012-10-01 16:27:35.957','2012-09-29 16:43:45.987',16.166666),
...
October 1, 2012 at 2:49 am
Sean Lange (5/29/2012)
Wait a minute...I thought we were supposed to be collecting a paycheck based on post count. I only do this for the money and the fame. 😛
I post...
October 1, 2012 at 2:30 am
Grant Fritchey (9/14/2012)
October 1, 2012 at 2:02 am
ChrisM@Work (10/1/2012)
L' Eomot Inversé (9/28/2012)
ChrisM@Work (9/28/2012)
Koen Verbeeck (9/28/2012)
laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
Who is going to make it to any of the SQL in the City events coming up in...
October 1, 2012 at 1:59 am
Here's another way that might work:
SELECT ID1, ID2, Ranking
FROM #Test a
GROUP BY ID1, ID2, Ranking
HAVING MAX(Ranking % 2) = (
SELECT MAX(Ranking)%2
...
October 1, 2012 at 1:29 am
Here's an interesting approach using a generic string splitter (DelimitedSplit8K) that can be found here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
DECLARE @CHARACTERS TABLE (CHARS CHAR(1))
INSERT INTO @CHARACTERS VALUES
('N'), ('E'), ('M'), ('H'), ('T'), ('V'), ('L'), ('C'...
October 1, 2012 at 12:39 am
Viewing 15 posts - 2,671 through 2,685 (of 3,957 total)