Viewing 15 posts - 4,516 through 4,530 (of 7,631 total)
Use Excel or a reporting tool (like Reporting Services or Crystal Reports) for this kind of output formatting.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 8, 2008 at 6:11 pm
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
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 9:56 pm
Show us the code.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 9:44 pm
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/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 8:52 pm
When you Generate the Scripts, make sure the the "Include IF NOT EXISTS" option is set.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 8:44 pm
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
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 8:40 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 8:31 pm
ak (12/7/2008)
Since I am explicitly stating "where recurDays > 0", I thought the rest of the 'and' conditions would not be evaluated (like in programming languages).
Actually, very few programming language...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 8:30 pm
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)
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 7, 2008 at 1:07 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2008 at 7:07 pm
I am still waiting for you to post the XML as an attachment as I requested.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2008 at 6:50 pm
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2008 at 5:54 pm
umanpowered (12/5/2008)
Jonathan Kehayias (12/3/2008)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 6, 2008 at 5:47 pm
Glad we could help
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 5, 2008 at 6:40 pm
Select * From INFORMATION_SCHEMA.COLUMNS
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 4, 2008 at 10:57 pm
Viewing 15 posts - 4,516 through 4,530 (of 7,631 total)