Viewing 15 posts - 58,576 through 58,590 (of 59,066 total)
Charles,
Very nice. And if you reverse the dates, the numbers make even more sense! I added a couple more to show the trend...
December 3, 2005 at 11:07 pm
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
Viewing 15 posts - 58,576 through 58,590 (of 59,066 total)