I looked at your blog entry. However, your dynamic_pivot stored procedure will not work for this example. The OP needs to have one row per fruit type & date. Which...

Why?

ggraber (11/6/2008)

---

I've been playing with using a dynamic PIVOT for your case, and it seems like it's going to be a little messy.

I think Ken's solution is the way to...

Use

NULLIF(t.SoldYR2,0)

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx

Is that June 20, 2008 or June 01, 2008?

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx

It would return View also

Is this reliable?

SELECT dates FROM

(

SELECT '$.00 AIIMIE 01 2002' as dates union all

SELECT '$1,764...

If you want to omit time part

select * from tablea where employeeid = '00880187'

and process_date>=dateadd(Day,datediff(day,0,'2008-10-31 00:00:29.000'),0)

and process_date<dateadd(Day,datediff(day,0,'2008-10-31 00:00:29.000'),1)

or

select object_name(object_id) as table_name from sys.columns

where name='column_name' and objectproperty(object_id,'istable')=1

WHERE STATUS>''

select * from...

It is not possible

Make use of the result

select 'delete from '+table_name from information_schema.tables

where table_type='base table'

EXEC dynamic_pivot

'select col3,col4 from table1 where col1=''apple''','col2','sum(col4)'

Get procedure from http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx