Want to know the latest news and articles posted on SQLTeam.com Forums - Latest posts?
Then subscribe to their feed now! You can receive their updates by email, via mobile or on your personal news page on this website.
See what they recently published below.
Website title: SQLTeam.com Forums
Is this your feed? Claim it!
hi
hope this helps
solved = yes
why am i doing this ? .. much better easier to understand
Mateen please help me out and confirm this
;WITH x AS ( SELECT *, ROW_NUMBER() OVER(PARTITION BY trans_date ORDER BY time_portion) rn FROM @t WHERE status IN ('01','02') ) SELECT a.trans_date, CASE WHEN a.status='01' THEN a.time_portion END AS timein, ...hi
hope this helps
solved = yes
why am i doing this ? = different way =using join= perhaps better performance wise ???
SELECT distinct PIR1.* FROM Purchase_Invoice_Results PIR1 LEFT JOIN Purchase_Invoice_Results PIR2 ON PIR1.InvoiceNo = PIR2.InvoiceNo AND PIR2.Source = 'PO' WHERE PIR1.Source = 'PO' OR (PIR1.Source = 'INV' AND PIR2.InvoiceNo IS...hi
hope this helps
create tables (click for more details) insert data (click for more details) DECLARE @Cols NVARCHAR(MAX), @RowTotal ...hi
hope this helps
create sample data (click for more details)t-sql query
-- Build calendar inline using a tally (numbers) table ;WITH Calendar AS ( SELECT DATEADD(DAY, n, MinDate) AS ServiceDa...