geetee fucked around with this message at 05:08 on Apr 10, 2009

SELECT
 COALESCE(MPQ.SEC_NAME, MFT.SEC_NAME) AS FUNDNAME,
 COALESCE(BALANCE, 0.0) AS ASSETS,
 SUM(COALESCE(BALANCE, 0.0)) OVER () AS TOTALASSETS,
 COALESCE(PARTSBAL, 0.0) AS ACTIVEPARTICIPANTS

FROM [Complicated FULL OUTER JOIN)

SELECT
 COALESCE(MPQ.SEC_NAME, MFT.SEC_NAME) AS FUNDNAME,
 COALESCE(BALANCE, 0.0) AS ASSETS,
 ( COALESCE(BALANCE, 0.0) / SUM(COALESCE(BALANCE, 0.0)) OVER () ) AS PERCENTOFTOTAL,
 COALESCE(PARTSBAL, 0.0) AS ACTIVEPARTICIPANTS

FROM [Complicated FULL OUTER JOIN)

Squashy Nipples fucked around with this message at 23:07 on Apr 12, 2009

SELECT    bbh.best_nid, MAX(DISTINCT(bbh.best_vid)), bbh.ranked_nid, bbh.ranked_rank, nc.totalcount
FROM      bc_bests_history bbh
LEFT JOIN node_counter nc
ON        nc.nid = bbh.best_nid
WHERE     bbh.ranked_nid = 7966
GROUP BY  bbh.best_nid

+----------+-----------------------------+------------+-------------+------------+
| best_nid | MAX(DISTINCT(bbh.best_vid)) | ranked_nid | ranked_rank | totalcount |
+----------+-----------------------------+------------+-------------+------------+
|     8286 |                       19524 |       7966 |           1 |      25083 |
|     8287 |                        8287 |       7966 |           3 |       7245 |
|     8289 |                        8289 |       7966 |           2 |      13706 |
|     8290 |                        8290 |       7966 |           1 |       3827 |
|     8538 |                        8538 |       7966 |           1 |       2181 |
|     8542 |                        8542 |       7966 |           1 |       1561 |
|    10848 |                       10848 |       7966 |           2 |       1421 |
+----------+-----------------------------+------------+-------------+------------+
7 rows in set (0.00 sec)

cannibustacap fucked around with this message at 22:11 on Apr 21, 2009

begin;
insert into forms.frm_usernames (userid, name_last, name_first) values (7777, 'User XYZ', 'TestTest');
rollback;

CREATE TABLE IF NOT EXISTS `frm_usernames` (
  `userid` varchar(20) NOT NULL DEFAULT '',
  `name_last` varchar(100) DEFAULT NULL,
  `name_first` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Aredna fucked around with this message at 07:39 on Apr 25, 2009

+-------------+
| contract_id |
+-------------+
|         199 |
|         200 |
+-------------+



+--------------+-------------+------------------+
| approvals_id | contract_id | approval_type_id |
+--------------+-------------+------------------+
|            7 |         199 |                4 |
|            8 |         199 |               11 |
|            9 |         199 |                1 |
|           10 |         199 |                5 |
|           11 |         199 |                6 |
|           12 |         199 |                7 |
|           13 |         199 |                2 |
|           14 |         199 |               10 |
|           15 |         199 |                9 |
|           18 |         199 |                8 |
|           19 |         199 |                3 |
+--------------+-------------+------------------+



+------------------+----------------+-------------------------+
| approval_type_id | type           | parent_approval_type_id |
+------------------+----------------+-------------------------+
|                1 | Business       |                    NULL |
|                2 | Legal          |                    NULL |
|                3 | Engineering    |                    NULL |
|                4 | Exploratory    |                       1 |
|                5 | Negotiated     |                       2 |
|                6 | Finalized      |                       2 |
|                7 | Signed         |                       2 |
|                8 | Specs received |                       3 |
|                9 | Test approved  |                       3 |
|               10 | Live           |                       3 |
|               11 | Live           |                       1 |
+------------------+----------------+-------------------------+

select at.type, at.approval_type_id ati, a.approval_date
from dmb_control.approval_types at 
left outer join dmb_control.approvals a 
      on at.approval_type_id=a.approval_type_id 
left outer join 
      (select * from dmb_control.contracts c where contract_id=?) as t1    
      on t1.contract_id=a.contract_id 
where at.parent_approval_type_id='1' and at.approval_type_id != '1'

LightI3ulb fucked around with this message at 21:28 on Apr 28, 2009

[Microsoft.SqlServer.Server.SqlProcedure]
public static int GetNames() {
   // Create a list to keep track of names you've encountered
   var nameList = new List<string>();

   // Create a SqlDataRecord
   var metadata = new SqlMetaData("Name", SqlDbType.NVarChar, 40 );
   var outputRecord = new SqlDataRecord ( new SqlMetaData[] { metadata } );

   using ( var conn = new SqlConnection ("context connection=true") ) {
      using ( var cmd = conn.CreateCommand() ) {
         cmd.CommandText = "SELECT [names] from [Table]";

         using ( var reader = cmd.ExecuteReader () ) {
             while ( reader.Read () ) {
                // Skip the row if it's null
                if( reader.IsDbNull ( 0 ) ) continue;

                var nameColumn = reader.GetString ( 0 );
             
                // Split the values into an array
                foreach ( var name in nameColumn.Split ( ',',
                            StringSplitOptions.RemoveEmptyEntries) ) {
                   // Ignore names you've seen already
                   if( nameList.Contains ( name.ToLower() ) ) continue;
                 
                   // Add the name to the list
                   nameList.Add ( name.ToLower() );

                   // Set the record's value and spit it out
                   outputRecord.SetString ( 0, name );
                   SqlContext.Pipe.Sent ( outputRecord );
                }
             }
         }         
      }
   }

   return nameList.Count;
}

SLOSifl fucked around with this message at 21:20 on Apr 30, 2009