Don't know if it will be correct in this case or not ..

but just try by taking filtered records of

first query [select from table1 where PartitionID between 1200...

Don't know performance wise it is good or bad..but i come up with below code

create Table #temp

(MeteriD INT,

ReadingDate DATETIME,

Reading INT

)

INSERT #temp

SELECT 3969,'1/01/2014 0:00', 0

UNION ALL

SELECT 3969,'1/01/2014 0:15', 0

UNION ALL

SELECT...

yes, i have added parenthesis ..that's why it was working ..

Sean Lange's code works perfectly ..with index seek

WHERE (@p_flag = 1 AND moveFlag = 26)

OR (@p_flag <> 1 --if this is a bit I would use = 0 instead of...

You can check that by query plan

Below query give you all non clustered...

yes..your code is correct..

<=DATEADD(yy,1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))

don't know what is required output .

but above code will give you next year's first date i.e '2015-01-01 00:00:00.000'

Hi,

try this..

select ID, Group,CONVERT(Date, Summary_Date) as Summary_Date from Application where Group='" + selectedGroup + "' and Summary_Date <=DATEADD(yy,1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))

order by ID, Summary_Date

Try below

SELECT TBL_B.p_id,

FirstName,

lastname,

SSN,

CASE WHEN TBL_A.p_id IS NULL

THEN TBL_B.aff_id

ELSE TBL_A.pref_val

END aff_id ,

Stat,

p_typ

FROM TBL_B

LEFT OUTER JOIN TBL_A on TBL_A.p_id=TBL_B.p_id AND pref_ty_cd='PREF_BA'

-- left outer join tbl_c --condition

-- left...

i think you can get count of filename like you derived SUM(f.zipfilesize) ,and use it in final CTE finalTable

Thank you ..emiranda

Is it good to have certification to get job as sql developert in canada ? As i don't have any certification but i have experience of 6...

sorry it is related to SQL server 2008 ..i posted in wrong forum

Hi,

I also want to know how is job market for SQL developer in canada and which state is feasible to get job as SQL developer.

Thanks,

Megha

I have removed one sort by adding it in source it self..

but other sort controls are needed as i am joining main table on different fields

still i am not getting...

Thanks..Phil Parkin and Koen Verbeeck.

will do that.