I have the following procedure and i like to declare a copy of local variables
@Operation and @Operation_Access that i can use in the processing.
It is not allowing me to set up these....c...
I'm apparently confused about the way SQL works with a LEFT OUTER JOIN. Below is a sample statement I am using for summing InvAmt, PmtAmt, CreditMemoAmt. Payments and credits are based on a ...
Hello,
The following snippet is from a sp that I am trying to get working:
DECLARE @TSql nvarchar(200)
SET @TSql = 'SELECT TOP 1 * INTO #Store_OrderDetailsTemp FROM Store_OrderDetails W...
Hi, Experts:
Does SQL Server 2000 has any function or extended storeprocedures that has
the same functionality as Split() function in VBScript or Javascript? I try to split the
followi...
I have a SQL database (SQL 2000) that has an Access2000 front end to it. Everything works ok for me, but for others it is not. When they click on the table or the report, they get "Connectio...
hell there,
i am having problem viewing reporting service reports i created.i get this error.how do i create a user with a trusted SQL Server connection.
the error i get is.but in my stu...
I keep getting this "warning" when I run certain scripts:
Warning: Null value is eliminated by an aggregate or other SET operation.
It's not a "fatal" error, so the script still runs,...
Is it possible to call a stored procedure in a select statement
For example
SELECT Account_ID, Account_Number, Currency, (Exexute the stored procedure passing to it the Account_ID) AS Cu...
I have a SQL Server 2005 Express installed on my Intranet server that resides in my DMZ.
I have access from my LAN to my DMZ open.
I have the SQL Server configured to allow remote connec...
I am attempting to create a stored procedure that, in part, places into a temp table the results from another stored procedure. Ideally I'd do something like:
Insert into #Temp
EXEC MyDatab...
Hello,
We are new to MS SQL Server Management Studio and need to export a table to a csv formatted file. We figure there must be a wizard or some function to do this but have not found it....
Hi Experrts,
I am having an issue with the correct syntax of the nested if then else in a stored procedure. I get a syntax error or access violation :code 0. please help!
CREATE PROCE...
Hi all experts,
I am a new guy which is now working with SQL Server. I try the following SQL Statement
INSERT INTO TRACKLOC
(DATETIME)
VALUES ('18-11-254...
When coding a stored procedure does SQL 7 support selecting a value from a table into a variable?
Example:
Select lastname
into @v_lastname
from employee
where employee_id = 999
How can I put an IF EXISTS for both my creation of the constraint and Drop below to safegard from any errors?
ALTER TABLE PurchaseDownload
DROP CONSTRAINT [FK_PurchaseDownload_ProductFile]...
I'm putting together a profit and loss report in SQL Server Reporting Services (SSRS). I need to display a number, e.g. 1023488.06, as 1,023.5. I've gotten as far as putting #,#,;(#,#,);- in t...
Hi,
I have two tables within a SQL Server database; the first database has a column which is an identifier and another column which lists one of more email identifers for a second table, e....
I have SQL Server Std. running on a Win 2003 server. Everything has been fine except for the past few days the Default Instance/Service does not launch anymore. I have uninstalled and reinstal...
I recently installed SQL Server 2005. I see by going into SS 05 that I have an sa login. I don't remember supplying or being asked for a password for sa at installation. I can open up the sa...
I need to use (I think) the GETDATE() function to return the current date, but I need to make sure that it is only the date and no time, or at least time to be 0.
Is this the right way to go ...
Hey, I was wondering if there was a way in MS SQL (2000 specifically) to cast out a character, like in FoxPro
For example, in fox pro you could have
SubStr(alltrim(field), 1, at('$', al...
Hello,
I need to be able to update the SQL command default timeout of 30 to something greater. I KNOW this can be done super easy through code, however, I do not have that luxury and need ...
Hi,
Kindly assist how can we convert a datetime to string?
select ID, 'present ' + DTstart from table1
adding the word present to a datetime column
Thanks.
How can I create a while loop in SQL and grab a certain field from my table and work with each record.
Example,
While @Var > 1
BEGIN
Select @FieldValue = somefield from mytable for c...
How do i convert a Int to a string.
I am trying to append a Integer value in a query.
SET @SQL = 'UPDATE status_table SET status' + CONVERT(varchar(10),@statusCount) + ' = ''' + @Old_sta...
