Viewing 15 posts - 5,716 through 5,730 (of 7,631 total)
As far as I know.
[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]
August 28, 2008 at 10:51 am
Heh, I made the same mistakes. Here is a correct version:
Select MID,
(((1.0+Dt1/100.0)
*(1.0+Dt2/100.0)
*(1.0+Dt3/100.0)
*(1.0+Dt4/100.0)
*(1.0+Dt5/100.0)
*(1.0+Dt6/100.0)
*(1.0+Dt7/100.0)
*(1.0+Dt8/100.0)
*(1.0+Dt9/100.0)
*(1.0+Dt10/100.0)
*(1.0+Dt11/100.0)
*(1.0+Dt12/100.0))-1.0) * 100.0
from Prod_Issue
This gives the same results as the Excel.
[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]
August 28, 2008 at 10:39 am
Karthik: Product multiplies, Sum adds. What you want is something like this:
Select MID,
( 1.0+Dt1/100.0-1.0
+ 1.0+Dt2/100.0-1.0
+ 1.0+Dt3/100.0-1.0
+ 1.0+Dt4/100.0-1.0
+ 1.0+Dt5/100.0-1.0
+ 1.0+Dt6/100.0-1.0
+ 1.0+Dt7/100.0-1.0
+ 1.0+Dt8/100.0-1.0
+ 1.0+Dt9/100.0-1.0
+ 1.0+Dt10/100.0-1.0
+ 1.0+Dt11/100.0-1.0
+ 1.0+Dt12/100.0-1.0) * 100.0
from...
[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]
August 28, 2008 at 10:20 am
Simple way:
Delete From YourTable T
Where EXISTS( Select * from YourTable T2
Where T.REFNOCOLUMN = T2.REFNOCOLUMN
...
[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]
August 28, 2008 at 10:04 am
As I recall in .Net, you need to switch from SQLClient.net to ODBCClient. (not sure?)
[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]
August 28, 2008 at 9:37 am
Yes, it takes more space. But Unicode/NChar is the solution for this and this is exactly the reason that it exists.
I don't know about the "N" before the quote,...
[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]
August 28, 2008 at 9:33 am
psangeetha (8/28/2008)
Are you using this method currently without encryption??
I have seen it both ways, though I myself may not be actually "using" it. Most of the time...
[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]
August 28, 2008 at 9:11 am
psangeetha (8/28/2008)
Does the below command store the password in encrypted format or plain text??[codee]EXEC sp_setapprole 'test', N'test';[/code]
Plain text. By the way the ODBC Encrypt does not store the password,...
[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]
August 28, 2008 at 9:01 am
Actually, I do notice one difference between your code and the BOL Example. This line:
psangeetha (8/28/2008)
EXEC sp_setapprole 'test',{encrypt N'test'}, odbc
Is actually like this in the example:
EXEC sp_setapprole 'test',{encrypt N...
[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]
August 28, 2008 at 8:51 am
Sadly, I have never had the opportunity to implement the ODBC Encryption feature, so I cannot help you much. Hopefully, someone else here can. If you do figure...
[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]
August 28, 2008 at 8:36 am
OK, off-hand, here is how I would do it (not tested):
use [a]
go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE PROCEDURE [dbo].[CrTr]
AS
BEGIN
SET NOCOUNT ON;
declare @cmd1 nvarchar(1000)
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]
August 28, 2008 at 8:23 am
CrazyMan (8/28/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]
August 28, 2008 at 6:55 am
Helmut Nielsen (8/28/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]
August 28, 2008 at 6:44 am
harmonica1313 (8/27/2008)
...
set @cmd1 = '
use
go
CREATE TRIGGER Tr
...
END'
"GO" is NOT a SQL Server command. It is a client flag/command. In this case it is a flag to SSMA's...
[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]
August 27, 2008 at 11:15 pm
Not unless you have a startup Job or Proc 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]
August 27, 2008 at 10:15 pm
Viewing 15 posts - 5,716 through 5,730 (of 7,631 total)