Search results for query: *

I have a view with a datetime field and I need to eliminate rows that occur within 2 seconds of the first. So for example: ID AcctID EntryTime 1 1 1/2/2010 10:00:00.000 2 1 1/2/2010 10:30:00.000 3 1 1/2/2010 10:30:00.500 * 4 1 1/2/2010 10:30:01.200 *...

I use the Convert function as follows (a little example): SELECT CONVERT(datetime,MyDateField,101) This has always worked. Now if I wanted the British format, I'd put a 103 in the end. That also worked in the past. BUT the weird thing now is that the CONVERT function is expecting MyDateField...

I need to copy several million rows of data from a linked server into a database table. I am a little hesitant to just INSERT INTO xxx (...) SELECT (...) FROM Is this the best way? Are the Export/Import tools more efficient than the above simple query? What about Bulk Insert? I have never used...

I am trying to find the most efficient way to pivot the first two values for every "group by" in a recordset. For example, here is my table: Account Form Date Score 1 A 1/8/07 89% 1 B 2/7/07 95% 1 A 8/3/07 72% 1 A 12/1/07 87% 2...

I have an nvarchar column that is sometimes used to hold numeric data and I wish to pull that data out as real and changing text values to zero. So I wrote a query something like the following: SELECT CASE WHEN ISNUMERIC(TextField)=1 THEN CAST(TextField AS real) ELSE 0 END FROM MyTableI am...

I have a very large table that is basically structured like this:Category Score Type 1 90 0 2 3 0 2 87 1 3 65 0Notice that the Category 2 has two records (of type 0 and 1). What I need to do is select a recordset that excludes all 0-type...

I am a software developer, and I have been given the additional task (opportunity?) of being in charge of scheduling/prioritizing projects for my team. I am temporarily using an Outlook calendar to track everyone's projects and timelines, and am looking for a more permanent solution. I haven't...

Hello, I am new to ASP.NET and I am using a TemplateColumn in a datagrid as follows, but the width property seems to do nothing (really a pain when the image is large):<asp:TemplateColumn HeaderText="My Image"> <ItemTemplate> <asp:HyperLink ImageUrl='<%#...

I have a combo box with databinding to a dataset, but it's datasource should change depending on another field in the dataset. So for example, if the user scrolls to a record and the "Department" field is Quality, then only applicable employees show up in an Employee drop-down. When the user...

Hello, I want to capture the CurrentCell of a datagrid when the user gives focus elsewhere (using the datagrid's Leave event). This works just fine if the cursor was in a populated row, but if the cursor is in a "new" row that does not yet have data, then the CurrentCell property gives me the...

Hello, I tried asking this on the ASP.NET forum with no response, and I believe it's applicable here too. I am making my very first Pocket PC application (VB.NET), and I am using a web service to write data from the device to a database on the server. There will be times the Pocket PC will be...

Hello, I am making my very first Pocket PC application (VB.NET), and I am using a web service to write data from the device to a database on the server. There will be times the Pocket PC will be unable to talk to the web service, and in that case I would like to store data locally until the...

I am creating an application on a Pocket PC where I need to connect to SQL Server directly over a WLAN. I'm not using SQL Server CE to syncrhonize, but just want to do simple read/writes directly to SQL Server. I can ping the server itself just fine, but for some reason I can't make an ADO...

I am making a line graph in RS and I have one Series group and two Value columns (Field1 and Field2, for example). What I want to do is be able to hide one of the data value-series when the user toggles a button. I am able to prevent the value series from actually plotting by typing the...

I have tried adding a simple filter to my report's recordset, but I can't make it NOT filter when blank/null. For example, I want the user to be able to filter by Shift (Shift 1 or Shift 2), but if they leave it blank then it should have no filter... it should show all records. But when I...

Does anyone know if you can alter the date resolution in graphs? What I mean by that is say you have the x-axis as "Date" and you want to change it from Daily to Monthly or Yearly. I know MS Graph has this option, and was wondering if it was in Reporting Services or if I need to group the data...

Does anyone know if you can create multi-select report parameters? So instead of a user filtering by just "Product A" for example, you could select "Product A" OR "Product C" OR "Product F". This is like the difference between a combobox (single) and a multi-select listbox. I usually do this...

JamesLean was voted TipMaster of the Week across all forums, congrats! JamesLean is a major contributor to this particular forum and I truly appreciate his and everyone else's patient answers to our endless questions. Keep up the good work. :)

I would like to have a Listbox with a hidden value member and a visible display member. I have done this with setting the DataSource to a table, for example, but I haven't been able to do this just using the item collection editor screen. I don't want to go through the hassle of setting up a...

Does anyone know if the line graph can have trendlines (a straight line that overlays a series of points, showing the trend of the curve). This is a common feature of Excel, but I can't find it here. I do know that the RS graphs came from Dundas rather than native to Microsoft, so this could...