[font="Verdana"]Hi Jack,

I am facing this problem in SQL Server 2005 as well as in SQL Server 2008. Please let me know if you have any idea on this.

Thanks,

Mahesh[/font]

[font="Verdana"]Yes Jeff, I have noted that. Any ways Thanks 🙂

Mahesh[/font]

[font="Verdana"]Try this.

Create Table dbo.SeqNum

(

AccountNbrInt

,CreateDateDateTime

)

Go

Insert Into dbo.SeqNum

Select 59961, '01/05/2009' Union All

Select 59961, '01/06/2009' Union All

Select 59961, '01/07/2009' Union All

Select 32187, '01/05/2009' Union All

Select 32187, '01/06/2009' Union All

Select 22195, '01/10/2009' Union All

Select...

[font="Verdana"]Thanks Greg. I have missed to rename the Task but the step. So the conflict was. Anyways. thanks again.

Mahesh[/font]

[font="Verdana"]You have to use Dynamic SQL in SProc, shown below

Create Proc dbo.usp_Update

(

@table VarChar(25)

,@param1 VarChar(25)

,@param2 VarChar(25)

)

As

Begin

Begin Tran

...

[font="Verdana"]First execute the select statement separately with execution plan on. Find out where query is taking too much time to execute. Fix it and then try to insert.

Mahesh

[/font]

[font="Verdana"]Absolutely it is not possible. Instead user User defined function[UDF]. You can call UDF in select statement.

Mahesh[/font]

[font="Verdana"]

GilaMonster (2/11/2009)

---

Only when the inner query contains a...

[font="Verdana"]This can be done through Job Scheduling. The same discussion can be found @ http://www.sqlservercentral.com/Forums/Topic653497-145-1.aspxHowever I am totally agree with Lowell.

Let us know the complete details.

Mahesh[/font]

[font="Verdana"]When Inner query is joined with Outer query, it is called co-related query. and the relation is called as query co-relation

Mahesh[/font]

[font="Verdana"]

Vijaya Kadiyala (2/6/2009)

---

HI Mahesh,

You have provided partial solution, i.e. converting rows into Columns. But his requirement is slightly different. i.e Convert a Column which contains concatenated string into multiple columns....

[font="Verdana"] simple example for PIVOT:

CREATE TABLE #temp123

(

Country varchar(15),

Variable varchar(20),

VaribleValue int

)

Go

INSERT INTO #temp123 VALUES ('North America','Sales',2000000)

INSERT INTO #temp123 VALUES ('North America','Expenses',1250000)

INSERT INTO #temp123 VALUES ('North America','Taxes',250000)

INSERT INTO #temp123 VALUES ('North America','Profit',500000)

INSERT...

[font="Verdana"]

Always follow:

Begin

Begin Transaction

Update /...

[font="Verdana"]PIVOT operator will help in this case. For more information refer BOL

Mahesh[/font]

[font="Verdana"]Let us know in details what exactly you are trying to do?

Mahesh[/font]