I have a table with following structure ID Name L_No F_Name FL_No M_Name M_No 1 Jhon 111 Micheal NULL Geena Null 2 Sheen 222 Junior 456 Tina 234 3 Tina 333 George 7896 Beena Null .. .. .. .. ...more >>

I need help on SQL 2000. i will appreciate if you can give me any good tips or solution. Question is:- My WEB Application is going to send Array of list/String list/List of value in comma delimiter to SQL 2000 Store Procedure. for e.g [tutor,electrician,painter,driver,mentor,......................more >>

Hi! I have data in the following manner: period course1 course2 4 NULL Eng 4 NULL Math 4 Phys NULL 4 Chem NULL Is there any way I can show this data this way? period course1 course2 4 Phys Eng 4 Chem Math 4 P...more >>

Is there any way to mark up an XML format file so that BCP / OPENROWSET knows that the flat file contains a header, which should be ignored on import (and ideally included on export)?...more >>

Hi Experts, I got a simple SSIS package getting data from one Oracle DB to another Oracle DB (I did not do any transformation, and using Native OLEDB\MS OLEDB Provider for Oracle). The total rows is around 3 millions. But it took forever to run it. The average loading speed is 5000 rows/minute...more >>

I am attempting the case expression below and am getting an Oracle error stating "Error signaled in parallel query server. Invalid number". Here's the expression: CASE WHEN VARIABLE_A = 'R' THEN 0 WHEN VARIABLE_A = 'C' THEN NVL(NUMBER_1,0)+NVL(NUMBER_2,0) END AS TOTAL The idea is I only...more >>

I have two asp.net 2.0 pages.. almost identical. each updates a seperate table in the same db. The tables have a datetime field defined the same datetime way. The asp.net pages use a grdivew to display the date and a formview control to insert or edit the data. One table takes 11:59:59 PM and sa...more >>

I am a newby sql user/programmer on SQL Server 2005 using a UK client and set up a default value of 1/1/1800 for a non null datetime DateOfBirth column in my Users table. Colleague phoned me up in concern yesterday. Since setting up the database, 1/1/1800 has been written fine in the DOB col...more >>

Hi, whenever I setup SqlDependency to use the new SQL 2005 QN feature, things work for the first two minutes. The OnChange event is triggered whenever the datasets change in any way. After 120 seconds, SQL Server decides on it's own not to issue any more OnChange events. I thus have to keep ...more >>

HI folks, I have a bit of a problem. I am using the Union on 11 Tables which total around 30,000 records. If I look at each one individually and tot them up thats what I get. But with the UNION, i only get aroun 9000 if I use a count(*) , any ideas ? SELECT TOP 100 PERCENT * FROM ...more >>

Ok, its been a while since I did dba stuff like this. Back in 7.0, I think there was a general rule of thumb, that if you're table had lots and lots of inserts, you would set the page size to something closer to 50% (aka, decrease the default values), if you were going to run alot of INSERT's....more >>

I've got a game, the table structure is this: Systems systemID (key) x (int) y (int) Planets planetID (key) systemID (fk to systems.systemID) occupied (bit) I need a query that selects all systems that do not have an occupied planet (occupied=0) within an X,Y range of 5. Any tho...more >>

I've got a program which imports IIS log files into sqlserver 2000. The log files are about 200 meg but when importing them the memory usage goes up to maximum which is around 1GB. Performance of the server becomes pretty much zero and even after it is complete I have to shutdown sqlserver to ...more >>

Hello, I sometimes reference tables in other databases, and was wondering if there is any performance penalty. For example, consider these two situations: --- situation A --- USE database1 SELECT mycolumn FROM table1 --- situation B --- USE database2 SELECT mycolumn FROM datab...more >>

Hello, I am writing a SQL procedure and I need to check if in MyTable there is only one record where field [NAME] = @Name or if there is more then one. How can I do this? Thanks, Miguel ...more >>

Hi, I have a problem with this query please help Update Query:- INSERT into invoice_data(account,inv_date,po_no,inv_amt,inv_no,sent_date) values ('aon',Convert(datetime,'13/06/2006'),'98765',324132.56,'134123','pavan') Error: Server: Msg 241, Level 16, State 1, Line 1 Syntax erro...more >>

Generally, I have this on my ASP front end script <% set rs1 = conn.execute("select countries from setup") countries = rs1("countries") arr = split(countries,";") %> <select name="countryofbirth" id="countryofbirth"> <option value="">--Select--</option> <% For i = 0 to uBound(arr) %> <o...more >>

Hello, I created a delete procedure which is working but I still have a problem. When I delete a localized content from dbo.by27_ContentLocalized given a ContentName and ContentCulture I want to check if this is the only record in ContentLocalized for that ContentName. If it is then I al...more >>

In a single select statement is it possible to auto increment a number in a column in a select statement? So I'd be selcting the columns and also an auto incrementing number... select col1,col2, autonumberhere from tablename col1, col2, autonumber ddd, eee, 15 ggg, rrr, 16 yyy, qqq, 17 ...more >>

In SQL 2005 is it possible to send email notifications to multiple people? As I would like to send email notifications on failure to DBAs and on success to Data Analysts. ...more >>

Hi everybody, I'm trying to port a web-application from Linux/PHP/MySQL to Windows/PHP/MS-SQL. This webapp uses the packages "MDB2" and "DB_NestedSet" from the PEAR framework. I have problems getting the next free id of a sequence. These queries are sent to the SQL-Server: <code> // I...more >>

I tried using the LEFT function against one of our servers to retrieve the 1st 20 characters of a column per record. Can someone tell me how I can accomplish extracting only the 1st 20 characters of a field per record? The field contains about 300+ characters, but I only need the 1st 20. Thank...more >>

"User", fix your clock ...more >>

I am processing some data in a query where it was initially assumed that all data would be numeric, even though the field was char. As one might imagine, some character data has shown up, and therefore needs to be removed. What is the best method of quickly identifying the offending rows for rem...more >>

Hi, I hope someone has an idea how I might do this. I have a table that shows goods recieved. Simplified it looks something like this: Part Date QTY Vendor --------------------------------------------------------------------- 12345 01/02/2006 ...more >>

Hi All I have a couple of tables and the scripts to recreate the table with sample data is given below. The main table Unit is associated with components stored in another table. There will be many components for a Unit like Gear, Generator, Blades. There will be installed dates in the c...more >>

I have a set of relationships, similar to a tree but its not (its a "Acyclic Directed Graph" similar to a bill of materials). Full DDL is below, however the relationships table stores parent node, child node and sequence. The sequence refers to the child nodes position relative to other children...more >>

hi..suppose there is only one textbox in the form and one command button... can anyone tell me how can i setfocus of textbox when page is load? should i do that by java script?please send me coding how to do that? and can anyone tell me how can i send mail to the group of user?and how can i...more >>