Wrox Programmer Forums
|
BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6
This is the forum to discuss the Wrox book Beginning SQL Server 2005 Programming by Robert Vieira; ISBN: 9780764584336
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning SQL Server 2005 Programming ISBN: 978-0-7645-8433-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 20th, 2008, 09:13 AM
Registered User
 
Join Date: Feb 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISNULL FUNCTION

I HAVE A PROBLEM WITH THIS CODE PAGE 195
    SELECT cu.CompanyName,
ISNULL(CAST ((SELECT MIN(o.OrderDate)
FROM Orders o
WHERE o.CustomerID = cu.CustomerID)AS varchar), ' NEVER ORDERED')
AS "Order Date"
FROM Customers cu

i have i return: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'SELECT'.



 
Old February 20th, 2008, 02:12 PM
Registered User
 
Join Date: Feb 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I executed this script in my code and i did'nt get any errors. Are you on Northwind database?






Similar Threads
Thread Thread Starter Forum Replies Last Post
send variable in function to another function schoolBoy Javascript How-To 6 March 3rd, 2007 09:16 AM
How to call javascript function from VB function vinod_yadav1919 VB How-To 0 February 13th, 2006 06:03 AM
The isnull function requires 2 arguments. sinapra Classic ASP Databases 1 August 30th, 2004 07:47 AM
Dates and isNull lic023 Access VBA 3 July 12th, 2004 12:32 PM
retreive function/Line from macro or function? MikoMax J2EE 0 April 1st, 2004 04:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.