manoj.ramaiah (5/27/2013)

---

Hi Kingston,

Thanks for your quick reply.

...

In that...

DECLARE@strSQL VARCHAR(1000)

SELECT@strSQL = COALESCE(@strSQL + ',', '')

+ '[' + Depot_Name + '] VARCHAR(100)' + CHAR(13) -- I assumed the column data type to be VARCHAR

FROMDepot

SET@strSQL = ' CREATE TABLE AnotherTable'...

I am not sure if I understand your requirements correctly

But I hope this what is what you want

SELECT*

FROMYourTableName AS YTN -- Replace your actual table name here

WHEREParentIntermediaryPK IS NOT NULL

ANDNOT...

It is quite easy to do this manually.

What is the problem you are facing in doing this?

I am not sure if anybody is going to answer any of your questions

Try searching for articles or resources in Google for these topics and go through them

If you still...

No. You should not be applying all the recommendations given by the DTA without more analysis.

The recommendations may be good but you should decide based on a lot of other...

You will have to drop the existing index and then create the index with the INCLUDED columns

The link below can help you with the syntax to create the index with...

KoldCoffee (5/23/2013)

---

I think the problem in this case was that I am concatenating a string value ie. '.' with a different datatype and everything has to be the same data...

Glad it works for you and I hope you understand what it does 🙂

In case you don't, make sure you understand it by looking up CTE...

Try calling the procedure by passing parameters as Bhaskar had suggested earlier and let us know if the row gets...

What do you mean by "it wont be work"?

Does it give any...

The below link will be useful to you

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Change the below condition

if exists(select departuredate from journey where departuredate<@departuredate)

to

if exists(select departuredate from journey where departuredate>@departuredate)

Change your query like below

select

SomeID

, NewNum = case

when cast(num1 as varchar(10)) is null then cast(num2 as varchar(10))

when cast(num2 as varchar(10)) is null then cast(num1 as varchar(10))

else...