hi

let me tell u clearly the manager siva only get commison

when the member levelnumber is 1 if...

this is code which was made

DECLARE @tblMembersRelation TABLE (

[MembersRelationID] [int] IDENTITY(1,1) NOT NULL,

...

sorry lynn still now my problem was not get over i solved 75 % i unable complete level state ...

the problem was solved by myself itself

jeff i tried this to divide level but i am not getting Memcountonthatday properly and if i place @memberid =8

also it was showing...

yes u are correct jeff now only i just watched thats

for level i just made the table like this

i am not getting the level ...

plz tell me how i can change assign value o during Sunday and Tuesday with out assigning value as 50 or 100

how...

this is also function providing same result

create function dbo.generateDates(@startdate date, @enddate date)

returns @dates table(dates date)

as

begin

while @startdate<@enddate

begin

...

thanks Lynn Pettis ; makes the difference

AND ALSO TELL ME IF I ADD ANOTHER COLUMN AS VAR CHAR (10) DATATYPE

CREATE TABLE [dbo].[tblPlotInfo](

[ProjectId] [int] IDENTITY(1,1) NOT NULL,

[PtId] VARCHAR(10) NOT NULL,

[DimensionA] [decimal](4,...

THIS IS THE TABLE

CREATE TABLE [dbo].[tblPlotInfo](

[ProjectId] [int] IDENTITY(1,1) NOT NULL,

[DimensionA] [decimal](4, 2) NOT NULL,

[DimensionB] [decimal]((18, 4)) NOT NULL,

[DimensionC] [decimal](4, 4)) NOT NULL,

[DimensionD] [decimal](4, 2) NOT NULL,

[ActualPrice] [decimal](18, 2) NULL

)

INSERT...

i used a cross apply function before where condition in the select query

after cross apply function

and i want to check whether...

hi SQL Kiwi

thanks a lot i didn't

use except still now thanks a lot for ur job ...

CREATE TRIGGER AfterInserttb1

ON tb1

AFTER INSERT

AS

BEGIN

SET NOCOUNT ON;

...