[font="Verdana"]

Both 1 and 2 are correct in MHO.

I should of went with my instinct, and chose the 1st option, but I rethought it too much I guess.

Anyone else agree...

[font="Verdana"]Can you tell us, why you need to check the values in first(Parent) table? What exactly you are trying to do?

While records get inserted into second (Child) table, it...

[font="Verdana"]

For more information, refer...

http://www.connectionstrings.com/?carrier=sqlserver

Mahesh

[/font]

[font="Verdana"]

Post some code from SProc so that we can dig around.

Mahesh

[/font]

[font="Verdana"]

Declare @strSQL VarChar(Max)

declare @count int

set @count = 0

Select @count = @count + 1, @strSQL = (Case When @strSQL Is Null Then '''' + DateValue + ''' as DateName1' Else @strSQL...

[font="Verdana"]

The same way you drop table. i.e. Drop Table {Temp Table}

You must have forgotten to drop then. Make a habit tp Drop such table after their use. Also check whether...

[font="Verdana"]I guess, you must be trying to fetch the record before commiting it. Do you have explicit transaction used in your back end code? If so, commit the record after...

Try above code and confirm.

By the way, have you tried my previous post? Also have you tried to debug the routine? If...

[font="Verdana"]

Andras Belokosztolszki (4/21/2008)

---

vipul (4/19/2008)

---

I wnat to create a small application like querry anlyzer in which i want to need parse the query. so any one know please tell me wich...

[font="Verdana"]

Select Convert(VarChar, Getdate(), 109) As Current_Date

Mahesh

[/font]

[font="Verdana"]Vipul, as per my knowledge we can not directly use such DLLs. Even I don't know how SQL Server parses the query and SQL Server has such DLL as well....

[font="Verdana"]

Means you are generating next Id, BoardNo. by the way, why are you passing Tablename as a parameter?

Try this ...

Select Max({Field_1}) From {Table}

Mahesh

[/font]

[font="Verdana"]

I think you haven't been through the URL given to you. You would have been got idea...

[font="Verdana"]Query Optimizer choose best suitable execution plan for a query on its own. So generally it is recommended not to use Join hints in a query.

Mahesh[/font]

[font="Verdana"]If I am not wrong, do you want something like this ...?

SELECT ProductId

,ProductDescription

,Sum(Quantity)

,Sum(QuantityOutstanding)

,StandardPrice

FROM Products INNER JOIN dbo.Inventory

ON dbo.Inventory.Product = dbo.Products.Product

WHERE QuantityOutstanding >0

GROUP BYProductId

,ProductDescription

,StandardPrice

I think you must not in need...