Viewing 15 posts - 58,561 through 58,575 (of 59,048 total)
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
Yup, I'd lose the OUTER JOIN if an INNER JOIN will do. Also, like someone else asked, "What is slow"? I normally shoot for about 500,000 rows per minute (sometimes...
November 20, 2005 at 10:38 am
Very, very cool... ol' Itzik did a neat job on this one.
Ken, do you know of a fn_DecToBase function in a similar vein by anyone?
November 19, 2005 at 7:51 am
Viewing 15 posts - 58,561 through 58,575 (of 59,048 total)