bmoynihan way to go for posting the CREATE TABLE and INSERT INTO statements! you are providing a great example for others to emulate! Thank you!

i came late to the party,...

computer forensic investigator KEWL;

obviously I don't need to tell you to only perform work on copies of the mdf and ldf files.

i would definitely grab a trial version of a...

i read the requirement a bit different; that the table in question had to have two specific column names in it to build the sql: I added a where...

this is a very common requirement; what you want to do is search the scripts section for the "split" function, there's several version out there, all can do what you...

i rewrote your query to use the standard INNER JOIN syntax, but I'm confused a bit about the subquery to get the count from LessOrder

take a look at this and...

CREATE TABLE #WHATEVER(

BranchID int,

ClientID int,

ClientActivity varchar(30) )

-------------------------------------

INSERT INTO #WHATEVER

SELECT 1, 135,'Open Account' UNION ALL

SELECT 1, 135,'deposit' ...

each login could connect to your database an unlimited number of timse; as an example, if you've ever had two or more queries going on in SSMS, each "page" has...

I need to do more research on some of the log applications and how they work, but I was always under the impression that they use a live database to...

Sample value before attack:

101 main street

Same field now:

101 main street

I need to know how to remove the from the thousands of affected rows without losing the...

linked servers are notorious for slow performance; the reason is typically becuase the data is copied from the linked server into your servers tempdb, and then your operation/joins are performed...so...

you are right...it looks like his maxnum() function returns the next available value...so it should be one less than that when added to row_number, unless he doesn't care about skipping...

well third party log sniffers are great , but you can set up a trace going forward for free.

Also, remember that the Application name can be faked by a developer-savvy...

forget the cursor, use a the row_number function or a Tally table to join to to get your starting max number:

something like this, if the query returns multiple rows, would...

i still have to support a few SQL 2000 clients that have not upgraded yet, it's not that uncommon that companies do not upgrade when their db system does what...

maybe one of the articles required registration on another site, so you duplicated the same email for registration for that article? check your cookies or firefoxes saved passwords...see if you...