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...
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)
July 27, 2017 at 5:15 am
I am struggling to grasp on how to calculate in SQL where there is a...
July 27, 2017 at 5:05 am
any reason why you dont/cant reinstall SQL Server 2014 Express... why the must have 2012 version?
July 26, 2017 at 11:32 am
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...
July 25, 2017 at 12:36 pm
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
...
July 25, 2017 at 11:01 am
July 25, 2017 at 9:53 am
July 25, 2017 at 9:42 am
can you post create/insert exmaple data scripts for the table [WH_Stores].[dbo].[TONYS]?
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...
July 22, 2017 at 9:24 am
July 22, 2017 at 5:52 am
July 22, 2017 at 4:32 am
Viewing 15 posts - 106 through 120 (of 2,452 total)