Summary: A recent change means that the sql being produced has too much text in column 22 for the target system which is limited to 30 characters. I need to kn...
Summary: Hello Forgive my poor SQL knowledge. Im looking after an SQL 2005 machine which i inherited. I typically just need to maintain it, however, Im after g...
Summary: Hi Lou: Hmm, in terms of DOS commands, I am tempted to say - yes, it can be done. But, I can't write a DOS script yet without doing more thinking. In ...
Summary: Hi everyone, I have to run a conversion on multiple tables to change the data in one column on each table. I am happy to run this separately for each...
Summary: This might also help: Before you begin, make sure the table is not in use. Then use the isql utility to perform these manual steps, entering go after ...
Summary: It's stored in a mySQL database. Which all the data is imported via the .csv, the .csv for the card has to be setup a specific way. I think I may need...
Summary: As you've figured out, computers aren't well suited to fractions. I think that you've hit upon the best solution (two columns, for numerator and deno...
Summary: I tried running a script from an ACL 8.0 which is connected to a Sybase DB. When i run the script from ACL, it executes. but when i refresh the script...
Summary: Possibly a permissions issue for the service-admin ID, bet the security was changed in some way full text search requires some very specific permissio...
Summary: I have recently had a problem. When i restart the computer after just changing the work group. i changes back to mshome. All suggstions, walkthroughs ...
Summary: Hi all, Recently I try some script from microsoft which need to connect to SQL Server 2000 (SP4) database using ODBC, but my PC keep on show me dataso...
Summary: Hi, I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20...
Summary: Dear all, I have a problem with sql function: I want to change Amount column to Words, senirio is like this: i have a 2 column, 1 has name and 2 has a...
Summary: When using SQL Server or MySQL, is there a way to create a statement to update/change a letter in a field. Specifically if I have a list in a specific...
Summary: sorry I don't have excel installed on this machine so cannot remember the exact syntax but one of the "LOOKUPW formuluae should be able to do what you...
Summary: Well, by using "generic" values and names it makes it confusing. Let's assume I have a table called users and in that table I have the following colum...
Summary: Hello, Looking for some advice on choosing a local data source for a call reporting project that will have approximately 25 end users using it. I have...
Summary: I want to automate a process that I perform on a weekly basis for my job. Currently, I have a bunch of SQL scripts that I run through JMP, a comprehe...
Summary: Hi I am new in SQL server. I am trying to find out which tables contain a specific column name in entire database. Is there any equivalent dictionary...
Summary: First, I don't understand your question at all? I can identity that column 4 times column 6 equals column 7 Second, are you asking for a Unix shell sc...
Summary: Hi all. If got a Database that with tables. SKU and Orderdetail. Fields of Table SKU >> SKU, Placement, SUSR1 SUSR2. Fields of Table Orderdetail >> SK...
Summary: I have not yet determined how this occurs but when the following value is blank, all of the existing ODBC configurations become COMPLETELY HIDDEN from...
Summary: I'm not even going to ask why you felt the need to create your own method of naming table columns, when SQL Server already provides a way of doing so ...
Summary: Hi This is my script. SELECT T$ITEM, SUM(CASE WHEN T$YEAR=2005 THEN T$AUPP$1 ELSE 0 END) AS "2005 JAN", SUM(CASE WHEN T$YEAR=2005 THEN T$AUPP$2 ELSE 0...
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
