Hi Oldhands

Thanks alot "J Livingston SQL"

You wrote smart query . But I need this result. It means I need All orderitem records with their final status :

Like this :

IdOrderIdItemIdCountItemPayable

1001...

Sorry Yes

Delete from Table_ReturnORDItem

INSERT [dbo].[Table_ReturnORDItem] ([Id], [ReturnORDId], [ItemId], [Count], [ReturnORDItemPayable]) VALUES (1, 500, 8880, 2, 50)

GO

INSERT [dbo].[Table_ReturnORDItem] ([Id], [ReturnORDId], [ItemId], [Count], [ReturnORDItemPayable]) VALUES (2, 500, 8881, 1, 150)

GO

INSERT [dbo].[Table_ReturnORDItem]...

I Must Started For every User From Its Register Date !!!!

(And Inserted Date from That Date to now - For every User)

No Befor I have a cluster that I remove it ( But I think I removed Un complete)

any suggestion?

--(-- After create tables ..)

--No !!

--We have a view That is base.

-----------------------------------------

Create View VW1

As

select Id,ProductName,IsActive,[dbo].[fn_Str_GroupIDs](TBL_Product.Id) As GroupId,

CONVERT(XML,

...

Thank you jeff

I will read it and

I will act according to instructions.

Thank you . I Should Test it with another fields. in real environment.

Ok

Thank you :w00t:

This is script .

But , We produce a XML Field with all Group ID for a product.

But search in a XML filed is very Slow.

(such this format : ProdGroups.exist(''/main/TBL_..[@id= "2"]'')...

Sorry

I dont get it.

This is Wrong method Or standard ?

I got time for for this Queris :

about 5 sec for first part and about 3 sec for counting (page numbers)

is...

Thank you all

And

Thank you David Burrows

I didnot Know Row_Number() Befor this.

We want :

Does the lowest ProductConfig Price, have Gift ?

for example :

Prod1 : (samsung)

- ProdConf1 (samsung-Model1) - Has Gift

...

How do you use Group By ?

Please help me

Yes I Have only one primary and one secondary .

For Automatic failover and Automatic redirection , Should I use create qurume (share storage) ?

Another Question ?

What is...