asm1212 (8/6/2012)

---

I apologize, I forgot the formatting does not reflect how it was typed in the message...

I remember now that you have to create custom code to reflect what I...

to which question(s) are you you replying "yes"?

krishna-1031038 (8/6/2012)

---

Hello,

I have Inventory table

productID | warehouseID | qtyAvail

A | Loc1 | 100

A | Loc2 | 20

A | Loc3 | 250

A | Loc4 | 1000

User enters quantity...

vs.satheesh (8/6/2012)

---

Hi All

I am facing Following interview Question.Its very intresting. I have one table that table...

just to check...please run

dbcc useroptions

does

2012-07-29 00:05:28.819

work for you?

set dateformat MDY

go

select CONVERT(datetime,'2012-07-22 12:30:12.784')

set dateformat DMY

go

select CONVERT(datetime,'2012-07-22 12:30:12.784')

go on...give it a crack:-)

please give example of what you want to convert

another method here:

http://sqlbump.blogspot.co.uk/2010/06/sum-of-digits-of-number.html

pls dont multiple post

seems that if you google

"Create a stored procedure named spBalanceRange that accepts three optional parameters."

you may find what you are looking for.....

if not or confused pls post...

seems that if you google

"Create a stored procedure named spBalanceRange that accepts three optional parameters."

you may find what you are looking for.....

if not or confused pls post back

have been seeing how the code would run an a bigger data set.

pls feedback on whether this gives what I think you are looking for

regards

USE [tempdb]

GO

--== CREATE SOME DATA TO...

try this....it should work where you have a variable number of rows for each group

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]') AND type in (N'U'))

DROP TABLE...

"One dB to rule them all,

One...