Viewing 15 posts - 1,831 through 1,845 (of 2,452 total)
asm1212 (8/6/2012)
I remember now that you have to create custom code to reflect what I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 2:46 pm
krishna-1031038 (8/6/2012)
yes
to which question(s) are you you replying "yes"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 11:15 am
krishna-1031038 (8/6/2012)
I have Inventory table
productID | warehouseID | qtyAvail
A | Loc1 | 100
A | Loc2 | 20
A | Loc3 | 250
A | Loc4 | 1000
User enters quantity...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 11:12 am
vs.satheesh (8/6/2012)
I am facing Following interview Question.Its very intresting. I have one table that table...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 8:00 am
just to check...please run
dbcc useroptions
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 4:36 am
does
2012-07-29 00:05:28.819
work for you?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 4:12 am
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')
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2012 at 1:38 am
SomewhereSomehow (8/5/2012)
...Who will make a proof test?
go on...give it a crack:-)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2012 at 9:04 am
leonie6214 (8/5/2012)
Does anyone know how to convert varchar datatype to datetime in TSQL?
please give example of what you want to convert
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2012 at 7:07 am
another method here:
http://sqlbump.blogspot.co.uk/2010/06/sum-of-digits-of-number.html
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 5, 2012 at 5:10 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 4, 2012 at 10:37 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 4, 2012 at 10:35 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 4, 2012 at 10:18 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 4, 2012 at 6:02 am
Sean Lange (8/3/2012)
This reminded me of an image Lowell posted when somebody was trying to make a single procedure that could do everything...[see attachment]
"One dB to rule them all,
One...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2012 at 1:58 pm
Viewing 15 posts - 1,831 through 1,845 (of 2,452 total)