tag:blogger.com,1999:blog-53804243016828504622024-03-08T13:49:47.635-08:00The Inverted Computer GeekA blog to keep all the trivial pursuit type knowledge I've learned about computers in one placeimnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-5380424301682850462.post-73694435283100479242009-04-23T17:45:00.001-07:002009-04-23T17:45:13.160-07:00How to create InfoPath form Web Part Pages in SharePoint 2007This wonder gem was put together by Nick Grattan. How to Host Microsoft InfoPath Forms in SharePoint 2007 Web Part Pages Follow his instructions and you will be able to embed your InfoPath form as a web part. I wanted to create a web part page that was not part of the main site.  Following the document Nick created I was able to create a full page form that closed once the end user clicksimnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-73353152166280823472009-04-23T07:30:00.001-07:002009-04-23T08:58:59.299-07:00This form template is browser-compatible, but it cannot be browser-enabled on the selected siteCheck if the default “Form Templates” option in appearing under “View all site contents” page. If it is not enabled by default, then you can follow this following steps. If "Office SharePoint Server Enterprise Site Features" is enabled but we don't see the default "Form Templates" on the "View all site contents" page, then you should use the following steps.imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-7983607128335757092009-04-23T07:12:00.001-07:002009-04-23T07:12:36.154-07:00Use an InfoPath form that submits data to a restricted SharePoint Form Library?Background info: I have a need to allow all active domain users access to submit a form but only certain members of a department are allowed to review the results. Interesting dilemma. Not much out there on the web for this specific request – I’ve looked and looked. I didn’t want to have to write (or more realistically have my Dev dept write) a bunch of code to make an area private. I’m not a imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com1tag:blogger.com,1999:blog-5380424301682850462.post-63280520446500239242009-04-21T21:57:00.000-07:002009-04-23T06:36:16.822-07:00Shhh dont wake the sleeping giantI really need to start posting here.I have a new monster sleeping in my head. Two actually. SharePoint and its close friend InfoPath. I inherited SharePoint thx to work letting the main admin go and had no backup. InfoPath came next mainly due to me taking a SharePoint class (so I know kind of what Im doing) and InfoPath was mentioned.I now have 3 projects around InfoPath forms and making imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-26960748530551851452008-10-23T11:03:00.001-07:002008-10-23T11:10:59.740-07:00INNeed to remember that when wanting to allow end users to pick multiple parameters to include an IN statment!!!gotta use IN (@PARAM) to handle multipleExample:WHERE a.value IN (@PARAM)imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-85454492203846410892008-10-01T14:09:00.000-07:002008-10-01T14:10:19.641-07:00Convert date time in a QUERY! (not changing a table)CONVERT(datetime,CONVERT(varchar(10),GETDATE(),101))Example in useConvert (char(10),bc.sxbc_next_billto_dttm,101) AS sxbc_next_billto_dttm, imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-74992013396623953322008-04-28T15:10:00.000-07:002008-04-28T15:12:06.535-07:00Case Statement for PivotsCase statements I created to show some Row information in Columns.CASE cpl.ProductLineCode WHEN 'LP' THEN cpl.Multiplier ELSE 0 END as LPMultiplier,CASE cpl.ProductLineCode WHEN 'DP' THEN cpl.Multiplier ELSE 0 END as DPMultiplier,CASE cpl.ProductLineCode WHEN 'CQ' THEN cpl.Multiplier ELSE 0 END as CQMultiplier, Totaling amountsSUM (CASE cpl.ProductLineCode WHEN 'LP' then uf.Amount ELSE 0 END) as imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-46876790184093869442008-04-28T14:39:00.000-07:002008-04-28T14:42:13.423-07:00Case Statement adding descriptionCase statements I created to add an actual description in place of a integer value Devs used.CASE b.Status When 1 then 'Pending' When 2 then 'Submitted' When 3 then 'Rejected' When 4 then 'Posted' When 5 then 'Processed' When 6 then 'Confirmed' Else '0'End as 'Status',CASE c.AnniversaryMonth WHEN 1 THEN 'January' WHEN 2 THEN 'February' WHEN 3 THEN 'March' WHEN 4 THEN 'April' imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-26137182918513688512008-04-23T21:24:00.002-07:002008-04-23T21:25:48.320-07:00Count() FunctionIve seen it used but never used it myself. I did have the need to use it today!InputSELECT COUNT(*) AS num_custFROM CustomersResults num_cust ----------- 5AnalysisIn the example above, Count(*) is used to count all roes, regardless of values. The count is returned in num_cusMy select statement:SELECT count(cus_cd)FROM dbo.customerWHERE (cus_status = 'A')I returned the number of active customersimnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0tag:blogger.com,1999:blog-5380424301682850462.post-91534770964609027622008-04-23T21:24:00.001-07:002008-04-23T21:24:43.739-07:00First PostFirst off let me welcome you to this blog. I created this to post techno-babble and interesting thinks and factoids found and sent to me by friends. Im now including a possible wide assortment of SQL codes I find to help my noob brain. Comments, advise, teachings are most welcome. Rudeness will not be tolerated and such comments will be deleted.imnvertedhttp://www.blogger.com/profile/17862448904139398553noreply@blogger.com0