Thank you for the link to the article on dynamic and static queries. I need to update/educate myself on sql query performance tuning:Whistling:. I am using a lot the syntax...

Post some code samples you use to read the excel data.

You may only have a problem seeing the line breaks using your select statement in SSMS. Please compare output of this code in SSMS using 'Results to Grid' in Management...

Hi,

If your parameters are optional, do not create dynamic sql, but construct WHERE clause this way:

WHERE...

I have a hint for you. Use over clause with aggregate functions. On the top level of your statement please use something like the code below. You need to check...

With the parsename function you check whether there is a value on a specific position of object name, but then you don't check what the value actually is.

Please check if my solution suites you. I have no table to test the code I provide below, but IMHO it should do. The parsename function you use is...

Hi, please note there is a grouping function you should use to check whether the row is a total, not isnull function.

create table #abc

(

source varchar(100),

date datetime,

status varchar(100)

)

insert into #abc values...

It is also worth mentioning that replace function replacess ALL occurences of one string within another. So it is not always safe if you want to replace only the latest...

The thing is that you need to go to the listID node in the xml hierarchy and access jobID from there.

SELECT R.nref.value('../../jobID[1]', 'varchar(20)') [jobID], R.nref.value('.','varchar(20)') [listID]

FROM @xml.nodes('/jobs/job/lists/listID') AS R(nref)

Welcome!