by Jason L Froebe on February 15, 2013, no comments
The most intuitive way to write a comparison of two tables and spit out the # of rows that are the same involves a left join: select ‘Investment’ as TableName, count(*) as RowCount from Investment_A a, Investment_B b where a.col1 = b.col1 AND a.col2 = b.col2 AND a.col3 = b.col3 AND a.col4 = b.col4 This [...]
by Jason L Froebe on November 28, 2011, no comments
Position Responsibilities POSITION OVERVIEW The Technical Support Analyst for SunGard InvestOne’s global clients will be responsible for hands-on technical troubleshooting and support across a variety of platforms for a broad customer client base. This position is part of a global team with local responsibilities from 8am to 8pm. The Analyst will be responsible for Tier [...]
by Jason L Froebe on February 4, 2009, no comments
I’ve been sick the past few days, so I have been hitting the “Stumble” button a lot on my laptop. Last night I ran across a very interesting blog post by Daniel Spiewak on his Code Commit blog: This is a question which is fundamental to any ORM design. And really from a philosophical standpoint, [...]
by Jason L Froebe on July 9, 2008, 3 comments
create function ok (@boolean bit) returns varchar(2000) as declare @output_string varchar(2000) select @output_string = case when @boolean = 1 then "" else "not " end set @output_string = @output_string + "ok" return @output_string end Msg 156, Level 15, State 2 Server ‘DBADEV1′, Procedure ‘ok’, Line 7 Incorrect syntax near the keyword ‘end’. I’m trying to [...]
by Jason L Froebe on January 24, 2008, one comment
From the Sybase Workspace 2.0 team: Thursday, February 14, 2008 1:00 pm EDT / 10:00 am PDT Join us on Valentine’s Day and you will learn how to: Visually debug stored procedures and triggers Visually create and edit tables, stored procedures and events Navigate and manipulate database objects in the enterprise Export and import database [...]