Viewing 15 posts - 1,246 through 1,260 (of 2,452 total)
New Born DBA (5/6/2015)
SELECT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 8, 2015 at 9:52 am
http://www.sqlservercentral.com/Forums/Topic1318719-1291-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 7, 2015 at 8:38 am
WHERE Modified_Date >= (DATEDIFF(s, '19700101', GETDATE())- 2678400)
what is the data type of "Modified Date"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2015 at 11:40 am
So, what is the where clause attempting to filter?
the last 31 days...?????
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 6, 2015 at 10:21 am
anusha.guntupalli (5/5/2015)
In one of the tables I am looking at :MAX Value: 82860
MIN Value : 24480
could this be seconds past midnight?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2015 at 1:41 pm
what are the max and min values of column "Time"?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 5, 2015 at 1:36 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 4, 2015 at 3:27 am
Uday3421 (5/3/2015)
------------------------
1 08 09 10 -
------------------------
2 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 3, 2015 at 12:49 pm
Sam Garth (5/1/2015)
CREATE TABLE #Courses (RandomID INT, PersonID INT, CourseTitle NVARCHAR(200), CourseDate DATETIME)
INSERT INTO #Courses
VALUES
(1,1,'Maths','2015-05-01 15:30'),
(2,1,'Science','2015-05-01 15:30'),
(3,1,'Science','2015-05-01 15:30'),
(4,1,'Science','2015-06-01 15:30'),
(5,1,'Maths','2015-04-01 15:30'),
(6,2,'Science','2015-05-01 15:30'),
(7,3,'Science','2015-05-01 15:30'),
(8,4,'Science','2015-05-01...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 1, 2015 at 9:33 am
venkatagari85 (4/28/2015)
Id Name mobileno
1 abc 9123456789
2 xyz 9876543210
3...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 30, 2015 at 2:52 am
Hi Luis
I think that it would be easier for you to explain what you require if you can provide some create table / insert data scripts that describe your problem...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 26, 2015 at 8:19 am
I really am not sure if I understand the business rules....we have only been presented with three rows.
am also concerned about the comment re "previous or next segments".....how are these...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 26, 2015 at 6:27 am
Alan.B (4/22/2015)
SELECT
ab.AddressCode,
AddressInstance = ROW_NUMBER() OVER (Partition by ab.AddressCode ORDER BY (SELECT (NULL))),
ab.PostCode,
AddressLine1 =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 22, 2015 at 11:38 am
Hi Chris
here is an alternative method....works on your sample data....probably need a bit of tidy up
WITH cte as (
SELECT
ROW_NUMBER() OVER (order by (select null) ) -...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 22, 2015 at 9:33 am
karthik82.vk (4/10/2015)
I just updated the post. its a typo from my end.
I tried LEFT JOIN and FULL JOIN however i am getting only one row.
the category table has...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 10, 2015 at 8:35 am
Viewing 15 posts - 1,246 through 1,260 (of 2,452 total)