Viewing 15 posts - 4,486 through 4,500 (of 7,631 total)
Its pretty hard to understand why your SAS and SPSS users would want to wait for SQL Server to export to Execl, then import from Excel when they could just...
[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 11, 2008 at 11:23 am
Greg Edwards (12/11/2008)
Grant Fritchey (12/11/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 11, 2008 at 11:11 am
Right. Never mind... :blush:
[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 10, 2008 at 7:49 pm
Heh. Oops.
With cteNav as (
Select NavigationID, NavigationText, NavigationID as Root
From Navigation
Where ParentNavigationID IS NULL
UNION
Select NavigationID, NavigationText, P.Root as Root
From Navigation...
[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 10, 2008 at 7:30 pm
I think that this will do it.
[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 10, 2008 at 7:29 pm
Ch. Arshad (12/10/2008)
Hi Steve,Thank you for your reply. Sorry i didnt copied the whole stored procedure because the stored procedure is bit lengthy. Please find the procedure below...
Actually, Steve asked...
[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 10, 2008 at 5:04 pm
Also, it would be helpful if you could supply the Table DDLs (just script them out, if necessary) and some sample data.
[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 10, 2008 at 4:06 pm
In SQL Server, the best way to optimize loops is to replace them with Set/Table operations.
[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 10, 2008 at 3:56 pm
Agreed. What I posted is not anything like a complete solution. However, if you just want a quick way to check for column changes, this is a free...
[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 10, 2008 at 10:42 am
Well, the scripts are not objects and the only thing that can turn them into objects is to execute them in SQL Server. This of course turns them into...
[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 10, 2008 at 10:37 am
Well if you've already got a UTF-16 TO UTF-8 conversion routine in .Net, you could just make a SQLCLR assembly from that.
Thinking about it, there are ways to do it...
[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 10, 2008 at 8:07 am
[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 9, 2008 at 8:39 pm
Here's a start:
Print 'changed in New:'
Select * from MyTests.INFORMATION_SCHEMA.COLUMNS
EXCEPT
Select * from Util.INFORMATION_SCHEMA.COLUMNS
Print 'changed from Old :'
Select * from Util.INFORMATION_SCHEMA.COLUMNS
EXCEPT
Select * from MyTests.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 9, 2008 at 8:15 pm
Here is the equivalent of your function in T-SQL:
create Function SMA_EOD(@Commodity as Varchar(25), @TrdDay as DateTime, @period As Integer)
Returns Integer AS
Begin
Return (SELECT TOP (@Period)
Case When Count(*) <...
[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 9, 2008 at 7:54 pm
Are you overwriting just user databases, or the whole SQL server Instance?
[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 9, 2008 at 4:41 pm
Viewing 15 posts - 4,486 through 4,500 (of 7,631 total)