Viewing 15 posts - 1 through 15 (of 46 total)
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...
September 1, 2016 at 2:55 pm
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]...
August 31, 2016 at 4:58 am
I Must Started For every User From Its Register Date !!!!
(And Inserted Date from That Date to now - For every User)
February 25, 2015 at 5:32 am
No Befor I have a cluster that I remove it ( But I think I removed Un complete)
February 25, 2015 at 2:28 am
--(-- 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,
...
February 24, 2015 at 1:58 am
Thank you jeff
I will read it and
I will act according to instructions.
February 23, 2015 at 3:52 am
Thank you . I Should Test it with another fields. in real environment.
February 21, 2015 at 3:48 am
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"]'')...
February 21, 2015 at 2:32 am
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...
February 17, 2015 at 10:40 pm
Thank you all
And
Thank you David Burrows
I didnot Know Row_Number() Befor this.
February 17, 2015 at 1:17 am
We want :
Does the lowest ProductConfig Price, have Gift ?
for example :
Prod1 : (samsung)
- ProdConf1 (samsung-Model1) - Has Gift
...
February 17, 2015 at 12:43 am
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...
February 14, 2015 at 4:32 am
Viewing 15 posts - 1 through 15 (of 46 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy