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...
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,...
October 27, 2009 at 10:02 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
...
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]...
October 27, 2009 at 6:08 pm
Is there only one procedure named "TransHistoryAccount20091016_pr"?
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...
October 27, 2009 at 3:56 pm
No, it's incorrect sysntax issue.
Correct statement would look like this:
select *
into temp2
from temp1
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...
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...
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...
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...
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...
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
...
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...
September 30, 2009 at 7:15 pm
Viewing 15 posts - 2,416 through 2,430 (of 6,036 total)