nice link!

char(44) is a comma, is that your special character?

this statement in syntactically correct:

--the char

select char(44)

--an example

select 'the severity level of the patient or resident' + char(44) + 'injury'

INSERT INTO [dbo].[Events]

([ID]

,...

if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:

ok, an update to random is certainly possible... you were really thin on the actual firstname/lastname table definitions, so i cannot provide you with a perfect example...

but, based on your...

dbcc timewarp? (inside joke)

actually, i think the issue is the times are cumulative, and are since the server restarted...

so it's quite possible if your server is active, or has been...

this will be boatloads faster and is a single set based query, instead of using a cu..cur... i can't even say the word...it's so evil....

SELECT top 1000 *

FROM (

SELECT

A.FName,

B.LName

FROM FNAMES...

they way i would recommend is by using the script i contributed in this article:

Reverse Engineer A Database Trace[/url]

first find all the traces on your server with SELECT * FROM...

the %PATH% allows you to do things...

In SQL Server, they are the same thing...in ORACLE and maybe other DBMS systems an AFTER trigger is different.

The first ingredient in properly employing triggers is to understand the differences...

ruff if you only have hours and minutes, how are you going to get a datetime? you need a base/starting point...is that jan 1 of this year, for example?

you could...

there's a trick that you can get randomly ordered records by using the NEWID() function...is that what you are after?

select top 10

ColumnList

From SomeTable

order By NEWID()

and this?

in both...

something like this?

--SandBox_2011-05-27_10-51-42.bak

SELECT db_name()

+'_'

+ REPLACE(

...

ColdCoffee (5/27/2011)

---

Lowell, actually, if u look at the new dataset the OP provided, there are dups.. so, a GROUP BY of managerID with COUNT > 1 wont work on dups.....

what i posted works...whether there's more than one manager or not.

change the query to work on YourTable instead of mySampleData... then tell us what you expected that is different fromt...

physical file? no...you have to ask the SQL isntance what databases it currently has ...usually via a query, though...for example

SELECT name from master.dbo.sysdatabases

why don't you want to connect to discover...