Viewing 15 posts - 496 through 510 (of 2,452 total)
Luis Cazares (7/26/2016)
SELECT
Custmer,
location,
SUM(CASE WHEN [Date]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 26, 2016 at 7:33 am
maybe?....though my YTD is different than yours ?!?
SET DATEFORMAT DMY
CREATE TABLE #yourtable(
Custmer INTEGER NOT NULL
,Date ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 26, 2016 at 7:16 am
join Details to Names twice.....once for CEO. second for Manager
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2016 at 12:58 pm
fergfamster (7/21/2016)
Thanks, I dont really want to post 15 files you guys need to review to get an answer. ill figure it out.
seems you havent figured it out yet ..so...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2016 at 11:40 am
maybe ??
WITH cte AS (
SELECT NAME,
VALUE,
ROW_NUMBER() OVER(PARTITION BY NAME ORDER BY (SELECT NULL)) rn
FROM...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2016 at 10:11 am
randy.moodispaugh (7/20/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 20, 2016 at 6:41 am
Muhanned Maayeh-445298 (7/19/2016)
J Livingston SQL (7/19/2016)
Nice solution 🙂 thank you I will have to try out with our different conditions but looks very promising
If you have "different conditions" then why...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 20, 2016 at 4:15 am
amirtharaj.j (7/19/2016)
I have 2 tables. Please see the attached screen shot for data. I need to join these 2 tables with
schoolID and pick top 3 students of each school...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 10:46 am
Nice solution 🙂 thank you I will have to try out with our different conditions but looks very promising
If you have "different conditions" then why did you not post them...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 8:38 am
maybe, as a start?
WITH CTE AS(
SELECT ShiftID, UserID, StartTime AS tm
FROM Shifts
UNION...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 8:15 am
JaybeeSQL (7/19/2016)
J Livingston SQL (7/19/2016)
maybe?
DECLARE @f1 AS VARCHAR(100)= 'The Double Cross (01/Mar/13)';
SELECT CAST(LEFT(RIGHT(RTRIM(@F1), 10), 9) AS DATE);
No that just returns a single date, and one I (would) need to embed...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 5:33 am
maybe?
DECLARE @f1 AS VARCHAR(100)= 'The Double Cross (01/Mar/13)';
SELECT CAST(LEFT(RIGHT(RTRIM(@F1), 10), 9) AS DATE);
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 4:47 am
please read this and then repost.
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
and why have you got duplicate identical rows in the student table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 19, 2016 at 4:20 am
NineIron (7/14/2016)
I read Jeff's article. Way over my head. My data is relatively small so, the fnSplitString function works pretty quick.
why use something that is "prettty quick" when you can...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2016 at 7:18 am
Ed Wagner (7/14/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2016 at 7:08 am
Viewing 15 posts - 496 through 510 (of 2,452 total)