Search results for query: *

I have data similar to what is below. I have duplicates across the 4 grouping criteria that I’ve indicated. I need the one record that is the max value of both the date submitted and time submitted (unfortunately, both varchar data) across the grouping values. So, in the data set I've...

Hello All, Does anyone know a better way to do this? I have a query where there is a one-to-many relationship. For a generic example, one author to many books. I want to write a query where I can have the result like below Author Books ------- -------- John Smith Some Book, Some Other...

am having quite a bit of problems getting this to work properly. I am on a Windows XP Professional SP2 machine trying to connect to Windows Server 2003. I have Sql Server 2005 installed on the Server machine. I also have a local instance on my developer machine. I can use remote debugging to...

I am having quite a bit of problems getting this to work properly. I am on a Windows XP Professional SP2 machine trying to connect to Windows Server 2003. I have Sql Server 2005 installed on the Server machine. I also have a local instance on my developer machine. I can use remote debugging...

Do any of you use a particular product (doesn't have to be free) that has intellisense for Sql scripting in a Sql Server 2000 environment? I'm not talking just color coding syntax and awareness of system entities, but also the ability to know that when I say MyTable[DOT], I get a list of...

Hello all, I have an issue where I have data that I need to group out. It is in a table like the following Name Income ---- ------ Phil 100 Mary 500 Bill 450 Will 45 I need to produce a count of how many people fall in each range, with that range as my left side. I...

I work in an environment that is going to start using nUnit and nUnitAsp for some TDD. The actual tests themselves aren't proving to be much of a problem, but we are running into another issue that is causing division. Our lead developer wants to build a unit test that would be run against a...

tblSituation Id Name 1 Situation A 2 Situation B 3 Situation C 4 Situation D tblPeople Id Name 1 Person A 2 Person B 3 Person C 4 Person D tblIncident Id Time Resolved Name 1 1:00 1 IncidentA 2 2:00 0 IncidentB 3 3:00 0...

A friend of mine is trying to implement a new template on her blog. It works fine in IE, but not in Firefox. If you go to http://www.quixoticpixels.com/sets/naturalist/index.htm you can see the template. The left and right columns will stop having the background color in Firefox after one...

Okay. I have a dataset that has like 20 columns. I need to display the data to the user, without having them scroll horizontally. I don't want to databind a ton of textboxes. I thought about a paging bar, but it seems like that is just for displaying many records, not a record with many...

I have a report that has many subreports contained in it. I passed the database logon to it and it ran fine. Then one day, after an upgrade and some backend realignment (so the exact cause is unknown), the report started prompting me for the odbc logon info. Except it doesn't want any...

Hello. I am using Crystal Enterprise 9 and Reports 9. Our server is Windows 2000 Server. I can use either RAS or CE, but am currently using RAS, because I cannot find a lot of good code for passing parameters to CE without using .Net. All of the code samples that I found do not work...

Hello. I am using Crystal Reports 9. Our server is Windows 2000 Server. I can use either RAS or CE, but am currently using RAS, because I cannot find a lot of good code for passing parameters to CE without using .Net. All of the code samples that I found do not work. Anyway, I need to...