Database

FirstPrevNext

Re: please help - database design michal.kreslik5-Dec-06 3:24 michal.kreslik 5-Dec-06 3:24  Yes, that's one of the options I was talking about, but is that really a systematical solution to implement a distinct table for each data type? I don't think so. There must be a way to "join" the individual datatype tables' values' relations in one master table. Thanks, Michal SQL Select query for different combination of arguments steve_rm4-Dec-06 14:05 steve_rm 4-Dec-06 14:05  Hello, SQL Server 2005, VS 2005 I have a checked list box. The user will select a combination of staff members from the checked list box. This will display these staff members and their tasks that they have to do. Also I have a additional 4 check boxes on the form, where the user can select the prority to be shown. i.e from the checked list box, check staff members 1, 5, 8, 12. and display the prority as high. There 4 prority check boxes (low, normal, urgent, and very urgent) All are dislayed in a datagrid on the form. Currently there a 15 staff member that will be in the checked list box, but this could grow as more stafff members are added. My problem is Writing a select query for each of the possible combinations of staff members and the prority. I could end up writing many many select queries for each combination. Is there a simple way to write a select query for this type of situation? Many thanks in advance, Steve Re: SQL Select query for different combination of arguments Eric Dahlvang5-Dec-06 9:47 Eric Dahlvang 5-Dec-06 9:47  steve_rm wrote: My problem is Writing a select query for each of the possible combinations of staff members and the prority. I could end up writing many many select queries for each combination. Definitely DO NOT create a select statement for each possible combination. Build your select statement dynamically. When the user clicks the refresh button (or whatever), then put together a criteria list of staff member IDs and priorities. Select * from Staff inner join StaffTask on Staff.StaffID = StaffTask.StaffID where Staff.StaffID in(1,5,8,12) and StaffTask.Priority in ('urgent','very urgent') Be sure to check this out: SQL Injection Attacks and Some Tips on How to Prevent Them[^] --EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters Reading SQL return messages from .NET iammudman4-Dec-06 4:49 iammudman 4-Dec-06 4:49  I'm trying to gather statistics from multiple queries to gauge our database performance. So, I dropped a "Set statistics io on" (with matching off) at the top of my query. In Sql Management Studio, the results of the query come back in the Results tab, while the IO statistics come back in the Messages tab. How can I gather the IO statistics (the messages) from .NET with the provided SQLCommand/SQLDataAdapter/etc. classes? I tried pausing my test app just after the query ran and looking through all the involved objects for the IO messages but couldn't find anything. Re: Reading SQL return messages from .NET Scott Serl4-Dec-06 6:32 Scott Serl 4-Dec-06 6:32  The SQLConnection object fires an InfoMessage event that you must catch. Parsing very large file-low virtual memory error amnaahmad4-Dec-06 1:04 amnaahmad 4-Dec-06 1:04  Hi Iam parsing very large text files-around 50MB each using split function. I populate a dataset from it and then use sqlBulkCopy to insert the records in the datbase. But im getting a low virtual memory error and it is taking a lot of time? Any other approaches-help? Amna Re: Parsing very large file-low virtual memory error Frank Kerrigan4-Dec-06 3:11 Frank Kerrigan 4-Dec-06 3:11  Have you tried using a DTS job to do the same thing ? Blog Have I http:\\www.frankkerrigan.com Re: Parsing very large file-low virtual memory error amnaahmad4-Dec-06 18:11 amnaahmad 4-Dec-06 18:11  No i havent. But if it is more efficient i would surely try it. Thanx Re: Parsing very large file-low virtual memory error amnaahmad4-Dec-06 18:34 amnaahmad 4-Dec-06 18:34  iam using sql server 2005 express edition. It does not have the DTS option. Any other suggestions? Re: Parsing very large file-low virtual memory error Scott Serl5-Dec-06 7:17 Scott Serl 5-Dec-06 7:17  Look at BULK INSERT in the SQL help file. If your file is in a compatible format, then this will probably be your fastest option. Otherwise, just send it one record at a time using a SQLCommand object; a stored procedure will be slightly faster than sending a bunch of INSERT statements. The DataSet object is probably taking up a lot of your memory. I routinely load text files of up to about 1GB one record at a time. I have a bunch of validation for each record, so it is very slow, but even with the validations, it loads at about 1000 records per second. ODBC Connection and Excel Spread Sheet Cristoff4-Dec-06 0:56 Cristoff 4-Dec-06 0:56  Sorry to bother you with this question. I'm totally new to this and I don't know what I'm doing I want to use an Excel spread sheet as a database. Any ideas how to do it? I think I have to use ODBC but I have no idea how to write the appropriate connection string and how to write a query? I've been googling for some time but I cannot find any information on this topic. Where should I look? Re: ODBC Connection and Excel Spread Sheet Frank Kerrigan4-Dec-06 3:13 Frank Kerrigan 4-Dec-06 3:13  Search codeproject for Excel ADO. It may be better to use Access if you can, then use Excel to pull updated data from the access db. Blog Have I http:\\www.frankkerrigan.com Re: ODBC Connection and Excel Spread Sheet Cristoff4-Dec-06 4:04 Cristoff 4-Dec-06 4:04  Thank you for your advice. I've found some information that might be useful. I want to make an application that uses a simple database that does not need SQL server, Access or MS Office installed on the computer. I currently use Excel to do my work but I wan't to be able to do it without it. Re: ODBC Connection and Excel Spread Sheet Frank Kerrigan4-Dec-06 5:52 Frank Kerrigan 4-Dec-06 5:52  You don't need MS access or office on a machine to use an access database with a website. Blog Have I http:\\www.frankkerrigan.com Re: ODBC Connection and Excel Spread Sheet Scott Serl4-Dec-06 6:53 Scott Serl 4-Dec-06 6:53  Using an access database is preferable to Excel, and you don't need Access or Office installed. But if you must use Excel, here is an example connection string for you: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path\MyExcelFilename.xls";Extended Properties="Excel 8.0;HDR=NO;IMEX=1;ImportMixedTypes=Text" I can't remember what IMEX is, but HDR is whether the first row of data is a header row or not. Re: ODBC Connection and Excel Spread Sheet Cristoff5-Dec-06 1:33 Cristoff 5-Dec-06 1:33  Thank you very much for your advice. I've found a sample on this site that seems as an excellent starting point. I'll think about the access database too but creating an sample access database (or anyone) does require MS Access? Re: ODBC Connection and Excel Spread Sheet Scott Serl5-Dec-06 7:35 Scott Serl 5-Dec-06 7:35  I have not created Access databases fom code in a long time, but it can be done. I think you have to add a reference to ADOX library. Yes, here is a link http://www.freevbcode.com/ShowCode.asp?ID=5797[^] to an example. Need help in writting a sql2000 query tmiku4-Dec-06 0:07 tmiku 4-Dec-06 0:07  hi, i have table let in the following format Col-A col-B col-C col-D col-E Row-1 1 2 3 4 E1 Row-2 1 2 3 4 E2 Row-3 1 2 3 4 E3 Row-4 1 2 3 4 E4 so i need the output in the format Col-A col-B col-C col-D col-E Row-1 1 2 3 4 E1/E2/E3/E4 i cannt able to find the way to write the SQL for it Re: Need help in writting a sql2000 query Kamalonline44-Dec-06 20:05 Kamalonline4 4-Dec-06 20:05  I think there is no option to do this using queries.You have to go for the cursors. Kamal Re: Need help in writting a sql2000 query Polymorpher4-Dec-06 23:54 Polymorpher 4-Dec-06 23:54  SELECT Col-E FROM tblSomething WHERE Col-A >= 1 AND Col-A <=4 Pablo Sometimes I think there's no reason to get out of bed . . . then I feel wet, and I realize there is. Connection of SQL server using IP address priyank_ldce3-Dec-06 23:50 priyank_ldce 3-Dec-06 23:50  Hi, I am using ODBC to connect my VC++.NET application to connect to SQL server. I can connect any server in the LAN using server name. Is it possible to connect remote server over internet using IP address? Currently I am using connection string like "connStr = "Driver={SQL Server};Server=server_name;Database=db_name;Trusted_Connection=yes";" Any suggestions? Thanks in advance. Re: Connection of SQL server using IP address Frank Kerrigan4-Dec-06 3:15 Frank Kerrigan 4-Dec-06 3:15  Yes you can but the TrustedConnetion will likley not work. You have to use a SQL username and password. Please bear in mind that exposing SQL server or another db to the internet is highly dangerous. Blog Have I http:\\www.frankkerrigan.com Re: Connection of SQL server using IP address Stathread4-Dec-06 16:14 Stathread 4-Dec-06 16:14  Follow the below link. This website is a nice reference. http://www.connectionstrings.com/ Error while accessing SqlBulkCopy class honey1233-Dec-06 22:19 honey123 3-Dec-06 22:19  Hi, I am trying to convert Excel Data to SqlServer for that i am using SqlBulkCopy class under System.Data.SqlClient namespace. While definin the instance for SqlBulkCopy class i am getting error ... c:\inetpub\wwwroot\ConvertXLStoSQL\WebForm1.aspx.cs(47): The type or namespace name 'SqlBulkCopy' could not be found (are you missing a using directive or an assembly reference?) It's very urgent please help me to come out from this problem if posible. Thanks, Honey Re: Error while accessing SqlBulkCopy class Frank Kerrigan4-Dec-06 3:17 Frank Kerrigan 4-Dec-06 3:17  Try and use DTS as it is fairly easy to connect EXCEL via dts. I do it all the time with no issues. Blog Have I http:\\www.frankkerrigan.com

Last Visit: 31-Dec-99 18:00     Last Update: 22-Sep-24 19:26 Refresh ᐊ Prev1...1735173617371738173917401741174217431744 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.