View R Plots from within SQL Server Management Studio
Describes how to view R plots in SSMS and gives a brief introduction to R plotting
2019-11-29 (first published: 2017-05-08)
5,532 reads
R Plots
RE: T-SQL brain teaser, tricky sum for employee data.
Here is one solution...I do have one extra join to over state my thought process--Join pass for attributes and amount select sum(CD.amount)as amount from check_data CD, --Choose employees and dates for query (select SUB1.emplid,SUB1.payend_dt from --Temp pay (select a.emplid,a.payend_dt from check_data a, ps_job b where a.emplid=b.emplid and b.reg_temp='T' and b.effdt<=a.payend_dt)SUB1 LEFT OUTER JOIN --Regular pay […]
2005-01-18
RE: Getting a Date from DateTime
Scalar UDF's like this are performance killers on larger tables. Compare the results of doing this with a UDF and a single SELECT statement. They should speak for themselves. While you will maybe save some keystrokes (and, hey, I'm completely with you at this point), I think you'll save them in the wrong place.
2005-01-18
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers