Use Excel or a reporting tool (like Reporting Services or Crystal Reports) for this kind of output formatting.

This is a duplicate post.

Please do not cross-post. Direct all replist to the thread: http://www.sqlservercentral.com/Forums/Topic615353-338-1.aspx

Show us the code.

Here's an excellent article on this very subject, by some guy who is too modest to promote himself here (:)): http://www.sqlservercentral.com/articles/Test+Data/61572/

When you Generate the Scripts, make sure the the "Include IF NOT EXISTS" option is set.

This is a duplicate post.

Please do not cross-post. All replies should be directed to: http://www.sqlservercentral.com/Forums/Topic615332-148-1.aspx

That said, the explicit way to express nested conditions in SQL Serve is to use nested CASE expressions:

select *

from apptview

where 1 = CASE WHEN recurDays > 0 Then

CASE...

Actually, very few programming language...

Actually, a couple of tweaks to noel's version will make it much better:

Drop table #YourTable

GO

Create table #YourTable(

id int

,data char(1)

,date datetime

,RowNum int Identity(1,1)

, primary key (id, RowNum, date))

GO

insert into #YourTable(id,data,date)

...

Looks like you have spaces in your database names, something that I did not take into account. Try this new version and let me know if it works.

Alter Proc...

I am still waiting for you to post the XML as an attachment as I requested.

Sorry, I do not follow your question.

SMO is an API, and it can be used to create Tables and other database objects. However, SMO itself actually uses SQL to...

umanpowered (12/5/2008)

---

Jonathan Kehayias (12/3/2008)

---

I just wanted to point out that my recommendation was to use a default constraint with a value of getdate() which is persisted with the date and...

Glad we could help

Select * From INFORMATION_SCHEMA.COLUMNS