Very good question, thanks for shsring

some Confusion..

In the question no where it is mentioned that SQL Server 2014 is running database compatibility level 110

if the database compatibility level of SQL Server 2014 was set to...

Try below code

DECLARE @OddRows TABLE

(

Oddvalue VARCHAR(50)

)

INSERT INTO @OddRows

SELECT '002849617 00009' UNION ALL

SELECT '002960330 00009' UNION ALL

SELECT '003181242 00009' UNION ALL

SELECT '003701140 00009' UNION ALL

SELECT '003789064 00009' UNION ALL

SELECT '003794168 00009'...

Do you have index on Source table?

Are you copying all data or you have some where clause while selecting from Source table?

Are you running the package from a SQL Job...

Note: both #temp and #temp1 should be same structure

or both select statements should return homogenious data.

create procedure testunionall

as

begin

select * from #temp

union all

...

Generally, in any product table, we will have a column called ReorderQuantity, which will say that if your available quantity is less than or equal to ReorderQuantity then you need...

Write CTE

check below link for example on CTE

http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER-2008

In SSRS, you can have a drop down, and set Datasource as a table(As wendy mentioned, create a table with all your values), you can set property of the drop...

Remove "SET NOCOUNT ON" and try to execute you command

you cannot pass parameters to View

For parameterized views please check below link

http://msdn.microsoft.com/en-us/library/c11kd98s(v=vs.80).aspx

are you replacing <SERVERNAME> with your server name right?

Can you please check the syntax try to print the @cmd and check.

Its good that Microsoft has started Garbage Collection in SQL Server aswell,

My question is this Garbage Collection enhancement is started from which version of SQL Server?

Started this week with nice question, looking for many more question like this.

try using isDate() function.

or

try to convert the string using Convert function then check with isdate function.

That worked perfectly Thanks Jason