Forum Replies Created
Viewing 15 posts - 166 through 180 (of 2,452 total)
-
RE: Please help me with a complex SELECT
Hi....a word to the wise....please read this article and respond accordingly...you will be amazed how many tried and tested answers you get....it helps us help you.
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: How can we load more than 6 million records into excel sheet
Phil Parkin - Friday, June 30, 2017 6:54 AMsubratnayak09 - Friday, June 30, 2017 6:47 AMRE: Getting the next future Friday
DECLARE @NextDayID INT = 4 -- 0=Mon, 1=Tue, 2 = Wed, ..., 5=Sat, 6=Sun
SELECT CONVERT(varchar(8),DATEADD(DAY, (DATEDIFF(DAY, @NextDayID, GETDATE()) / 7) *...________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: The Traveling Data Professional
zoobly - Wednesday, June 28, 2017 1:36 AMif you are referring to my pics....then the answer is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: The Traveling Data Professional
Dont really need to go far this summer !......all this within 5 mins
🙂🙂________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Unable to understand the Query Logic
I think that this is the origin of the question, along with the some of the solutionsby Itzik Ben-Gan
http://sqlmag.com/blog/tsql-challenge-reoccurring-visits
http://sqlmag.com/blog/solutions-tsql-challenge-reoccurring-visits________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: What happens when Trial expires?
Fal - Monday, June 26, 2017 4:09 AM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: What happens when Trial expires?
Fal - Sunday, June 25, 2017 6:36 PM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: SUBSTRING and CHARINDEX query.... please help.
Eirikur Eiriksson - Friday, June 23, 2017 12:36 PM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Merging row records where the end date of previous record is equal to start date of next record.
like this ?? ...still need expected results
SET DATEFORMAT DMY;
CREATE TABLE #TestTable
(IDHAAndD VARCHAR(50),
IDClient VARCHAR(50),
IDStay VARCHAR(50),
LocationName VARCHAR(50),
...________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Merging row records where the end date of previous record is equal to start date of next record.
akinwandeb - Thursday, June 22, 2017 10:34 AMRE: Merging row records where the end date of previous record is equal to start date of next record.
me thinks it would be useful if you could please post your expected results.....will save any misunderstanding on your explanation.
Also....are you really storing dates as varchar?
Also....what defines the...________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Create Auto Insert Script - 500k records to load data into sql server
poratips - Tuesday, June 20, 2017 9:31 AM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Create Auto Insert Script - 500k records to load data into sql server
poratips - Tuesday, June 20, 2017 7:28 AM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Rolling 6 Months
you havent provided your expected results in the spreadsheet.......please clarify by reposting with expected results column
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayViewing 15 posts - 166 through 180 (of 2,452 total)
