yes 2008 r2 is quite good however if they give more commands on cmd or query should be very well. i hate to use the gui

i forgot to mentioned in my previous reply ,please follow the link given by Lutz and please do not share your data like you did.

Hello,

here we go ,use the below query to get your result .

select a.StockMaster,sum1,sum2,(sum2-sum1) as TQty from

(SELECT tblStockMaster.SmName AS StockMaster, SUM(isnull(tblReceivingD.TotalQuantity,0)) AS sum2

FROM tblStockMaster LEFT JOIN tblReceivingD ON tblReceivingD.StockControlR=tblStockMaster.SmName

GROUP BY...

In sql server you have XP_Servicecontrol which will tell you whether your service is status (running,stopped,etc) and you can use this to start and stop the sql services.

However you need...

attach some screen shot of your problem.

What is purpose of this kind of approach if the server goes down none of the database will be available.

Good Question and this needs lot of parameters needs to be considered while design and you have concern about the network bandwidth.

You have not mentioned which SQL Version you are...

Hi ,

The answer for your question is Yes.

When the snapshot is taken you can see the data at the point of time of your source databases.

When the modification is...

Hi

I managed to fix this issue and i use OPENROWSET to import CSV files into SQL Server 2008 R2

hi thank you for your code , still this code does not give me the exact output as i said earlier , i have 3 column have null value still...

Hi,

Please find the sample file with the data , file has only one row.

due to the constraint on csv upload on this site , i have save my csv...

Hi Eralper,

Yes you are right. however if you try to upgrade the version from CTP to RTM the setup always shows that the upgrade sucesssfully completly. when you check the...

finally i have found the way to upgrade thank you guys

thank you. i have tried many ways to upgrade SQL 2008 R2 CTP after the trail period expired but none of the method got suceed.

can anyone tell me is...

if i understand correctly you need to create a Stored Procedure in your SQL 2005 or later Databases.

Steps :

1 . Open SQL Server management Studio

2. Select you SQL Server...