skip to main | skip to sidebar

Sanjeewa'S Tech Page

Thursday, October 18, 2007

Replace NULL numbers to -1 sample SQL

isnull(WO.Production_Order_Id,-1) IsWOCreated


//

SELECT PO.Id,DueDate,isnull(WO.Production_Order_Id,-1) IsWOCreated
FROM ProductionOrder PO left outer join dbo.WorkOrder WO
on PO.Id =WO.Production_Order_Id
Posted by SS - LK at 2:38 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (9)
    • ►  October (1)
    • ►  May (2)
    • ►  April (3)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (29)
    • ►  December (2)
    • ►  October (2)
    • ►  August (3)
    • ►  July (3)
    • ►  June (3)
    • ►  May (3)
    • ►  April (5)
    • ►  January (8)
  • ►  2008 (46)
    • ►  November (1)
    • ►  October (14)
    • ►  August (11)
    • ►  May (7)
    • ►  April (1)
    • ►  March (2)
    • ►  February (10)
  • ▼  2007 (33)
    • ►  December (1)
    • ►  November (7)
    • ▼  October (11)
      • Delete confirmation using javascript
      • Create Comma separate (csv) file type export
      • Replace data value from dataset which is coming fr...
      • changing grid view image acording to the values of...
      • Replace NULL numbers to -1 sample SQL
      • Get the Datakey value from gridview ang change the...
      • Sample SQL Funcion and how its calling
      • Assign value to the Listbox which is in dataset
      • Some Valueble Javascript Validation Code
      • how to insert default value to a object
      • How to give client script msg box
    • ►  September (12)
    • ►  July (2)
 

You like my blog?

Search This Blog

Followers