In first place, how could you able to pass an empty string to an int parameter? Unfortunately, i don't have the box right now to test for it. ...

You can build an UPDATE statement like...

UPDATE AnyTable SET Col1 = REPLACE( Col1, '"', '' ), Col2 = REPLACE( Col2, '"', '' )

Note: It will not only update the...

My mistake,....

CREATE PROCEDURE Test

@employee int = NULL

AS

SELECT * FROM Employees

WHERE...

Thanks, that worked...

Why don't use this....

CREATE PROCEDURE Test

@employee int = NULL

AS

SELECT * FROM Employees

WHERE EmployeeID = @Employee or @Employee IS NULL

You have to explicitly convert the datetime ixl_expire_date_ext column to character data type since case statement could only return a value of same data type.

The case statement should...

Its my pleasure...

SQL Server Installer, by default, installs in the windows drive....(That doesn't mean, the installer will upgrade the existing instance).

Just go through the installation from the start, when you...

Jeff Moden (10/29/2007)

---

Greg,

Lot's of folks keep a bit of handy test table code around for these types of tests. It's built using the same method I showed you to...

Could you help us by providing sample script with data and the output that you want?

2.5 hours too much for a file of size 26MB ...I've been importing files with 30MB+ in just 2-3 minutes. I mainly use Transfer Data and Bulk Insert tasks...

When exactly you're encountering with this (on what page)?

You can get the management tool for SQL Express also. If this is not possible, then you need to create a batch file that runs dtexec command line utility.

Bret A Schuhmacher (10/29/2007)

---

I just hit this myself. I need to maintain my MSSQL2K install and run MSSQL2K5 simultaneously on the same box. The MSSQL2K5 sees the MSSQL2K...

Yes it is possible..

FROM Table1 INNER JOIN Table2 ON ( CASE Table2.ProductType WHEN 'Datasheet' THEN Table1.Datasheet WHEN 'Manual' THEN Table1.Manual ELSE 'Unknown' END ) = 'xxx'