-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have this query:
SELECT COUNT(articles.id) AS count
FROM articles, xml_documents, streams
WHERE articles.xml_document_id = xml_documents.id
AND xml_documents.stream_id = streams.id
AND articles.published_at BETWEEN '2010-01-01' AND '2010-04-01'
AND streams.brand_id = 7
Which just uses the…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I want to save remotely (on a database) the state (visible columns, columns width and order) of a Flex3 DataGrid.
For width and visibility I can simply save them by accessing each column attribute.. ugly but possible..
But for the order? Do I have to create the dataGrid dynamically??
Any idea is…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
We've started to adopt SharePoint 2010, and are starting to manually migrate content from SharePoint 2007 sites to new sites we're rebuilding from scratch in SP2010.
One of the things we previously had supported was to delegate responsibility for managing some of our site columns to a member of the…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a text file in the following format. Each row has variable number of columns.
File:
gi|269201691|ref|YP_003280960.1| chromosomal replication initiation protein gi|57651109|ref|YP_184912.1| chromosomal replication initiation protein…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
With reference to my previous question
Adding columns resulting from GROUP BY clause
SELECT AcctId,Date,
Sum(CASE
WHEN DC = 'C' THEN TrnAmt
ELSE 0
END) AS C,
Sum(CASE
WHEN DC = 'D' THEN TrnAmt
ELSE 0
END) AS D
FROM Table1 where AcctId = '51'
GROUP…
>>> More
