What I am trying to do is feed in a small string and it will filter some values out for me. This might be easier to do in visual studio than in a TSQL function. Here are some notes on my findings. I am simply feeding in “ABCD” and it will match the 2 letters […]
Microsoft Calls it “by design” or a feature – most others would call it a bug. To keep things simple, if a group is added – it adds a row AND a column. In the current version (which is not accurate) when it is exported to Excel -the last row keeps getting duplicated making the […]
Well, here I go – how to natively (or naively at this point – I just started this) manipulate Sharepoint Lists from SQL Server. I did it! It is not using a linked server (I will get to the bottom of that though) but using an OPENROWSET works. This means that the user needs to […]
When you integrate a site onto its final server – things with windows get hairy. Here are some notes to get out of trouble seeing a 401 for anonymous user? Are your permissions for IUSR set to read, write, execute (ref)? This is for anonymous user. For a dynamic user, then you have to add […]
There are really 2 concepts here which is the reason for the long title. First, adding jQuery to Report Services means hacking 2 install files (.aspx files) of Report Services. If you don’t have someone who has access to the server that is hosting the web pages, it might be hard to get this done. […]