Search results for query: *

We currently have a few packages that need to be refactored to work more efficiently as per our DBA's. However, they have only provided snippets of the offending code. While we are now going back through TFS to see if we can identify the offending packages (a manual and laborious process for...

I have a page that I am using with JQuery/Ajax (at this point, I'm not sure what is what) that works fine up until the point that I attempt to do a postback from a dropdown box. Then, it blows up on me with the following message: In short, I have a main page (Welcome) that then calls three...

A wee bit of searching has helped me to figure out how to use optional parameters in a stored procedure. However, I'm having some issues because of the manner in which I had to build the procedure and the joins. In short, I need to build a new reporting section of trouble tickets for an...

I have a text file that I have to modify in Excel (in order to renumber the rows after some were removed). I then have to resave the file back to space-formatted text so that each row is 186 characters long. However, my original file somehow truncated so that it is only as long as the actual...

I would like to return my data from one function into another which will populate a drop down list. I was just testing this and am pretty sure that it has to do with the variable being passed into the getData function (see below in red), but I'm not seeing exactly where I'm going wrong...

My error message is Server: Msg 8624, Level 16, State 3, Line 1 Internal SQL Server error. I get it when I attempt to run a view that I have created. The code in the view works fine independently but not inside the view itself. I will be using this with another view later to create a new set...

One of my users pulled some Excel formatted reports from ASP and apparently saved them as separate tabs in an Excel spreadsheet - but saved them as .htm files. Now, when she attempts to open the file, she receives the message indicated in the subject header of this thread. I'm fairly certain...

It has been a long time since I last worked with Access reports. I think this is something that I can do but I am not certain. Any shove gentle shove in the right direction would be greatly appreciated. I have to create a report that contains data from several different queries. I made the...

I recently was asked to create a new field in our database and did so without any major issue. It is a bit field so the data is either 0 or 1. However, I screwed up when I populated the data and reversed them so that 1 = FALSE and 0 = TRUE. What I'd like to do is reverse them. However...

Ok, I spent an hour or two (or more ;-)) banging my head on the desk trying to figure out how to draw a line on a form when it was loading only to discover that it is not possible (because the form is not yet loaded at that time so it is not possible to draw something at that point). So, as a...

I have the following code that works fine when I test it in Query Analyzer: SELECT TOP 100 PERCENT OH.prpty_id, OH.floor_cd, OH.co_cd AS OldCo, OH.cst_ctr_cd AS OldCC FROM SNAP.dbo.T_OCCPT OH INNER JOIN SNAP.dbo.V_CURR_STAT S ON OH.prpty_id = S.prpty_id INNER JOIN SNAP.dbo.T_PRPTY P ON...

I've encountered a problem with a script that I shamelessly stole borrowed from markdmac (faq329-5798) to validate the users who may access an intranet site that I built. I don't have a thorough background in AD but I know enough (to just be dangerous). But my understanding is that the problem...

I'm teaching myself the basics of .NET (VB.NET) at the moment and have encountered something that doesn't make sense and am hoping someone can point out what I'm clearly not seeing. I've created a datagrid and bound some data to it, but I cannot see the datagrid when I attempt to open the page...

I am trying to modify a reporting format in order to add a new row that will be used to add a report description. In some cases, the data that will be shown on the screen will exceed the horizontal length of the report so I figured that I would rowspan=2 to account for instances where it may go...

Ok, I've come across something that I don't quite ken. I'm hoping someone can explain to me why this should be the case. I have stolen borrowed a script from markdmac and used it to query against a global group in Active Directory. However, if I use the Option Explicit command at the top of...

An interesting article... Thoughts? http://www.foreignaffairs.org/20051101facomment84602/kenneth-neil-cukier/who-will-control-the-internet.html ------------------------------------------------------------------------------------------------------------------------ "Men occasionally stumble...

I'm using Crystal Reports 8.5 and have come across something that I have found distracting (to say the least!). I was trying to copy and paste text from one textbox to another. So, I would copy the text from textbox A and then delete it (using the "Delete" key). But when I attempted to then...

While helping someone with their beginning level English class, was referred out to this site (which is apparently where their teacher is getting her information). It may seem very basic on some levels, but considering some of the writing I've seen from otherwise very competent individuals as...

I have a query that I was asked to create that would retrieve a list of all future rent obligations. Everything was going (more or less) ok until I realised that certain results were being double-counted. The way my query is structured it works ok provided the rent starts at the beginning of...

Ok, we have a difference of opinion going here in my office on a survey we are preparing to send out. One of the sentences has been questioned as to being grammatically correct and, this being the forum that it is, I thought could help us to resolve the debate. The sentence is as follows: We...