Viewing 15 posts - 16 through 30 (of 1,047 total)
You can accomplished this using below query:
;WITH CTE AS
SELECT [Pax ID],[Flight Date],[Flight Number],[Last Mod Date],[status]
February 19, 2015 at 12:12 am
You can use below query for this:
select country_name, region_name,COUNT(region_name)total
group by country_name, region_name
February 10, 2015 at 12:13 am
you can also do this usinf Except -
;WITH CTE AS
SELECT MachineName, GroupName
(SELECT distinct A.MachineName
FROM #MachineGroups A)C
(SELECT distinct B.GroupName
FROM #MachineGroups B)D
SELECT C.MachineName, C.GroupName
FROM CTE C
February 9, 2015 at 2:22 am
Instead of using UNION ALL you put can use Join and select out the common data from your table and after that you can add a column as a flag...
January 7, 2015 at 12:04 am
Can you please post the actual execution plan and statistics ?
November 28, 2014 at 12:18 am
Thanks all for your suggestion
November 26, 2014 at 2:03 am
I have updated this one as:
--BEGIN TRAN ROLLBACK
CASE WHEN Division = 'AWT' THEN
CASE WHEN Product_Line = 'N' THEN
CASE WHEN Product_Type = 'AG' THEN
CASE WHEN AWT_Tank_Size = 120 THEN...
November 26, 2014 at 12:19 am
Eirikur Eiriksson (11/25/2014)
November 25, 2014 at 1:12 pm
you can use join for that...
November 16, 2014 at 10:46 pm
sorry, posted the wrong desired output..
please seet he modified one
November 5, 2014 at 3:04 am
Can you please provide table scripts and some sample data, that would be easier for us to understand the scenario
October 20, 2014 at 12:48 am
You can also follow the STAIRWAYS link available in this site only....
You can learn many new things from there other than reporting services 🙂
October 15, 2014 at 4:41 am
Please provide table structure and sample data for this....
September 7, 2014 at 3:13 am
Koen Verbeeck (6/30/2014)kapil_kk (6/30/2014)only SELECTIt works fine here.CREATE PROC dbo.MyTestProc ASSELECT 1 AS Test;GODECLARE @cnt INT;EXEC dbo.MyTestProc;SET @cnt = @@ROWCOUNT;SELECT @cnt;
Koen Verbeeck (6/30/2014)
kapil_kk (6/30/2014)only SELECT
It works fine here.
CREATE PROC dbo.MyTestProc AS
SELECT 1 AS Test;
DECLARE @cnt INT;
SET @cnt = @@ROWCOUNT;
Does it make any impact if I used SET NOCOUNT...
June 30, 2014 at 4:51 am
Koen Verbeeck (6/30/2014)What does the stored procedure do? Insert, update, delete, select?
June 30, 2014 at 4:12 am