Search results for query: *

Instead of having a group listed in the far left column can I simply display it similar to a header and have it change when the group changes? Meaning... have the first related column under it and not beside it. All columns will still have their static heading including the one I want under...

The below query snippet works. It uses an existing temporary table and saves the maximum date for each claim in another table variable. Then, using another temporary all the TotalPaymentAmount values are summed from a table where the date is greater than the maximum date for each claim (from...

I've been tasked with figuring out how to create reports using SQL 2012. This is new to our team and me of course so please excuse the potentially stupid questions\comments. I have found out the following and would appreciate any feedback\corrections\additions: There is Report Builder and...

Okay, I give up, I've tried to find the actual documentation that explains how to install MVC2 on a VS 2008 SP1 with no luck. I downloaded everything from http://www.microsoft.com/en-us/download/details.aspx?id=22079 and the ASP.NET-MVC-2-RTM-Release-Notes.doc does not explain how to actually...

I've tried two ways to check for null and neither work: I have a menu control and when I click a link the below event is fired. I tried two ways to check for null and neither work. Can someone please help? protected void MenuItems_OnMenuItemClick(object sender, MenuEventArgs e) {...

I am creating some ASP.Net pages using C#. I want to create a class which will be used by other cs files. What I think I want to do is pass the this keyword as a parameter. The reason for this is I want to use .Controls.Add(new LiteralControl in each class using the current cs file. I've...

In SQL Server 2008 R2 I changed the data type of a field and when I clicked Yes to change that field a message box appeared stating: "The following tables will be saved to your database. Do you want to continue?" It listed the table I changed plus another table I did not touch. I chose No...

I just started a new job and have been given the task of creating a VB6 executable which someone will eventually install on a client's machine in another location (out of state). This exe will probably replace an exe which we originally installed so I imagine any other pertinent files are...

From what I have found it appears a DDL is nothing more than a bunch of SQL statements which can consist of one of the following statements: ALTER CREATE DISABLE TRIGGER DROP ENABLE TRIGGER TRUNCATE TABLE UPDATE STATISTICS You simply combine the different queries in a sql file and execute...

Hi, I've been trying to use SMO in VB.Net 2010 to do a backup of a 2008 SQL Server DB. I tried this a while back could have sworn it worked the first time but not sure. Anyway, below is my code (I have to read the ini file due to an other legacy system we're using): Private Function...

Is there a way to read an XML file and load its contents in a treeview in VB.Net 2.0 and then edit the treeview and update the xml file? I've been using a text file because I cannot get XML to work. I found XElement but I think it's for a later version.

Over a year ago I installed SQL Server 2005 Developer Edition on my laptop with Windows 7. For some reason SQL Express also go installed which is part of the issues I'm having. Whenever I try to do anything sometimes it expects SQL and other times SQL Express. Because I'm so smart I stopped...

This is using ASP.NET 3.5 on a Windows 7 Professional OS. I'm not using the internet yet, just my laptop. When I click on the Security tab of the Web Site Administration Tool I get the following message: There is a problem with your selected data store. This can be caused by an invalid server...

In my programming experiences I've always accessed\executed stored procedures from my programs. I can only imagine LINQ being useful for small\quick programs or web pages where you may not be using stored procedures. Everything I've looked at involving LINQ just appears to be another way or...

Is it possible to run a stored procedure from one database and have it execute on other databases and servers? What I have is a SP which deletes records after a certain time. We have SIT, UAT and production environments on different servers. If this is possible can you please share what I...

Question: When inserting a new record, should I first do a Select statement to make sure the record doesn't already exist? Or should I write the code to warn the user if the Insert statement comes back with an error. I wrote code for the former but another programmer said to do the later...

I want to create a text file of a stored procedure. Here is some code: exec master..xp_cmdshell 'echo USE MyDB > c:\file.txt' exec master..xp_cmdshell 'echo SET ANSI_NULLS ON >> c:\file.txt' exec master..xp_cmdshell 'echo GO >> c:\file.txt' exec master..xp_cmdshell 'echo SET...

I tried to record a Macro to change my Word Options (like I could in 2000) but the recorder does not recognize my changes. I can record other macros. Can anyone help?

I have a form where I have a treeview control. I have classes in that project where I want to change the text of a node in that form. Apparently I have to use get\set and I've spent way too many hours trying to figure this out. Code in the form: TreeNode JobNode = new TreeNode(); //...

I'm trying to create a table in SQL 2005 and I want to allow duplicate keya but the Ignore Duplicate Keys is disabled. I've tried re-creating the table but that does no good. Please help.