Viewing 15 posts - 1 through 15 (of 27 total)
No.Cross database foreign key reference is not supported.
..
October 28, 2009 at 12:04 am
What is the criterion for merging? what happend to the value '123' which was in the column 5 of the second row?
..
October 27, 2009 at 11:21 pm
Have a look at the perfmon.exe and check the important performance counters related to memory.
This link will help you to find out the relavance of some of those counters.
October 26, 2009 at 12:18 am
You can update the Values using the quirky update as follows.
create table #tmp(Date datetime,GrpID int,RemAmt money, Amt money)
insert #tmp Values ('2000-11-28',1111,1000,300)
insert #tmp Values ('2000-12-28',1111,1000,200)
insert #tmp Values ('2000-11-28',2222,3000,500)
insert #tmp Values...
..
October 23, 2009 at 5:43 am
create Table #TableName(Id int Primary Key,TimeValue varchar(20),TimeOrder Int)
Insert #TableName values (1,'06:00AM',1)
Insert #TableName values (2,'07:00AM',2)
Insert #TableName values (3,'08:00AM',3)
Insert #TableName values (4,'09:00AM',4)
Insert #TableName values (5,'10:00AM',5)
Insert #TableName values (6,'11:00AM',6)
Declare @ConfigTime Varchar(20)
Set @ConfigTime='08:00AM'
Select...
..
October 22, 2009 at 11:25 pm
/*
If there are more than one records with the same date, How do you find which transaction happend first? do you have any SrNo/InvoiceNo in the Table?. The following query...
..
October 21, 2009 at 6:35 am
create table #tmp(Date datetime,GrpID int,RemAmt money, Amt money)
insert #tmp Values ('2000-11-28',1111,1000,300)
insert #tmp Values ('2000-12-28',1111,1000,200)
insert #tmp Values ('2000-11-28',2222,3000,500)
insert #tmp Values ('2000-12-28',2222,3000,100)
Select * from #tmp
Update A Set RemAmt=RemAmt-CumAmt
From
(
Select
Date,GrpID,RemAmt,Amt,
(Select SUM(Amt)...
..
October 20, 2009 at 4:55 am
/*
The query in SQL server goes through a number of stages like parsing,name resolving,optimazing etc. before executing. Try catch block is meant only for handling the execution errors. In your...
..
October 20, 2009 at 3:51 am
SELECT * FROM
(
SELECT
TotalRows = COUNT(*) OVER(),
RowNum = ROW_NUMBER()OVER (ORDER BY P.ProviderID),
P.ProviderID, P.OccupationID, P.LastName, P.FirstName, O.OccupationName
FROM dbo.Providers P WITH (NOLOCK)
INNER JOIN dbo.Occupations O ON O.OccupationID = P.OccupationID
WHERE (P.OccupationID = 1)
AND...
..
October 19, 2009 at 11:37 pm
Select convert(decimal(12,5),223.56)
..
October 19, 2009 at 11:24 pm
It is not the problem with Vista. The SQL Server Service account or SQL Server agent proxy account do not have access to the destination system. Is your SQL Serevr...
..
October 14, 2009 at 2:50 am
SELECT
CUSTOMER_ORDER.*,
DEMAND_SUPPLY_LINK.*,
OPERATION.*
FROM
CUSTOMER_ORDER
INNER JOIN
DEMAND_SUPPLY_LINK
ON CUSTOMER_ORDER.ID = DEMAND_SUPPLY_LINK.DEMAND_BASE_ID
INNER JOIN
(SELECT WORKORDER_BASE_ID,MAX(SEQUENCE_NO) as SEQUENCE_NO FROM OPERATION GROUP BY WORKORDER_BASE_ID)OPERATION
ON DEMAND_SUPPLY_LINK.SUPPLY_BASE_ID = OPERATION.WORKORDER_BASE_ID
..
October 13, 2009 at 11:58 pm
If you want to have a row based operation, you need to use a cursor and obviously it will be slower than a set based operation. You can either change...
..
October 13, 2009 at 11:01 pm
update <Table_name> set <column_name>=REPLACE(<column_name>,'ASAMPLE_5_scrShot_2009-01-02_09-15-06.png','')
..
October 12, 2009 at 5:43 am
Did you check the network connections between your servers and are you able to ping to the remote server ? Did you try with assigning a staic port to the...
..
October 9, 2009 at 5:00 am
Viewing 15 posts - 1 through 15 (of 27 total)