Programming SQL

Sql Server agent job failer/ completion notification
Hi, I am getting following error, when i set email notification of a job. Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog. I find the resollution from following ur... 11 Jul 2008 05:50

registry
Hi, In sql server configurations, named pipes (NP) is disabled and shared memory (SM) is enabled. using t-sql I am trying to find out whether or not they are enabled. See below... Problem: For NP, the returned field shows empty whereas it shows 'r' for SM Question: 1) Does 'r' represent enabled and blank... 11 Jul 2008 09:56

Whats wrong with this SQL plus other questions?
I get 'incorrect syntax near 'P' - not very helpful. Also, how would I cater for the left joins returning null names, (i.e. where a parent has no children or employer)? Also not sure the last left and inner join is correct. the ParentEmployer table links to Parent and Employer and employer name is in the Empl... 10 Jul 2008 22:41

Can a stored proc call another stored proc?
and if so what happens if I am within a cursor, can I come back to it and continue? Thanks. ... 11 Jul 2008 04:49

put a description on a stored procedure parameter
Can you put a description on a stored procedures parameters that you can get back in a query like you do for a field in a table? Thanks, Tom ... 10 Jul 2008 21:40

List parameters for Stored Procedures
I am trying to get a list of stored procedures (not system stored procedures) along with there parameters. Is this possible? Thanks, Tom ... 11 Jul 2008 17:10

Need help with group by syntax
On SQL Server 2005 you can use the ranking functions: WITH Ranked AS (SELECT parameter, trial, result_1, result_2, ROW_NUMBER() OVER(PARTITION BY parameter ORDER BY trial DESC) AS seq FROM Foo) SELECT parameter, result_1, result_2 FROM Ranked WHERE seq = 1; HTH,... 10 Jul 2008 19:37

INSERT into another database
I am trying to code an insert from a table in one database to another. The table I am trying to insert into has an identity field and so I am turning on to allow. My code is below and I am getting the following error: IDENTITY_INSERT is already ON for table 'Filedata.dbo.Company'. Cannot perform SET operatio... 11 Jul 2008 09:56

Aggregate overflow
I have a table that looks like CREATE TABLE ZipStats ZipCode CHAR(5), Cost int where cost is an integer with cents scaled up by 10,000. So if cost is $0.179, Cost is stored as 179000. And no, I can't change this table or column definition. I want to do this: SELECT ZipCode, SUM(Cost), COUNT(*) FROM... 11 Jul 2008 18:12

SQL to XLS
I am using SQL 2000. There is a table Orders with Order information. OrderID(PK), EventId(FK) to table Events There is a table Events EventID(PK) Based on an OrderId I have to calculate how many distinct events are associated with that OrderId. This will tell us how many max columns I need for Events. Now I ... 11 Jul 2008 07:53