Viewing 15 posts - 3,931 through 3,945 (of 15,381 total)
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.
In my experience nearly 95% of the people in this business actually have the...
September 2, 2014 at 3:42 pm
GilaMonster (9/2/2014)
"The inserted table only contains the rows inserted into the table. I need rows from other tables as well. Hence I can't use a set-based solution"Err.. ok...
Yeah that thread...
September 2, 2014 at 2:28 pm
Same question was asked as SO. http://stackoverflow.com/questions/25628199/getting-the-correct-joins
September 2, 2014 at 11:09 am
Nadrek (9/2/2014)
Which has a sample Perl RegEx for RFC822 validation, NOT including the arbitrarily nested comments allowed by the RFC.
Heaven help you if you have to debug that thing. That...
September 2, 2014 at 11:07 am
Wow there are LOTS of issue with your query. First of all you don't need to use a subquery for every single case expression. Just put the expression in your...
September 2, 2014 at 10:53 am
thomashohner (9/2/2014)
September 2, 2014 at 10:37 am
JackTimber (8/28/2014)
I need help with the below.Could somebody pls help me with this.
/*
I want to traverse through the loop and find the event before HardDrink.
If no hardDrink then...
August 28, 2014 at 10:09 am
Jeff Moden (8/28/2014)
David Burrows (8/28/2014)
Eirikur Eiriksson (8/27/2014)
... Guess I've been tainted by the Brits and they'r ironic sarcastic humour ...
In that case
SELECT a.steps,MIN(b.steps)
FROM #table1 a
CROSS JOIN #table1...
August 28, 2014 at 8:23 am
jonatan.carlberg (8/27/2014)
I'm quite new to SQL. I'm able to extract the info that I need, but only into a result of one row, like:
Order header ...
August 28, 2014 at 7:21 am
sharon-472085 (8/28/2014)
hi,trying to build SQL Query to retrieve the data
sharon
You haven't given us a lot to go on here but I will take a shot in the dark. I think...
August 28, 2014 at 7:20 am
GilaMonster (8/27/2014)
sqldriver (8/27/2014)
I used to use this. Not perfect by any stretch but got most of the junk out.Does it flag this as invalid?
http://gmailblog.blogspot.com/2008/03/2-hidden-ways-to-get-more-from-your.html
That is pretty slick. I didn't...
August 27, 2014 at 3:09 pm
ZZartin (8/27/2014)
SELECT steps, ROW_NUMBER() OVER(ORDER BY steps) AS ROW_NUM FROM #table1
)
SELECT t1.steps, t2.steps FROM TEMP_CTE t1, TEMP_CTE t2
WHERE t1.ROW_NUM < (SELECT MAX(ROW_NUM) FROM TEMP_CTE)
AND (t2.ROW_NUM - 1)...
August 27, 2014 at 10:28 am
michaeleaton 36224 (8/27/2014)
First time post, I hope this is in the correct place and I give enough info!
I have an Orders table which has the following fields:
OrderID (PK, int,...
August 27, 2014 at 10:21 am
keshabsingh (8/27/2014)
create table #table1(steps int)
insert into #table1(steps)values(1)
insert into #table1(steps)values(2)
insert into...
August 27, 2014 at 10:18 am
You can select the table/view name and hit Alt + F1. This is the keyboard shortcut to run sp_help for that object.
August 27, 2014 at 9:08 am
Viewing 15 posts - 3,931 through 3,945 (of 15,381 total)