http://www.devarticles.com/c/a/Oracle/Datatypes-Used-in-Oracle-9i/1/

Edit: Found another site that says if precision isn't specify, then 38 is used.

See the attached code (having trouble posting from work). I'll copy the code into this message tonight when I get home.

DECLARE @test-2 TABLE (MyDate datetime);

INSERT INTO @test-2

SELECT '2010-06-24 18:19:00.000' UNION...

I think Monsieur ColdCoffee's code can be simplified - I don't think that the first CTE is necessary if in the second one, we order by the Activity in the...

Stefan Krzywicki (11/3/2010)

mbender (11/3/2010)

NONE of them??? wow...

The purpose of indexes is to allow...

Column delimiters need to be unique in the file. If one of the columns allows commas, change to something else (like the |).

jamesn 89076 (11/2/2010)

How do you guys do the "xcopy/robocopy". Do you include it as apart of the Backup Agent job or do it schedule it...

In the query that retrieves the data, just concatenate them together:

SELECT CombinedColumn = StringCol1 + StringCol2

FROM YourTable;

As far as code snippets go... is there anything particular that it's looking for? It's a royal PIA trying to post code sometimes. I've had times where I can't post...

I don't... but Work uses websense at work. What do you know about this interaction between them?

Just looking at the intro to that article, it looks like what I'm talking about.

I thing I'm interested in - I frequently end up giving a reporting user access to...

Thanks Jason - I occasionally have problems posting code - seems to be from work. I'd love to figure it out!

Is this what you're looking for?

(Having issues posting code - it's in the attachment.) Code is now below.

-- sample data

DECLARE @EmployeeDetails TABLE (id int PRIMARY KEY CLUSTERED,

...

Does this do it?

WITH CTE AS

(

SELECT ID, clientID, enrolldate, exitDate, branchID,

RN = ROW_NUMBER() OVER (PARTITION BY clientID ORDER BY exitDate DESC)

FROM...

buddy__a (11/2/2010)