[font="Verdana"]

Have you tried your query this way? It work well for me. This query will return the last History Orders. And you need the first one then just only replace...

[font="Verdana"]

Declare @sql VarChar(MAX)

Set @sql = '{You whole select statement}'

EXECUTE @error = sp_executesql @sql, N'@min_date SMALLDATETIME, @max_date SMALLDATETIME', @min_date,@max_date

Mahesh

[/font]

[font="Verdana"]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6195

Mahesh[/font]

[font="Verdana"]

Set @Temp = 'from Company A,Department B,Manager C'

Select @Temp = substring(@Temp, 6, Len(Temp)-5)

One step added so that finally you will have:

Company A,Department B,Manager C

OK, now have...

[font="Verdana"]

The main difference between Select and Set is you can assign values to multiple variables in a single statement through Select but not with Set. You need to write multiple...

[font="Verdana"]http://www.connectionstrings.com/?carrier=dsn

Mahesh[/font]

[font="Verdana"]Hey... I found the column DOB. It is there in the EMP table 😀

what else you want?

Mahesh

[/font]

[font="Verdana"]Have you tried to execute the Select statement in your SProc and tally the o/p whether it is desired o/p? If o/p data is desired data then your logic is...

[font="Verdana"]

EXECUTE(' declare @a as numeric(6) select top 1 @a= bp_id from bug_posts where bp_bug=4648 select @a ' )

Mahesh

[/font]

Ripal Patel (4/17/2008)

---

Thanks Mahesh Bote ,

My problem gets Solve, now i need same primary key for INSERT statement. means i want Primerry key value of last inserted statement,

If only...

[font="Verdana"]Select {PK Col} From M_Product Where PRDm_Level='A'

[/font]

[font="Verdana"]

t.miecz (4/14/2008)

---

Sorry if the question has appeared before, but I can't seem to find it.

I am trying to update names in my database (i.e. member.name) but there is a foreign...

[font="Verdana"]I havn't work at such high level. My scope ends at programming. However I think, but not sure, this can be done through Replication. Search through google on Replication for...

or like this ...

(Have stolen Tom's Code :D)

Create PROCEDURE [dbo].[usp_ReportGlassStatsWeb]

@StartDate datetime = null, -- Allow a null value

...

[font="Verdana"]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65800[/font]