may i know what is the purpose of joining table2 there

and

seems you post only part of your query please post entire query to resolve your issue

hi Eugene Elutin

thanks for your response i think according to you putting a left join is completely wrong approach there, this is what you said, may i right?

well...

anthony.green (11/22/2012)

---

Well Table B has to have a value it its ID Column which exists in Table A you would an inner join.

If you want TableA to TableB then you...

Thanks for your response but what i am going to do is

TableB TO TableA

From your example Every record in TableA is in TableB

when i want to do...

for give me i changed my post previous post

since the column 'Aid' is not null

Then every record in TableB has a Aid which is strictly in TableA

now which ...

dwain.c (11/15/2012)

---

I'm not getting exactly the desired results you posted but maybe this will give you a hint.

;WITH CTE AS (

SELECT TOP 1 ID, TEXT1, aDate,...

Jason-299789 (11/16/2012)

---

I suppose its an 'it depends' answer, your code is ok if you have simple queries, however when you get into complex queries with Multiple paramater combinations it will...

that's awesome, i didn't expect that links

DECLARE @v_TableSize TABLE (

Table_Name VARCHAR(100)

,ROWS BIGINT

...

thanks for the reply

Hi anamika

you are there

you already insert a identity col

instead of starting from 1 just start from 0

and then select the records using the remainder operator

select * from tbl where...

after a long war i found this from the hint from phil

DECLARE @Fpoint INT,@Tpoint INT

SET @Fpoint =25

SET @Tpoint =205

DECLARE @tbl AS TABLE (ID INT IDENTITY(1, 1), LNAme VARCHAR(50), FrmPoint INT,...

for give me phil i think sscrazy is your name, i said that statement to jayanth

These are the inputs

(@Fpoint, @Tpoint)

25,99 - allowed to insert

25,225 - raise a error

125,500- raise a error

25,500 - raise a error

401,500 - allowed to insert

hi SSC

it is the same thing what i did but in a different way

thanks ssCrazy

but i can insert 25-99 this interval because this interval not lies in the above