Programmabilities Blog

• SELECT * FROM ES202_RUN_LKP WHERE EndDate BETWEEN CAST('01/01/2005' AS DATETIME) AND CAST('01/11/2008' AS DATETIME)
• SELECT DISTINCT * INTO ##temp3 from ##temp2 --Use this if I want to INSERT rows AND create the destination table.
• WHERE ##temp1.Area <> ##temp2.Area -- The 'WHERE <>' stops a cartesian join.
• SELECT * INTO ##temp3 FROM (SELECT * FROM ##temp1 UNION SELECT * FROM ##temp2) un
• strSQL = "IF OBJECT_ID('tblTempNIS_Qtrly_SumByRUN_and_crc', 'U') IS NOT NULL DROP TABLE tblTempNIS_Qtrly_SumByRUN_and_crc" ' This is not really a temp table because no #; so must DROP. It's a helper table. Couldn't use a temp because mData's Clear lose the data for the next query's use of it. ' The ", 'U' " is optional; it just insures that the object is a user table and not, for example, a sproc or other type of object.

• 'To get all information about the @@Error value that is returned in the output parameter 
  'From Master database 
  'SELECT * FROM sysmessages WHERE Error = 2627 'type value in rdoQy(3) here

• --NWDSQL.BmrkSource.PendingPublish is empty for 2003-2004. Thus do this to populate it with rows from the other table:
  INSERT INTO BmrkSource.dbo.PendingPublish
  SELECT NEArea,IdentifierCode,EndDate,NumberOfPeople,Week,ItemCodeID,Ratio --Note: Published has 1 extra column at the end so I must list these out.
  FROM NELausData.dbo.Published
  WHERE NELausData.dbo.Published.EndDate LIKE '2004%'
  OR NELausData.dbo.Published.EndDate LIKE '2003%'

Labels: sql

- posted by programmabilities @ 22:00 1 comments links to this post