Viewing 15 posts - 1 through 15 (of 43 total)
The last 2 rows doesn't look like duplicates. still if you want to delete them, then just say
delete from emp where empname = 'duptest4' or empname = 'duptest5'
or use...
February 21, 2006 at 10:22 am
wow, I thought it's just impossible to sort a matrix group. It is working like a charm now. Thanks David!
December 7, 2005 at 3:17 pm
Thanks a lot Farell, worked me great!
October 13, 2005 at 11:00 am
Senthil! try this.
SELECT * FROM mytable WHERE convert(varchar(25),mydate,13) = convert(varchar(25),@mydate,13)
October 10, 2005 at 11:47 am
The nat_BusinessCalendar table looks like this as you know.
BDate BUSINESS_DAY
--------------------------------------- ------------ ----------- ---
October 3, 2005 at 3:20 pm
I don't think that I can make it a procedure as I need to use this function to update a date field in a table. I tried to make it a...
October 3, 2005 at 2:49 pm
I am unable to use the SET ROWCOUNT with in a function Remi, getting this error.
Server: Msg 443, Level 16, State 2, Procedure BUSINESS_DATEADD1, Line...
September 29, 2005 at 9:18 am
Hi Remi,
is there any way that I can make this function work for negative intigers too?suppose if I say dbo.business_dateadd(getdate(), -3), then I should be able to get 09/26/05. Thanks for any...
September 29, 2005 at 8:27 am
Oh, I didn't turn up after. I got my function this way.
CREATE FUNCTION DBO.BUSINESS_DATEADD (@STARTDATE DATETIME, @DAYS BIGINT )
RETURNS DATETIME
AS
BEGIN
DECLARE @ENDDATE DATETIME
SET @ENDDATE = (SELECT DD FROM(SELECT T1.BDATE AS DD,...
September 28, 2005 at 9:32 am
no body else has a post count >6000 in SSC.com remi! and also by observing your pace and by seeing ur previous posts.
September 27, 2005 at 10:21 am
Hi Sushila,
I was away from SSC.com for some time. When the time I'm back, I...
September 27, 2005 at 8:49 am
Hi Remi, Iam trying to create this function but Iam not sure that I can use the set rowcount here.
CREATE FUNCTION DBO.BUSINESS_DATEADD (@STARTDATE DATETIME, @DAYS BIGINT )
RETURNS DATETIME
AS
BEGIN
DECLARE @ENDDATE DATETIME
SET...
September 26, 2005 at 3:19 pm
These are the tables I am working with
CREATE TABLE [NAT_WORKORDER_DETAIL] (
September 21, 2005 at 12:44 pm
Ok, this is what I need to update
update N_Order set N_Order.status = 2
If N_Order.id = N_Inv.id and any one of the following is true
(N_Inv.TF is not null...
September 21, 2005 at 12:15 pm
Viewing 15 posts - 1 through 15 (of 43 total)