Viewing 15 posts - 1 through 15 (of 19 total)
Better to write a CTE and finalize the values need to compared and then make the join with simple condition.
January 6, 2011 at 2:49 am
Just to maintain unique numbers you can try sequece also.
January 5, 2011 at 7:16 am
Yes, As davidandrews13 mentioned closing parenthesis was missing for datediff function
January 5, 2011 at 6:15 am
Why don't you keep this code in stored procedure and test it? I assume that will work.
January 5, 2011 at 12:14 am
Please provide the DDL of the the table.
January 4, 2011 at 6:29 am
Simple solution could be applying UPDLOCK at the time of selection, which will not allow other sessions to lock the same row.
January 4, 2011 at 3:36 am
An ER diagram will help more to understand the relationships
December 30, 2010 at 12:20 am
An ER diagram will help more to understand the relation ships
December 30, 2010 at 12:16 am
declare @positons table(
vehicle_ID smallint,
date datetime,
x smallint,
y smallint)
insert into @positons
select 1, '1/1/2000 00:00:00', 1, 2 union all
select 1, '1/1/2000 00:01:00', 3, 4 union all
select 1, '1/1/2000 00:02:00', 5, 6...
December 29, 2010 at 11:48 pm
The above query will help you to findout missing invoice code.
December 29, 2010 at 3:52 am
Try this
DECLARE @tblTemp TABLE
(
Patient_code int,
Patient_name varchar(10),
Invoice_code...
December 29, 2010 at 3:51 am
CREATE TABLE Person (
[PersonId] [int] IDENTITY(1,1) NOT NULL,
[PersonName] VarChar(250) NULL
)
create...
December 27, 2010 at 3:31 am
How POD_COUNTRY_CD (SG,CN,IT...) are related with The Tradelane definitions POD_COUNTRY_CD (Any country where Region/Trade = ASPA
,Any country where Region/Trade = SPAC...)
December 22, 2010 at 3:27 am
Viewing 15 posts - 1 through 15 (of 19 total)