Viewing 15 posts - 196 through 210 (of 444 total)
Considering the given facts, Column A will have to be the PK. The Column have to be Unique to qualify for PK.
May 17, 2009 at 9:14 pm
There was no right choice to select so I selected the first option And GOT THE POINT...but the answer is wrong.
Both editions support 50 instances Workgroup Edition supports 16...
May 17, 2009 at 9:09 pm
Empty table should not be the problem. It should be related to the tables with data.
In such case;
Are you changing the default properties in 'Select Source Tables and Views'...
May 15, 2009 at 3:43 am
For systems like this, you have draw a visible line between OLTP and OLAP. You have to store Normalized data in one database and port it into OLAP database on...
May 15, 2009 at 2:24 am
I hope you are not trrying to connect all users on a single instance of SQL Server . Only 32767 Users can be connected concurrently on SQL Server 2005. Normally,...
May 14, 2009 at 5:02 am
I personally think the both solutions performs ons and the same thing... I dont see any difference.
May 13, 2009 at 11:29 pm
Hey... I tried that. Doesn't work if F reports to B.
To Who...?
May 12, 2009 at 9:53 pm
To Jason:
I need to filter the result so that I get all records that has both flags set to 1 and those records that have the isShipping = 0 and...
May 12, 2009 at 9:48 pm
The solution I provided might help. But, as said by other posters, the data structure is required. I posted on my assumption that;
B is descendent of A
E and F are...
May 12, 2009 at 5:56 am
SQL Delta is another option. It performs alot of other things.
May 12, 2009 at 5:46 am
Try this...
with wcte as
(Select *,(Select Count(*) from tmpAddress a where a.entityID = tmpAddress.entityID) rno
from tmpAddress )
SELECT ent.firstname + ' ' + ent.lastname AS "FullName",
addr.addressline1,
addr.addressline2,
addr.city,
stcd.statecode,
addr.postalcode,
addr.isMailing,addr.IsShipping...
May 11, 2009 at 11:04 pm
I think that error handling to be done on the scope of sp. I cannot understand the Primary scope or Secondary scope in your case.
It would be better to...
May 11, 2009 at 10:09 pm
I just give it a shot on the google but no results for Indian aurthor for SQL Server. BLOGS can be found by Indians ( and I guessed that by...
May 11, 2009 at 10:02 pm
CTE will do the job. But need more information about inputs and outputs. For reference, I am assuming the following data structure.
CREATE TABLE #DestinationDept
(
[DestinationDeptID] [int] IDENTITY(1,1) NOT NULL,
[SNO] [int] NOT...
May 10, 2009 at 11:15 pm
Viewing 15 posts - 196 through 210 (of 444 total)