I want to do a select request that perform a first select and then use that selection to perform a second select. I made a 1st version using a temp table but I would like to know - is there is a wa...

May 4, 2017 · I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a …

Sep 15, 2008 · The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server.

SELECT * FROM ScoresTable WHERE Score = (SELECT MAX(Score) FROM ScoresTable AS st WHERE st.Date = ScoresTable.Date) Is there a name to describe using a SELECT statement within …

SELECT name FROM agentinformation Doesn't the inner select statement create a result set which the outer SELECT statement then queries?

May 22, 2013 · The SELECT INTO statement creates a new table and populates it with the result set of the SELECT statement. SELECT INTO can be used to combine data from several tables or views …

Oct 15, 2012 · Possible Duplicate: SQL: Select dynamic column name based on variable I have the following simple select statement: DECLARE @value varchar(10) SET @value = 'intStep' SELECT …

SELECT * [except columnA] FROM tableA The only way that I know is to manually specify all the columns and exclude the unwanted column. This is really time consuming so I'm looking for ways to …

Oct 14, 2009 · Is the important thing here to get a distinct list of those values, or to get that list of values into SQL? As @JeppeStigNielsen says, there are other ways to get distinct values from a text list …

Nov 23, 2012 · I have a select statement which will return 2 columns. ID | IDParent Then in my program I have to test if IDParent is < 1 then use ID ELSE use IDParent Is there a way to use an If Else like