Just to update, I got the solution.

--String Splitter keeping data into temp table

SELECT DEALID, SUBSTRING(NETOUTDEALS, n, CHARINDEX(',', NETOUTDEALS+',', n)-n) as netout

INTO #NETORDER FROM [dbo].DealExecutionOrder

CROSS JOIN (select number from...

Let me put the problem in different words so that it is easy to understand the context.

Assume the case to be an organization assigning employees to do annual reviews...

This is what I tried but did not work. DealID=1 is coming before 12 in the output.

Please let me know if I am not clear.

--String Splitter keeping data...

For simplicity, I have taken only needed columns. In reality, DealID itself is a FK. NetOutDeals is coma separated list that is also a FK similar to DealID. I request...

If 'order by 1 ' is commented/removed, I still get same result set in different order.

In other words wrt to performance, does Between puts the column in sorted order...

Your data might spread into July, August etc. since "Queries resolved,Queries resolved in SLA, Queries resolved out of SLA, Queries resolved in SLA" fixed fields, I would recommend to keep...

As Erland said, above statistics seems ok kind of performance to me with indexes. But if destination database is not operational database and just a OLAP database, then consider adding...

You can pass the rundate dynamically using SSIS package config file.

When you run SSIS package, it first checks the variable/property values in config file. If found any, it will...

Try use CTE and select top 10 from cte. I did not test this myself but believe it should work.

This is as good as 'google Nose' prank....LOL..:-)

Well, I got the solution from msdn. On my windows server, I did below steps:

1. In the reporting services configuration manager, click web service url. Removed the SSL certificate...

Weekly once ~800 records. It should ok to use function at the moment.

Yes, I would consider using TVF if data is significant.

It is an application database used for reporting purposes, where I need to calculate datetime out of two integer columns (till last week, I calculated only date but new requirement...

Thank you very much OPC.Three.

This builtin function msdb.dbo.agent_datetime did the job for me.

Thanks Lynn for your response.

The code you shared works for this example but sometimes integer time column or col B can have values like 93000 (9.30am) or 0 (12...