1. Add the required column Address to the table

ALTER TABLE Customers ADD Address VARCHAR(1000) NULL

2. Run the update query

UPDATE Customers SET Address = COALESCE(add1, '') + COALESCE(add2, '') +...

SELECTB.*, O.Orders

FROMBooks B

INNER JOIN

(

SELECTbk_no, COUNT( * ) AS Orders

FROMordered_items

GROUP BY bk_no

) O ON B.bk_no = O.bk_no and O.orders > 2

Use CHAR(10) to add newline character...

Here is the one of the ways to achieve the weekly results

SELECTID, [Name],

SUM( CASE WHEN CEILING( DATEPART( DAY, [Date] ) / 7.0 ) = 1 THEN Qty ELSE 0 END...

1. Create a SSIS/DTS Package

2. Schedule the package

ALTER TABLE Staff ADD StaffCode varchar(10) NOT NULL CONSTRAINT Staff_StaffCode_df DEFAULT(' ');

peterwliu (11/2/2007)

---

It is assumed the max database size for MSDE 2000 is 2GB. But actually I am able to save more than 2 GB to an MSDE database, now its...

..Check whether the SQL Server is running or not

..Check on which port the server is listening

..Try connecting through EM or QA

..Check the connection string used in VB application

Here it is....

SELECTU.UserID, U.UserName, U.ManagerID, M.UserName AS ManagerName

FROMdbo.Users E

LEFT JOIN dbo.Users M ON E.ManagerID = M.UserID

Is this what you looking for....

CREATE PROCEDURE uspTest

(

@Param1 varchar (10),

@Param2 varchar (2) Output,

@Param3 varchar (20) Output,

@Param4 varchar (50) Output,

@Param5 varchar (100) Output,

@Param6 varchar (100) Output,

@Param7 varchar (50) Output,

@Param8 (50) Output,

@Param9...

May be I could have learned a little bit on Reporting Services:cool:

May be dumping data in a temporary table and returning from it could help?:hehe:

Thanks for the appreciation...

Just use case statement in #view1 as

SELECT .....,

( CASE WHEN PurchaseDescription = 'USB' THEN -Cost ELSE Cost END ) AS Cost2

FROM .....

I guess, internally TRUNCATE is more or less like DROP....CREATE statements, so obviously the second one should be faster....:cool:

What Microsoft said is absolutely correct...

I just clarified the differences between the service packs, thats what you asked for.

Going by your first post, I could see there aren't any differences...