Summary: We're using sql server 2005 and when running our etl tool the server acts strange. Uptill now we have had no problems what so ever. Today when running...
Summary: Greetings Maina, I am not a very experienced programmer but I would like to try to help in some way. If you have SQL Server 2008 and Visual Studio 200...
Summary: My home computer does not have a network on it and isn't set up to show Users and Groups under Computer Management. I have SQL Server 2005 Reporting ...
Summary: Hi I am trying to spool the output of 3 sql queries into different sheets of the same excel file. Like Query 1 result in sheet 1 of report.xls Quer...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroy...
Summary: i am a non-professional user of MS Access for the last 8 years and through playing, eperimenting and searching i can say that have become pretty good ...
Summary: I haven't used ACE in years, but all of the Informix documentation is available at: http://www-306.ibm.com/software/dat... The best book for SQL?4GL i...
Summary: When I Add or Configure a DSN using SQL server as a datasource, on the screen which pops up with the Name, Description and Server field - there is a d...
Summary: I'm not real good with SQL, but I think the solution would be to join the two tables (inner or outer?) such that every record in tableA would have it'...
Summary: Hi, I am currently working in mainframe.I like to learn SQL.can anyone suggest the best way to get excel in SQL and ORACLE. how the SQL differ from O...
Summary: oh yeah i did the where clause for file xxxx just tryna get one row working first. i'll try this once i have database access again thanks mdow. one th...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: I am proficient in most software but have very limited experience with Access. My question is this. Say I have a table for several months containing d...
Summary: Select title as short_title, * from <input_file> into table <sorted_file> where left(title, 4) != "The " and left(title, 2) != "A " UNION select...
Summary: Hello! Maybe someone can help me... I want to write procedure containing some queries as SQL query. For example, I have queries "sglstr", "sqlstr1" an...
Summary: Dear Friends, I am learning PL SQL for the first time. In one program I have given the dbms_output.put_line statement. While executing the program i...
Summary: Hi all, I'm new to all of this, so be patient. I'll explain as much as I can. I bought a program that is a front-end to a SQL Express database. Ever...
Summary: We have various SQL Jobs that run everyday to undertake various tasks. The job in question is this "full-text full population for full-text catalog CP...
Summary: May I ask if any sql statement to compare date with today and give the result on each record? e.g table Date Name 8/1/2008 Tom 27/12/2008 Ann 2...
Summary: Two good suggestions so far. Michael's right...As far as complexity goes, this barely registers on the meter in the database world. Bare easiest to j...
Summary: Is there a way to save sql database on a floppy disk or hardrive. What command can I use. Is there a way where I can save my newly created SQL databas...
Summary: I am new to SQL mangement and was wondering what the implications are when you remove the owner of a SQL database? Does this stop any access to the DB...
Summary: I am getting this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/regsim.100webspace.net/index...