Search results for query: *

So my company has finally stepped up from a single SSRS 2008 R2 instance to a clustered SSRS 2014 set of servers. Woohoo! I don't know all the specs for the cluster. I was given the cluster primary node name and am currently working through any changes needed due to the switchover. The most...

So I have a newer T-SQL developer in my company and I am code reviewing his first big set of work for me. The only real big thing I have found in his code is the constant use of the REMOTE hint when accessing linked servers. Sample queries provided below so you can see what I am referring to...

So I have had this process running for some time and thought I had sufficient error handling to catch most of my errors. Over the weekend, I encountered a new error that did not trigger my CATCH block. I am not 100% sure why my CATCH did not report the error and am looking for some help to...

Anyone explain what is happening in the following code? Even an article somewhere that explains why this is happening? Basically, I have a list of courses offered at my company. The system allows ANY characters to be inserted into the CourseCode value. Somehow we have been getting some...

I have been pushed by my management to go to my HR department and have my photo taken to add to our HR database. As of now, my supervisor cannot provide me WHY I must do this. I already have my photo on my company's security badge. I already have my photo added to our internal Lync server so...

I have a database that tracks user's attempts at tests. I need to determine how many days have passed between each test. It should not be that hard, but I just can't seem to find the right combination needed to make it work. I have tried using ctes, sub-queries to get max dates, self-joins...

I haven't posted a question in a while thanks to all the help I have gotten in the past here but I am now stuck on a problem and would like to ask for some help. Must be my end-of-week brain drain catching up with me. :) The university I work for has a student population of about 10,000...

I have a column in on table that the users are copying and pasting bulletted lists from M$ Word. These bullets are stored in the column as three special characters (•) and I want to replace them with • But trying to use SQL REPLACE, I get: Msg 8116, Level 16, State 1, Line 1 Argument...

I am having trouble with parsing a string of data. The data is semi-free flow - meaning there is no defined order, but the items in the column are (mostly) formatted. This is a trailer text column in a database I am trying to write a parser for to remove most of this ambiguity. Given the...

This is not my area of expertise, but is probably pretty easy...If someone can help out it would be greatly appreciated. Given the below query: select pst.cnfrm_prod_grp_sub_prod_trans_type_assn_id , pst.cnfrm_prod_grp_code , st.cnfrm_sub_prod_type_code , st.cnfrm_trans_type_code ...

I have a requirement to search a table containing a VARCHAR(1000) column and return a "comparison value" to a given string. SOUNDEX and DIFFERENCE do not provide a detailed enough comparison value. Anyone know of any other methods for doing something like this? A good example of a fuzzy...

I am working on a Rules Engine for a portion of logic that needs to be editable by the users. This Rules Engine will be dynamic enough for the users to be able to change a lot of the logic without IT intervention. I have the following procedure that gets me the combined logic for one rule...

I have a query that returns a set of records in about 3 seconds. This is acceptable based on my requirements. But I am having to do some further filtering on the UI side that I would like to do in SQL instead which can be lengthy depending on the result set. I believe the overall length of...

ASP is not my forte...I am a Windows programmer by training. But I was asked to create an ASP application and have run into a problem. I have been searching for an answer and nothing I have found works for me. I have a web page with two DIVs on it. They need to occupy the same place and I am...

I have a small problem I just can't seem to find an answer to. I have an application that needs to have the ability to drag and drop emails into it. Information from the email is going to be stored. I have a working test, minus late binding. We have three versions of Outlook currently being...

I have been researching graphing options for our Smartphone development. Up to this point, i have always told my users: "No, I can't do that" simply because I did not have the resources necessary. I have obtained a small budget from my boss to find and implement a graphing solution. I have...

-- I work in a company of 600 employees. -- We have a 6-member IT staff, including the IT Director. -- The IT Director is only two steps down from the president of the company -- I am the senior of two developers. -- My skill sets include strong VB.Net/C#, moderate ASP.Net, strong SQL, moderate...

I have a report I have been working on and I have decided to leverage the ability to use a custom DLL for some of my code requirements. So I created the DLL, saved it to the Bin directly on the Server and the PrivateAssemblies directly on my development box. The report previews perfectly on...

I have a bound DataGridView with a bound ComboBoxColumn in it. This CombobBoxColumn is a list of delivery routes for our company. I want to restrict this ComboBoxColumn to not allow duplicate routes to be selected in more than one row. I am having a tough time in figuring a way to do this...

I have requirements to begin accessing our cubes in SSRS reports. I can do basic MDX queries to access the cube, but I am having difficulties in formatting the data as I need it in the SSRS reports. The data from the MDX queires does not seem to expose itself in clear columns and the like to...