PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
SELECT TOP 100 PERCENT dbo.Transactions.[Date] AS [Trans Date], dbo.Card.Name, dbo.Transactions.TransTotal, dbo.Transactions.TransNum, dbo.Transactions.AcctNum, dbo.Card.User1, dbo.Transactions.CostCode, dbo.Transactions.DebitAccount, dbo.Card.CardNumber FROM dbo.Transactions INNER JOIN dbo.Card ON dbo.Transactions.Card1 = dbo.Card.CardNumber WHERE (dbo.Transactions.[Date] = GETDATE()) ORDER BY dbo.Transactions.[Date] DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Running total between 2 sql tables in Sql||6||45|
|Using rowversion for incremental load of datawarehouse.||12||31|
|How do I find out to see if there is any open transaction in DB2 database ?||2||28|
Join the community of 500,000 technology professionals and ask your questions.