Viewing 15 posts - 10,786 through 10,800 (of 13,469 total)
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,...
July 23, 2009 at 7:28 am
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...
July 23, 2009 at 6:59 am
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...
July 23, 2009 at 5:19 am
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...
July 22, 2009 at 7:59 pm
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...
July 22, 2009 at 7:52 pm
CREATE TABLE #WHATEVER(
BranchID int,
ClientID int,
ClientActivity varchar(30) )
-------------------------------------
INSERT INTO #WHATEVER
SELECT 1, 135,'Open Account' UNION ALL
SELECT 1, 135,'deposit' ...
July 22, 2009 at 7:42 pm
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...
July 22, 2009 at 3:25 pm
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...
July 22, 2009 at 10:25 am
Sample value before attack:
101 main street
Same field now:
I need to know how to remove the from the thousands of affected rows without losing the...
July 22, 2009 at 10:05 am
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...
July 22, 2009 at 8:30 am
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...
July 22, 2009 at 7:51 am
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...
July 22, 2009 at 7:46 am
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...
July 22, 2009 at 7:20 am
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...
July 21, 2009 at 8:44 pm
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...
July 21, 2009 at 4:12 pm
Viewing 15 posts - 10,786 through 10,800 (of 13,469 total)