Greetings all
I have a stored procedure used in conjunction with an SqlDataAdapter, to insert records into two tables.
To summarise ..... I have a dataset which is combintation of two tables ...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23155988.html
I am using MS SQL 2000.
I have an existing Stored Procedure (which is quite large), call it spA. spA returns a table of values which include an ID in each row.
I am writing a new Stored Proc...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23454745.html
Hi,
I have a simple question. Is MS-SQL runtime free?
Thanks you
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20104299.html
Zones:
MS SQL ServerDate Answered: 04/11/2001 Rating: 8.2 Views: 0
Years ago someone developed this code, for a report.... we now what it to be a view table now.....
code below:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC dbo.usp...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22804712.html
i have a old SP which is throwing up a error "String or binary data would be truncated "
if i set SET ANSI_WARNINGS OFF it works but i need this to work without SET ANSI_WARNINGS OFF
the SP ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23103919.html
Zones:
MS SQL ServerDate Answered: 01/23/2008 Rating: 9.0 Views: 0
I have a script below, that goes to all the stored procedures in capital letters.
Is there a similar way to go through all the stored procedures, and if there is a column with name player, chang...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2325...
In MS SQL, how do you insert a column for example in tbl_products named DateAdded, that all it is, is the date and time that the product was added.
Can anybody show me how to with a code snippe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23259405.html
I am using a bunch of union statements in order to add descriptive labelings to the data returned. Does anyone have a better method of doing this?
I have only included a couple of unions but th...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23281371.html
Zones:
SQL SyntaxDate Answered: 03/30/2008 Rating: 8.1 Views: 0
I want to do:
((SUM(dbo.GLSUM.ACTIVITY * - 1) / SUM(dbo.BUDGETS.ACTIVITY * - 1)) / SUM(dbo.BUDGETS.ACTIVITY * - 1) )
But the query tool keeps changing my statement to:
SUM(dbo.GLSUM.ACTIVITY *...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23286520.html
Zones:
SQL SyntaxDate Answered: 04/01/2008 Rating: 9.7 Views: 5
Hi,
part 1 -- I am trying to write a query in which the result set should automatically be stored into a table( not a temp table). The query is as follows:
Select distinct Mgr.MgrIDPK as MgrI...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23321685.html
Zones:
SQL SyntaxDate Answered: 04/15/2008 Rating: 9.4 Views: 0