kancherla.ks (10/19/2010)

---

Hi Thanks for the prompt response,your scripts are helpful

but we are not aware what kind of HTML tags and the sqlscripts they might send us as we...

i use a regualr expression to remove what i think of as "malicious" keywords from a simple web page that is supposed to provide SELECT only statements;

this would be...

row number is what you want in this case;the key to it the PARTITION BY, which groups the rows based on the selected columns.

here's an example; if you look at...

i looked at this, and it seems the best solution would be a CTE so you can use regular expressions, right?

then you can find the word breaks before and after...

yes.

a backup is saved as a specific version, ie SQL 2008, so you can restore it on any same or higher version , ie Standard/Developer/Enterprise/Workgroup/Small Business/Express as well(given the db...

whenever i see a performance issue featuring "stored procedure" and "parameter driven", i think either out of date statistics or parameter sniffing as the core causes to look at first.

We'd...

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...