Thank you Hugo Kornelis and Jeff Moden for the feedback.

Try this...

SELECT

PERNR,SUBTY,MIN(BEGDA) AS BEGDA,MAX(ENDDA) AS ENDDA

FROM table_name

GROUP BY PERNR,SUBTY

Drew,

No i didn't get any actual (or concrete) reason on why we want it this way (big surprise there :-D).

I conveyed my approach and also did a proof of...

Phil,

Thank you for the link. i had read on it before. That is not an option for me. Basically i have to insert a dummy row in the excel to...

Try this...

Select Firstname, Lastname, isnull(Region,'')

From Employees

WHERE Region = ''

--Keep your query as simple as possible

SELECT DISTINCT DateYear ,

DateMonth , Nbr , Nbr1 , Nbr2 , Datafield1 , Datafield2, ID

FROM [dbo].[TableName]

WHERE [ID] > 0

If possible, try...

Glad I could be a help!

But I think I am Mr. SolveSQL!

Grasshopper is what SQL central assigned my level to be ??

--Try this

SELECT

x.patID ,

x.Mdt

FROM

( SELECT

patID ,

...

Makes sense. Thanks.

Apart from your syntax error (which i have not checked)

what's the purpose of comparing same column from same table?

..."WHERE Loss_state = #tmpTotals.Loss_State"

seems like that's what is asked.

Try using this...

DECLARE @totalcnt int

DECLARE @cnt1 int

DECLARE @cnt2 INT

SET @cnt1 = (SELECT COUNT(*) FROM [database].[schema].table1)

SET @cnt2 = (SELECT COUNT(*) FROM [database].[schema].table2)

SET @totalcnt = @cnt1 + @cnt2

INSERT INTO [database].[schema].table3

SELECT @totalcnt

it just came full circle for me. Thank you SQL experts.

Thank you. Appreciate the quick response.

Thank you Lynn Pettis.

can you explain this...

DECLARE @name varchar(30)

SET @name = NULL

SELECT ISNULL(CONVERT(DATE,@name),'') as col1,CASE WHEN @name IS NULL THEN '' ELSE CONVERT(DATE,@name) END as col2, CONVERT(DATE,@name) as col3

col1: 1900-01-01...