Search results for query: *

In MS SQL Server 2014 SP 2, I have a Communication table that is used by many areas of our website to store user notes, comments, and certain email text. The Comments column is defined as nvarchar(4000) and I need to change it to nvarchar(max). The table has over 250k rows with numerous...

I'm downloading an Excel file in ASP.Net that works in Firefox and IE, but not Chrome. A link on a calling page opens this page in a new window which generates a spreadsheet, downloads it, then closes the window. protected void Page_Load(object sender, EventArgs e) {...

I am beginning a new project and, against my better judgement, we are using SSRS rather than Crystal Reports. I have never been impressed with SSRS but I have use it in a couple of situations where it was just easier to install and let users run reports from the server. But now I am developing...

I have always tried to keep a separation in my coding (N-tiered development it used to be called; now in .Net it is MVC) but it has recently come up that it can be "better" to store some code inside database tables. This seems REALLY hard to troubleshoot and / or maintain. Does anybody...

I have a stored procedure that returns the Store, Product Category, Units Sold, & Sales Dollars, but each is reported in different charts. StoreID ProductCategory FYQuarter Units Sold Sales Dollars 1198 Gloves 2013 - Q1 1 176 1198 Hats 2012 - Q4 18 4410 1198 Shoes 2013 - Q1 8 2460...

Here is the code; it's pretty simple: var sURL = "Edit/?iAction=2&sGroup=" + sGroupName; $('#sGroupNameIsValid').load(sURL + ' #div_Results', function(){}); It works just fine... ...until I add a space in the sGroupName variable. The user enters some text for a new data item. All I want...

We have a really long, complicated stored procedure and, for tracking its progress, we have added PRINT statements showing the current location of the execution. Like this: -- Do long SELECT into temp table PRINT 'Location 1' -- Update temp table via loop PRINT 'Location 2' -- Sequentially...

We are revising our data structure from 15 tables with 255 columns each to 1 (or possibly 5) tables with 6 columns each. Pivoting all this data -- or actually, UNpivoting -- is creating a lot of rows and therefore a lot of transactions. On a couple of occasions we filled up the transaction log...

This does not seem like it should be that hard, but for some reason I'm stuck. We have a file server that houses images from several applications and our web server needs to display them. When I add this code, I get a broken image icon. <asp:Image ID="imgPhoto" runat="server" Width="140px"...

I'm trying to write a counter that uses the alphabet as the count like this: A B ... Y Z AA AB ... AZ BA BB .... ZY ZZ AAA AAB Here's my current (incomplete) code. It's a recursive function where you pass in a counter value and it's converted to a letter via Chr(). It's close, but at the...

We are implementing a full-text search in our database and the goal is to be as search engine-like as possible for the user. Unfortunately, it has been difficult finding clearly written information about some of these things involved in the full-text search. Right now, I am trying to understand...

I'm new to the Create User Wizard so I've done some searching and haven't found the answer to this. I am happy with the way the wizard works and the info it collects, but we want to be in control of who is allowed to log into our site. Ideally, if the user entered his own data and we were...

Please tell me what I am missing here.... Why would my Employees object be Null where the datasource is set? (This is in the initial page_load.) Partial Class _Default Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles...

Well, I've got this object based on clsAttachment. This class reads from the Attachments table in the database and tracks the links to the files stored on the server. One of the data fields is IsMissing. If the database says the file is there, but it's really not, IsMissing needs to be set to...

I've got a stored procedure (SQL 2008) that is supposed to update all the tables in the database (unless explicitly named) when the table meets the criteria. I won't go into why; trust me, it's a necessary tool. Anyway, it has worked fine until we added a computed column to one of the tables...

What is the easiest way to serialize an image (or document, for that matter) via VB Script to pass it into a stored procedure to be saved in a table? The data type is varbinary(MAX). I'm just looking for the ASP side, not the SQL. Thanks.

I am moving some Access tables into SQL Server and I want to find out how many mdbs on the network link to each of these tables. (Desktops too, if possible.) Any ideas? Thanks.

I'm doing a simple database validation. To avoid duplicate names, I want to see if the First and Last names are in the database and tell the user before writing the data. So I've got an ASP page that works fine. It returns the count of records where FName like 'xxx%' and LName like 'yyy%'...

I'm doing a simple database validation. To avoid duplicate names, I want to see if the First and Last names are in the database and alert the user before writing the data. So I've got an ASP page that works fine. It returns the count of records where FName like 'xxx%' and LName like 'yyy%'...

If I have a ASP page with multiple functions in it and I want to call one via AJAX, can I do that? Or do I have to have a separate ASP for the call? E.g. My javascript looks roughly like function getAjaxResults() { var oXmlHTTP = getXmlHttpObject(); var sURL =...