Viewing 15 posts - 2,416 through 2,430 (of 6,036 total)
There is no such thing as time formatting in database.
Datetime values are stored as 8 bytes float values.
The way they are displayed depends on UI application and only on UI...
_____________
Code for TallyGenerator
October 28, 2009 at 2:24 pm
Sorry, no time for putting proper comments in there, I hope you can figure it out yourself.
Column N_Date in table Tally contains all sequential dates from '1900-01-01' to '2076-12-31'.
select H.hallId,...
_____________
Code for TallyGenerator
October 27, 2009 at 10:02 pm
-
_____________
Code for TallyGenerator
October 27, 2009 at 9:57 pm
You should know better which values to use for grouping:
SELECT [id], [origin_latitude], [origin_longitude], [remote_latitude], [remote_longitude], [distance_miles]
FROM [towergrid_reference_natowers] T
INNER JOIN (select [remote_latitude], [remote_longitude], MIN([distance_miles]) min_distance
...
_____________
Code for TallyGenerator
October 27, 2009 at 9:04 pm
SELECT [id], [origin_latitude], [origin_longitude], [remote_latitude], [remote_longitude], [distance_miles]
FROM [towergrid_reference_natowers] T
INNER JOIN (select MIN([distance_miles]) min_distance
from [towergrid_reference_natowers]...
_____________
Code for TallyGenerator
October 27, 2009 at 6:08 pm
Is there only one procedure named "TransHistoryAccount20091016_pr"?
_____________
Code for TallyGenerator
October 27, 2009 at 4:17 pm
You did not specify what you need to happen when the value is blank, so I assume it's no match:
LEFT JOIN tblAPBill
on...
_____________
Code for TallyGenerator
October 27, 2009 at 3:56 pm
No, it's incorrect sysntax issue.
Correct statement would look like this:
select *
into temp2
from temp1
_____________
Code for TallyGenerator
October 25, 2009 at 7:25 pm
How many times users change passwords?
I bet - not quite often.
Create a table "RecentPasswords".
Create a procedure "UpdateRecentPasswords".
Procedure to be called every time user's got a new password saved (from trigger...
_____________
Code for TallyGenerator
October 22, 2009 at 5:52 pm
GSquared (10/14/2009)
declare @TableChecked varchar(100);select @TableChecked = '[' + name + ']'
from sys.tables
where name = @TableName;
declare @DynamicSQL varchar(max);
select @DynamicSQL = 'select * from ' + @TableChecked;
exec(@DynamicSQL);[/code]
I know, normal people won't do...
_____________
Code for TallyGenerator
October 17, 2009 at 11:18 pm
Jack Corbett (10/12/2009)
Can you post at least pseudo code for the trigger?Sergiy, is close, but because you said it is an insert trigger you can't use the deleted table.
Tables...
_____________
Code for TallyGenerator
October 12, 2009 at 5:42 pm
IF EXISTS (
select 1 from inserted i
left join deleted d ON d.KeyColumn = i.KeyColumn
where (i.fieldname <> d.fieldname OR d.fieldname IS NULL)
)
BEGIN
......
END
This will run the code only if new values are...
_____________
Code for TallyGenerator
October 11, 2009 at 4:27 pm
SELECT
a.id,
a.data,
b.MAX_field_b
FROM table_a as a
LEFT JOIN (select MAX(field_b) MAX_field_b, id
from table_b
group by id
) as b ON...
_____________
Code for TallyGenerator
October 8, 2009 at 5:13 pm
krish-529631 (10/6/2009)
Instead of below you suggest.
Select @cnt = Count(Distinct dbo.CustomerMaster.CustId) FROM dbo.CustomerMaster Where
dbo.CustomerMaster.Transdate >= @dtFrom and
...
_____________
Code for TallyGenerator
October 6, 2009 at 10:57 pm
Matt Whitfield (9/30/2009)
?? If you're asking did I give enough info to the OP to achieve what was asked for, then yes.
If we look up the first post on...
_____________
Code for TallyGenerator
September 30, 2009 at 7:15 pm
Viewing 15 posts - 2,416 through 2,430 (of 6,036 total)