Viewing 15 posts - 23,821 through 23,835 (of 26,490 total)
Thanks, but I'm not working from a screen shot of the data. Please take the time to read the article shown below in my signature block and follow the...
November 10, 2008 at 4:07 pm
What is your table structure and what is the actual error message you are receiving?
November 10, 2008 at 3:52 pm
Drop 10 yards and punt?
Not sure either. We don't know your table and view structures, we don't have any sample data with which to work. All we can...
November 10, 2008 at 3:50 pm
You may need to edit the data. If you have nulls where you can't have them, you will need to provide a proper alternative using ISNULL.
November 10, 2008 at 3:37 pm
You may have eliminated the cursor, but you may not have eliminated the RBAR (Modenism for Row By Agonizing Row) processing.
If you post your code, table DDL (create statements), sample...
November 10, 2008 at 3:27 pm
Can you explain why you are "updating" the primary key in your update statement?
November 10, 2008 at 3:14 pm
paul.starr (11/10/2008)
Msg 208, Level 16, State 1, Procedure BILLTO_Customers, Line 7
Invalid object name 'dbo.cust.Customers'.
USE [AtriumWOE_CS_UserData_52]
GO
/****** Object: StoredProcedure [dbo].[BILLTO_Customers] ...
November 10, 2008 at 3:12 pm
paul.starr (11/10/2008)
////Alter Procedure
ALTER PROCEDURE [dbo].[BILLTO_Customers]
AS
DECLARE @message ...
November 10, 2008 at 2:05 pm
Christopher Stobbs (11/10/2008)
c.Date > = DATEDIFF(yy,-5,GETDATE())
Please not the this will take into account...
November 10, 2008 at 1:50 pm
GilaMonster (11/10/2008)
Patrick Russell (11/10/2008)
November 10, 2008 at 1:48 pm
Don Bernstein (11/10/2008)
I want to use a Print statement to show the number of students (StudentID's) in the table.
I could not...
November 10, 2008 at 1:34 pm
It would also help if you posted the code for your UDF as well as both valid and invalid sample data for the function.
November 10, 2008 at 10:29 am
Arthur.Lorenzini (11/10/2008)
I have this AND clause:AND c.DateCreated BETWEEN DATEADD(YEAR, -5, GETDATE())
Is this correct? What I am trying to get to is any records from today to 5 years ago.
No,...
November 10, 2008 at 10:17 am
It depends. Is there anything else going on with the database that you haven't told us, like replication? There could also be some long running transactions that keep...
November 10, 2008 at 10:02 am
Viewing 15 posts - 23,821 through 23,835 (of 26,490 total)