You dont need a cursor to get column names

Refer point 5

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

As always I would say do this in your front end application if you want to show it there

or in SQL Server 2005, you can also use

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

What do you get this for?

select b_name from historical.books

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/05/13/simulating-undocumented-procedures.aspx

http://sql-server-performance.com/Community/forums/p/28631/152790.aspx

DECLARE @PartSurrName varchar(20), @ArrayString nvarchar(2000)

SET NOCOUNT ON

CREATE TABLE #temp1_PBMVR

(

ID int, Type char(2) NULL,ExtractDate datetime, Col varchar(20),jan varchar(15), feb varchar(15), mar varchar(15),...

aswanidutt.dasara (11/3/2008)

---

hi

sorry i forgot it , this is the updated one

ex:

create proc sp_books_outlet

@booknames varchar(100) output

as

select @booknames =b_name from historical.books

declare @booknames varchar(100)

exec historical.sp_books_outlet @booknames output

select @booknames

i have just...

Also leanr to use proper data types to store data

Also see if you want this

select id, name, changedate

from table1

where changedate > DATEADD(DAY,DATEDIFF(DAY,0,GETDATE()),-5)

budbeth (10/31/2008)

---

If it were mine, I would do the following:

1) one table with the Customer info

2) one table that has Customer number & the four Ind fields combined together...

nikhil.pereira (10/31/2008)

---

Hi,

I need to convert a julian date (YYYYDDD) to dd mon yyyy format. Below is the sql which does the conversion

select

convert(varchar,

...

mikemireku (10/30/2008)

---

in Access, you can use the following sql statement to format a number:

format(number,"0000") as result

An example of result could be 0023, rather than 23

WHen doing in SQL Server, I...

peitech (10/31/2008)

---

I tried an example from here, and received a more useful error:

Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a...

ISDATE() is not reliable

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

Becuase it is an interview question 😉