My query has these columns:
PO Number PO Create Line Amount USD PO DISTRIBUTION
1 $0 0-500
2 $5 0-500
3 $20,00...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2287...
Hello,
I have this script that insert few records in two tables. I have to modify it so it colud be rerun.
Is there a simply way to do that.
thanks in advance.
script:
SET ANSI_NULLS ON;...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2287...
I'm more a developer than a hardware person.
I understand the benefits of horizontal table partitioning. There;s plenty of documentation of horizontal partitioning to multiple filegroups on mul...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22917888.html
Hi,
Im currently trying to broaden my skills as a software developer. I am familiar with sql but have been looking at T sql syntax recently. I have come across a few examples that I have tried ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2294...
I need to create a view with the following columns SUB_TOTAL ,TAX ,DELIVERY_CHARGE ,TOTAL_COST
And the SQL for fetching each of these values is as follows:
SUB_TOTAL = SELECT SUM( ITEM_PRICE...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23042852.html
I've installed the SQL Server Developer Edition that comes with VS2005, I've created a database, and I want to import some external data. I keep reading that there is an Import item under Tasks wh...
http://www.experts-exchange.com/Microsoft/Development/Q_23049177.html
Hello, I have a ms sql 2005 database on a shared server through my hosting company. I would like to schedule regular backups somehow. I don't know how to do that using Management Studio Express. I ...
http://www.experts-exchange.com/Storage/Backup_Restore/Q_23065433.html
Righto Experts
Pigeon steps.....Am trying to set myself up my first written Scarlar Function and I keep getting error messeges.
The current one is :
Msg 102, Level 15, State 1, Procedure Fis...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23144206.html
I have several tables in an SQL 2005 database. Each table has 2 fields maintdate and Isdeleted.
The maintdate field says when the row was updated.
The IsDeleted field says if the record is logi...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2315...
Based on my data structure below I am trying to return one record for every person , if a person has non unique values in Column1 or Column2, I just want to return the first record found along wit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2315...
