Why do you need all in...

Jeff Moden (9/17/2008)

---

Thanks, Madhivanan, my old friend. No, haven't written Part II to this article, yet. Got caught up in a new job and can hardly keep up...

Nice Artilce Jeff Moden.

I dont know if you posted Dynamic PIVOT article but here is mine :).

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

Also refer http://www.sommarskog.se/arrays-in-sql.html

amol_j_kothawade (1/8/2008)

---

hi friends

i am using following row number function in my sql server 2005 :

select appno,row_number() over(partition by appno order by appno) from tab

which is giving following result...

OP, when you have time, read this

http://sql-server-performance.com/fk_datetime.asp

Did you mean something like this? (Point 2)

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/11/26/select-columns-from-exec-procedure-name-is-this-possible.aspx

Mike Levan (1/2/2008)

---

Jeff..cud u pls elaborate your method, i didnt follow wht ur doing there?

MAdhavanan.. its not a date am storing but its a number which starts with 4 digit...

Molly Cary (1/2/2008)

---

I can't change the data type in the table because it's used as a free text field, values are based on INR levels for medical records. For reporting...

nayanamoolya (1/2/2008)

---

Hi,

I need to create a cross tab from the existing table

I have table consisting of

name surname month value

abc xyz ...

hb21l6 (1/2/2008)

---

this works fine..

SELECT *, DateRecorded AS Expr1

FROM tbl_ISALOG_SingleUser

WHERE (DateRecorded < GETDATE())

but this doesnt

SELECT...

FYI http://sqlblog.com/blogs/tibor_karaszi/archive/2007/11/28/sorted-views.aspx

Well. Shouldnt it be "I'm just part of the problem Solving"? [:)]

In fact you...

Well except that you often mispell my name 😉

Mike Levan (12/28/2007)

---

How can i check the format of a field where it shud contain values starting with year like

YYYY-23987

YYYY-56567

i want to check if that field is in the same...