Viewing 15 posts - 931 through 945 (of 2,452 total)
Ed Wagner (1/22/2016)
jasona.work (1/22/2016)
J Livingston SQL (1/22/2016)
Ed Wagner (1/22/2016)
J Livingston SQL (1/22/2016)
Ray K (1/22/2016)
whereisSQL? (1/22/2016)
Ed Wagner (1/22/2016)
crookj (1/22/2016)
djj (1/22/2016)
Ed Wagner (1/22/2016)
djj (1/22/2016)
J Livingston SQL (1/22/2016)
Luis Cazares (1/22/2016)
whereisSQL? (1/22/2016)
crookj (1/22/2016)
Ed Wagner...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 22, 2016 at 11:13 am
Ed Wagner (1/22/2016)
J Livingston SQL (1/22/2016)
Ray K (1/22/2016)
whereisSQL? (1/22/2016)
Ed Wagner (1/22/2016)
crookj (1/22/2016)
djj (1/22/2016)
Ed Wagner (1/22/2016)
djj (1/22/2016)
J Livingston SQL (1/22/2016)
Luis Cazares (1/22/2016)
whereisSQL? (1/22/2016)
crookj (1/22/2016)
Ed Wagner (1/22/2016)
VillainJoker
Laugh
last
longest
Yard
Front
Back
End
Start
up
down
town
City
limits
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 22, 2016 at 10:46 am
Ray K (1/22/2016)
whereisSQL? (1/22/2016)
Ed Wagner (1/22/2016)
crookj (1/22/2016)
djj (1/22/2016)
Ed Wagner (1/22/2016)
djj (1/22/2016)
J Livingston SQL (1/22/2016)
Luis Cazares (1/22/2016)
whereisSQL? (1/22/2016)
crookj (1/22/2016)
Ed Wagner (1/22/2016)
VillainJoker
Laugh
last
longest
Yard
Front
Back
End
Start
up
down
town
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 22, 2016 at 10:41 am
Luis Cazares (1/22/2016)
whereisSQL? (1/22/2016)
crookj (1/22/2016)
Ed Wagner (1/22/2016)
VillainJoker
Laugh
last
longest
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 22, 2016 at 8:34 am
not sure what version of Sage 300 you are running
but this table def for ICIVAL shows transdate as date
http://sage300.guru/AOM55A/ICIVAL.HTM
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 22, 2016 at 6:51 am
here is a start
https://msdn.microsoft.com/en-us/library/ms189461.aspx
am trying to find the source that demonstrates the efficiency of using "unbounded preceding"...I have it somewhere <grin>
will post back if I find it
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 11:24 am
ok...which bit?
is it the "CASE" statement or the "SUM OVER".....or ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 10:56 am
ssc_san (1/21/2016)
Thank you J Livingston SQL! It worked.
thanks...but do you understand how?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 8:39 am
I do not see any transactional dates to determine an order......do you want all Bills to show before all Payments in a month?
EDIT....moving on with a possible solution
SELECT *,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 8:10 am
Hi......if you could provide some scripts that give table structure / sample data / expected results (based on sample data)...then that will help us all.
http://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
January 21, 2016 at 8:02 am
have you read this ....may help as additional source
http://www.sqlservercentral.com/stairway/72401/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 21, 2016 at 7:58 am
michaeleaton 36224 (1/20/2016)
There should always be at least one AccountCallbacks.CallbackDate...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 20, 2016 at 3:18 pm
possibly may get you started?
use TEMPDB;
SET NOCOUNT ON
CREATE TABLE #stockm(
productcode INTEGER NOT NULL
,QOH INTEGER NOT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 20, 2016 at 11:35 am
deja vu
http://www.sqlservercentral.com/Forums/Topic1696588-3077-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 19, 2016 at 11:04 am
can be found on this page (I used Google to find it)
http://msftdbprodsamples.codeplex.com/releases/view/55330
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 18, 2016 at 12:09 pm
Viewing 15 posts - 931 through 945 (of 2,452 total)