Viewing 15 posts - 106 through 120 (of 2,452 total)
please post table create scripts for your two tables Product & SalesOrderDueDateReport
some sample data insert scripts for both tables and your expected results for this sample data.
someone...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2017 at 8:38 am
you have posted in Sql 2005 forum....is this correct?
(I ask because it may restrict some solutions)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2017 at 5:15 am
I am struggling to grasp on how to calculate in SQL where there is a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 27, 2017 at 5:05 am
any reason why you dont/cant reinstall SQL Server 2014 Express... why the must have 2012 version?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 26, 2017 at 11:32 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 1:20 pm
varchars as empty strings
CREATE TABLE #yourtable(
ID INT NOT NULL
,Shipto varchar(25)
,Description VARCHAR(25)
,ItemN INTEGER NOT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 12:36 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 12:27 pm
here's some sample code ...I think it does what you are asking
reference http://sqlmag.com/t-sql/last-non-null-puzzle
CREATE TABLE #yourtable(
ID INT NOT NULL
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 11:01 am
INSERT
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 10:20 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 9:53 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 9:42 am
can you post create/insert exmaple data scripts for the table [WH_Stores].[dbo].[TONYS]?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 25, 2017 at 9:21 am
not sure I understand your question.
are you saying the code errors (doesnt work)
or that it works but you are not getting the results you require?
why dont you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2017 at 9:24 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2017 at 5:52 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2017 at 4:32 am
Viewing 15 posts - 106 through 120 (of 2,452 total)