Getting last entries from two different tables
Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

Answer Question   |  September 29, 2009  7:29 AM
MSSQL, SQL tables

Error when insertin.g data into SQL table
                I’m using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I’m having a problem of inserting data into one of the tables in my database through my VB.NET application. I did successfully inserted data through my [...]

Answer Question   |  September 28, 2009  10:31 AM
Microsoft Visual Studio, SQL Server 2005, SQL Server 2005 Express, SQL Server tables, SQL tables, VB.NET, VB.NET 2005, VB.NET 2005 programming, Visual Studio 2005

Diff. between PF and a sql table
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index…..

Answer Question   |  October 9, 2009  8:35 PM
DB2/400, DDS, Physical Files, SQL tables

Aren’t correlation IDs ok in MSSQL for an UPDATE statement?
I’m getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I

Answer Question   |  September 2, 2009  4:35 PM
SQL error messages, SQL tables

Getting specific values from a SQL table to the ComboBox
How do I get specific values from a SQL table to the ComboBox in the running mode?

Answer Question   |  October 5, 2011  3:53 PM
combo box, ComboBox, SQL tables

recovery when using sql tables
Recovery or rollback procedure when using SQL tables on AS400

Answer Question   |  July 7, 2009  1:34 PM
AS/400, AS/400 SQL, SQL Server tables, SQL tables

Convert column from Number(9) to varchar2(3) in SQL
What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ….

Answer Question   |  July 1, 2009  2:26 PM
SQL, SQL tables, VARCHAR

dynamic temporary table variable usage
We have an sqr (running against a MS SQL Server DB), that references a dynamic temporary table variable in several begin-sql and begin-select statements. I am getting a syntax error in one begin-select statement where I can’t resolve the problem. It occurs after the INNER JOIN on the [$Temp_Final_IDlist] temp table. It appears as if [...]

Answer Question   |  June 25, 2009  7:53 PM
Dynamic SQL, INNER JOIN, SQL tables, SQL variables

when i print a work order in the application i need to update a field in a sql table to true
when i print a work order in the application i need to update a field in a sql workorder table to true

Answer Question   |  June 19, 2009  3:48 PM
SQL Printing, SQL Server Printing, SQL tables, SQL Work Orders

Alter SQL table
hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i’m wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb [...]

Answer Question   |  May 29, 2009  11:21 AM
SQL, SQL tables

Database Issues – Trying to prove that something has to be done
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]

Answer Question   |  September 20, 2010  2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables

SQL update a column to remove a certain character
I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the ‘*’ is preventing me from doing this. So how do I update or alter the table so that I [...]

Answer Question   |  April 19, 2013  1:41 PM
SQL, SQL tables

SQL 2005 SSIS Package to load table from positional flat file
I have a positional flat file which I need to load contents into a SQL table. I’ve created an SSIS package and will need to call a VB script to parse the file but since I’m new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the [...]

Answer Question   |  May 22, 2009  8:00 PM
SQL 2005, SQL tables, SSIS flat file package, SSIS Package, VBScript

split column
i need to take a column in my database and split it into different columns based on a question id. Basically i want to write a whole bunch of sql statements that are non related for one grid – a whole bunch of sql statements each with their own where statement

Answer Question   |  May 5, 2009  3:26 PM
SQL, SQL tables

SQL Server 2005 Select Multiple views or Tables
in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don’t know how to do that in SQL 2005. [...]

Answer Question   |  March 18, 2009  12:07 AM
SQL 2005, SQL Multiple Views, SQL Query Analyzer, SQL Server 2005, SQL tables

table row values for column headers
Hi. I have two tables in a simple database: Prices ID (int, identity, PK) Year (smallint – year of value) Quarter (smallint – year quarter 1-4) Area (smallint – FK to Areas.ID) Index (float) Areas ID (int, identity, PK) Name (varchar) So, as you can see, the Prices table contains price information over time for [...]

Answer Question   |  March 19, 2009  7:25 PM
SQL, SQL Database, SQL tables

two dimentional output
I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes [...]

Answer Question   |  February 3, 2010  5:53 PM
SQL Query, SQL tables, Two-dimensional Output

Running .NET Code to manipulate sql tables
is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

Answer Question   |  February 12, 2009  8:52 PM
.NET, SQL Server 2005, SQL tables

A Smart Developer
I have been out of touch from VB Programming for a long long time. In front of me is a task and I am ambitious about doing it in a quick & smart way. I work for a small businessman (a shop keeper) who buys Steel wireropes from wholesalers & sells it as a retailer. [...]

Answer Question   |  February 24, 2009  6:29 PM
BAS Modules, SQL Server 2005, SQL tables, VB 6.0

Duplicating records in a table with a SQL query
How can I duplicate every record in a table with a query in SQL?

Answer Question   |  January 14, 2009  4:54 PM
Duplicate records, SQL queries, SQL tables