Ohh hell ya!!! It...

Then again....would someone tell me why would I go about generating scripts like the way that was shown here when SQL server itself provides all the necessary options to script...

Nice script there, I too had written a similar script

http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

but the bad thing about mine would be the fact that I had made use of cursors....and also since it was...

I think the system generated would do fine for me.....but informative though ...

and I was wondering why not use the keyword QUOTENAME to get the table name in square brackets...

Are you using SQL Server 2005 Express?

Hey Joseph,

the answer to the question you had...

anu1krishna (5/16/2009)

---

i tried like this

declare @id int

set @id=select top 2 id_num from new_employes order by id_num desc

select id_num from new_employes where id_num=(select min(@id)from new_employes)

but i am...

Hey FoxJazz,

I couldnt really read through all the posts..but from what I have understood , ur requirment seems to be that from the set of records having the same application...

Well Jack,

You might wanna have a look at this stored procedure that I had written a few months back......similar to what you were trying to achieve......

http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

Using the above sp that...

Could you tell us how the following fields overtime1, overtime2,overtime3 are required?

I feel that a single overtime column field would do based on your requirement... Or have you missed out...

if so you could look it up in the sys.columns tables....for the constraint info you could use the sp_helpConstraint followed by the table name to list the column names that...

Are you looking for coulmn information with respect to a table?

Now at one glance I feel that if all you require is the output based on your two paramenters then there is a function which you could make use of.

That...

Now if you would like to generate insert scripts for your table please refer this script that I had created for this very purpose.

http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

well you see if you think writing all the 50 columns is stoping you from going with the above mentioned solution....let me share with you a small tip to counter...