this gets you the data in a manner where you can look at it; fromt here you can start filtering on your 14 day requirement.

notice how I took the time...

what happens when you ruin this against your linked server?:

--list all the tables and their names

EXEC sp_tables_ex MyLinkedServerName

here's one way to do it, using row number to select the batches of numbers;

declare @NumRows int

declare @i int

SET @NumRows = 10 --return 10 rows at a time

SET @i...

well here's the tables i constructed based on what you posted....but it's incomplete i think.

is a user the same as an employee id? none of the tables share a common...

a server side trace can be seen in sys.traces, but does not show up as a spid process the way it would when you run Profiler.

that said, you have some...

shouldn't that be oRS.Fields("value").value = oStream.ReadAll, not just oRS.Fields("value").value = oStream.Read?

the rest looks ok to me, i think....been a little while since i did vb6.

this works, andrew, but i've got an extra +1 and -1 in the mis that can be cleaned up for the "Descript" column:

/*

BaseFileName ...

the CHAR datatype was never part of my original post;

I was trying to find a setting or trick to get Oracle to treat NVL(SomeColumn,'') = '' to behave the same...

no need to re-invent the wheel;

starting with SQL 2005, a new function NEWSEQUENTIALID() will return a GUID, but the values are more indexable, as they return items that are...

clicking "Debug" instead of "Execute" more times than I can count.

since you mentioned textcopy, here's pair of procedures to help you use it a little easier. I had this saved in my snippets.

In TSQL, you will have to loop thru...

Kwisatz78 (10/18/2010)

---

Hi all - Can anyone tell me how I can be informed about new releases for my versions of SQL. I am wanting to stay on top of...

lots of things to change there;

get rid of the old ansi join syntaxes...

get rid of the deprecated *= joins

adding the logic to split the string into a table

minor syntax...

GilaMonster (10/16/2010)

---

Why on earth are you looking for this? This has all the signs of someone trying to get around a keyword blacklist, maybe SQL injection, maybe code standards, etc.

Why...

a single record? no...the TRUNCATE TABLE [TABLENAME] command will delete all records in a table. so that deletes records...