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 ....

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...

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

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 ...

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...

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 can remove the * and keep...

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 table I need to populate. The...

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

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...

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...

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...

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

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. Currently he has a manual (cash...

Duplicating records in a table with a SQL query

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

Find Next SQL AutoNumber

Hi, I was wondering if there is a way to find the next autonumber in a SQL table before inserting the record? I tried just looking at the previous number and adding one but if I delete the last record then this wouldn't work or if I delete all the records then the number won't be 1. Any...

Is there a way to retrieve datatypes from stored procedures?

I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Is there a...

merging 2 rows into 1 row

Hi , i have 2 tables table a m_id name 1 abcd 2 bcde table b m_id id org_name ind_name 1 1192 gold coast 1 1193 fred 2 1196 greg 2 1198 TechTronics i am now generating the report through a sql query whose output shud be id...

ExcelSource file - metadata validation

I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output...

SQL Find a number between the given ranges of number / Find a row which has range of given number

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

Adding columns and updating a SQL table in a reporting database-

My SQL table contains about 80 columns; it is a reporting database, so I update this table data daily from an application database. I need to add 20 more columns, but when I add for the present job, it is not completing. The present job logic is using a permanent table to get all the records at a...