Viewing 15 posts - 58,576 through 58,590 (of 59,065 total)
Not sure... I think this is what you want... make sure you have a primary key on your table and this should only take a couple of seconds to run. ...
December 3, 2005 at 10:41 pm
Those are all great methods and I applaud the innovations of all... but as Remi G and Adam Mechanic would remind us, you might just want to think about finally...
December 3, 2005 at 12:27 am
Nice article... you really put some thought into the proofs and which graphics to use. Good idea, as well.
December 1, 2005 at 8:05 pm
They want to use a varbinary similar to what is presented by COLUMNS_UPDATED() in triggers. I've got all that worked out so no problem there. Like I said, I have...
December 1, 2005 at 7:58 pm
Vladan,
My most sincere appologies as well... I thought you were directing it at me... Phil's correct... it's been a terrible week never mind day alone. But that's no excuse and...
December 1, 2005 at 11:50 am
Not my restrictions but the I agree with your smart-assed comment and useless comment... the client is insane especially in light of the fact that I have a solution that...
November 30, 2005 at 8:21 am
You bet, Chhana. Simple is good. Thank you for the feed back.
November 30, 2005 at 2:17 am
Phil,
I sure wouldn't mind seeing that DLL if I can call it as an extended stored procedure. I hadn't thought about that. From a Data Troll aspect, I wouldn't mind...
November 30, 2005 at 2:00 am
CREATE TABLE myTable
(
myCol BIGINT IDENTITY(1,1),
Col1....
.... other column data
....
)
November 28, 2005 at 11:39 pm
Harley,
First, welcome aboard. Thanks for the feedback and you are absolutely correct... it's supposed to add a month and I fat fingered it... I've corrected the problem in the previous...
November 28, 2005 at 11:32 pm
Midan1,
YOU WROTE:
----------------------------------------------------------------------------------------but i need to search between dates
like this i can not !!!
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)
, DATEADD(mm,DATEDIFF(mm,-1,GETDATE()),0)
i need to search from
first day of the month
the-1
and between
last
28
November 25, 2005 at 1:15 pm
Instead of messing around with milliseconds and adding 31 days, etc.... it's a takeoff on what the other posters have done but a wee bit different... works kinda like Frank's...
November 24, 2005 at 1:42 am
Can do...
SELECT FieldID,
MIN(CASE WHEN FieldName = 'NAME' THEN FieldValue END) AS NAME,
MIN(CASE WHEN FieldName = 'Address' THEN FieldValue END) AS Address,
MIN(CASE WHEN FieldName = 'ZIP' ...
November 24, 2005 at 1:31 am
One more thing! Don't even think of using the SELECT/INTO/RENAME method if others are updating the table at the same time or inserting new rows.... YOU WILL LOSE...
November 20, 2005 at 10:51 am
Almost forgot... does the table being updated have any triggers? That really make things slow for this big an update especially if those triggers are writing to audit tables or...
November 20, 2005 at 10:41 am
Viewing 15 posts - 58,576 through 58,590 (of 59,065 total)