Viewing 15 posts - 1,606 through 1,620 (of 2,452 total)
do you have any other columns available that hold date info ...eg yyymmdd?
also what are you expecting to happen when the end time is two or more days after the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2013 at 6:26 am
have you tried grouping by cc.cn instead of hostname?
if you cant make it work, then we need details (create table / insert data scripts) for the other tables...in MS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2013 at 11:37 am
SELECT convert(varchar(10), DateAdd(yy, -5, GetDate()),120)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2013 at 10:58 am
do you mean like this (based on my set up code)
SELECT shost_name, COUNT(DISTINCT time_stamp) AS visits
FROM MSA
GROUP BY shost_name
ORDER BY shost_name
if not...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2013 at 10:50 am
uravindarreddy (6/23/2013)
Hi Livingston,Anyway would datetime columns in these type of scenario help a lot?
Regards
ok...thanks for update.
was thinking that maybe a running balance by date may have helped...but can't see that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2013 at 7:53 am
famaash (6/23/2013)
Hi,I really appreciate your assistance. I am using MySQL with PHP..
This forum is Microsoft SQL Server.
here is some code that may give some ideas...remember this code is for Microsoft...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 23, 2013 at 7:51 am
does TFI_PERSON have a date of birth column stored as datetime format?
why this
[DOB_DAY] [int] NOT NULL,
[DOB_MONTH] [int] NOT NULL,
[DOB_YEAR] [int] NOT NULL,
rather than DOB (datetime) ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2013 at 12:29 pm
http://msdn.microsoft.com/en-us/library/ms190690(v=sql.105).aspx
try this
if OBJECT_ID('tempdb..#t') is not null
drop table #t1
SELECT TOP 100000
IDENTITY(INT,1,1) AS N INTO #t
FROM Master.dbo.SysColumns sc1
SELECT count(n) FROM #t
--==================================================
if OBJECT_ID('tempdb..#t1') is not null
drop table #t1
SELECT TOP 100000
IDENTITY(INT,1,1) AS N...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2013 at 8:35 am
this article may help you...(J Moden)
http://www.sqlservercentral.com/articles/T-SQL/62867/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2013 at 8:07 am
maybe something along these lines will help you get started
SELECT
CALLNO,
TITLE,
STUFF ( (
SELECT ',' + ARTIST
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2013 at 7:41 am
are the tables that you describe really as simple as you make them out to be?
I would have thought for these type of transactions there would have been at least...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 22, 2013 at 6:51 am
starter......
SELECT TOP 10000
CustomerID = CAST(Abs(Checksum(Newid()) % 90 + 1) AS INT),
ProdID = CAST(Abs(Checksum(Newid()) % 900 + 1) AS INT)
INTO ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2013 at 12:10 pm
does the following help you?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2013 at 9:47 am
Edward-445599 (6/18/2013)
Bhaskar.Shetty (6/18/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 18, 2013 at 7:18 am
nidhi.finance1 (6/16/2013)
My requirement is to show this data in this format in a view to show asset value on 3 days i.e. Today, before 7 days, before 30 days:
L_Limit ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 16, 2013 at 7:46 am
Viewing 15 posts - 1,606 through 1,620 (of 2,452 total)