I have not altered the code. Its same as suggested by you yesterday:

DECLARE @Today DATETIME, @nMonths TINYINT

SET @Today = GETDATE()

SET @nMonths = 12

SELECT MonthEndDate = DATEADD(dd, -1, DATEADD(month, n.n +...

Hi, I have tried running this query,

but this is giving me dates starting from 1year plus from today's date till and back to previous 12months. AS it is starting from...

Thanks for quick reply.

Please suggest for n no of months.

I want to generate the script for all tables in one go not for one by one table

Also i want to generate the insert script for table data rows .

can u plz guide step by step how to do that

10

is there any solution other than this. I dont want to create a table in database. Because as and when i will be running the stored procedure one entry will...

Thanks

steveb. (5/21/2010)

---

What are the datatypes of the columns ?

you could probably us ISDATE() and add the each of the columns to each other.

eg

SELECT ISDATE(col1) + ISDATE(col2)...

All the columns are of type nvarchar

This is not working. Stored prcoedure is returning the query as :

DELETE FROM sectionnumeric

FROM dbo.CreateSectionTableFromString(placementcandidatelanguageproficiency,placementcandidatetrainingsinternshipsprojects,placementcandidatequalificationdetails)

This query is giving lot of errors. I think some syntax mistake is...

DECLARE @Sample

TABLE (

Questionid INTEGER NOT NULL,

type ...

I have one more column in table as remarks.

DECLARE @Sample

TABLE (

Questionid INTEGER NOT NULL,

...

Thanks a ton budy.