you want COUNT(ID) not COUNT(DISTINCR ID)

WITH AddPr(ID,NOTES)

AS

(

SELECT 'ID','NOTES' UNION ALL

SELECT '1',' ADD PR' UNION ALL

SELECT '2',' DELETE PR' UNION ALL

SELECT '1',' ADD PR' UNION ALL

SELECT '3',' ABC' UNION ALL

SELECT '1','...

i see two issues:

first, teh data is so simple, i don't see any need to use a format file; i only use format files if it's delimited with quotes or...

are there deeper than 4 levels in the "real" data? are there always exactly four levels?

the right solution depends a lot on some assumptions we can make with the data

here's...

looks like a copy/paste error:

ROW_NUMBER needs parenthesis:

change that query to ROW_NUMBER() and it should work fine.

momba (2/5/2013)

---

I'm trying to pull out the last record for each employee, i.e. if they appear in the table two or more times, I just want the record attached to...

search for "Audit Triggers" on this site...there's a lot of articles and examples:

here's the first article i found, and i reviewed it to confirm it has a decent example:

http://www.sqlservercentral.com/articles/Triggers/auditingtriggers/579/

it's all in sys.tables, but i prefer to use built in functions instead of joining sys.schemas:

SELECT

SCHEMA_NAME(schema_id) As SchemaName ,

name As TableName

from sys.tables

ORDER BY...

the error "The specified string is not in the form required for an e-mail address.)" sounds like someone sent "Lowell" to the exchange server, and not lowell@somedomain.com.

For not sending at...

oops sorry; the first quesiton mark should be in quotes:

sp_msForEachDb

'If EXISTS(SELECT 1 FROM [?].sys.tables WHERE name = ''t_payers'')

select ''[?]'' As DbName,* from [?].dbo.t_payers where pay_name = ''Name...

sp_msForEachDb

'If EXISTS(SELECT 1 FROM [?].sys.tables WHERE name = ''t_payers'')

select [?] As DbName,* from [?].dbo.t_payers where pay_name = ''Name of Payer''; '

just missing your concatenation:

where CAST(o.OrderID AS varchar(15)) like '%' + @WildOrderID '%'

--should be

where ...

never heard of MP2 either, but I know most applications are data-size aware...if the content isn't too big, scroll bars are not needed, so they are not displayed;

is it possible...

in my youth, i owned plenty of GM, Fords, even a Dodge or two...back then all i could afford was used cars, which are usually someone elses problem they got...

Craig I think that was true with SQL2000, and the old SQL Mail, but the 2005 and above database mail via msdb.dbo.sp_send_dbmail is already an asynchronous service broker item,...

ahh sorry i misunderstood.

for me, encrypted or not, it just goes to whatever normalization is proper for the data;

Basic normalization considerations for me would be:

data is 1:1 and...