I'm using MS Report Designer 2005 and have created a report that uses a cube, with a dimension set up to convert null values to unknown (nullProcessing = UnknownMember).
When I create a parameter using the checkbox in the graphical design mode's filter pane, Report Designer automatically sets the constrained flag, eg:
When running the report and selecting the 'Unkown' value from the parameter list, the error 'the restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated' occurrs.
How can I prevent the constrained flag from being used, or am I doing something wrong with converting null values to 'Unknown'?
This is what I want to do:1. Delete all tables in database with table names that ends with anumber.2. Leave all other tables in tact.3. Table names are unknown.4. Numbers attached to table names are unknown.5. Unknown number of tables in database.For example:(Tables in database)AccountAccount1Account2BinderBinder1Binder2Binder3.......I want to delete all the tables in the database with the exceptionof Account and Binder.I know that there are no wildcards in the "Drop Table tablename"syntax. Does anyone have any suggestions on how to write this sqlstatement?Note: I am executing this statement in MS Access with the"DoCmd.RunSQL sql_statement" command.Thanks for any help!
Table1:RouteIDRDate Direction RTime Employee_IDArrTimeR16/15/2005Pick6/15/2005 9:30:00 AM14306/15/2005 8:12:00 AMR26/15/2005Pick6/15/2005 3:00:00 PM31686/15/2005 2:28:00 PMR26/15/2005Pick6/15/2005 3:00:00 PM14306/15/2005 1:48:00 PMR26/15/2005Pick6/15/2005 3:00:00 PM19056/15/2005 1:42:00 PMR36/15/2005Pick6/15/2005 3:00:00 PM35066/15/2005 2:16:00 PM__________________________________________________ ______________________________________________Table2:Employee_ID rDateLoginTimeLogoutTime34746/15/20056/15/2005 4:45:00 PM6/16/2005 5:45:00 AM34936/15/20056/15/2005 3:00:00 PM6/16/2005 4:00:00 AM14306/15/20056/15/2005 9:30:00 AM6/15/2005 2:45:00 PM18276/15/20056/15/2005 4:45:00 PM6/16/2005 5:45:00 AM19056/15/20056/15/2005 3:00:00 PM6/16/2005 5:00:00 AM__________________________________________________ ________________________________________________I want to select Employee_ID from Table1 who is also found in Table2,even if there are duplicate records of EmployeeI need a single Query(SubQueries) to fetch the above fieldsNote: Criteria such as RouteID, RTime and ArrTime should not be takeninto considerations whileframing QueriesI faced problem due to there are duplicate records of EMployees(1430)__________________________________________________ ________________________________________________I have tried like this ( as shown below):SELECT *FROM Table1WHERE RDate = cdate('06/15/2005') and Employee_IDnot in (select TAble2.Employee_ID from Schedule Inner Join Table1 onTable2.LoginTime = Table1.RTime and Table2.Employee_ID =Table1.Employee_ID);
SQL State: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection.
Another NT Account (Previously created account) has no problem to connect to the database, however a new NT Account assisged to a new DB role cannot login.
Any special rights required for the new NT Account (at NT or SQL database)?
can any one please let me know what is below mentioned errors i found on my newly installed sql server and also let me know severiarity of this and if you know the solution for this i would wel come all your suggestion.
12/24/2006 05:48:47,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:45,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:45,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:44,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:41,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:41,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:40,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:40,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:40,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:39,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:39,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:39,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:39,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:35,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:35,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:35,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:34,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:34,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:34,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:33,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:33,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:33,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:33,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:32,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:32,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:32,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:31,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:31,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:31,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:30,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:30,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:30,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:29,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:29,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:29,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:28,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:28,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8., 12/24/2006 05:48:27,Logon,Unknown,Login failed for user 'sa'. [CLIENT: 204.10.60.17], 12/24/2006 05:48:27,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.,
since last so many days i found that these kind of errors on sql server 2005.It occurs contineously so it keeps server busy all the time.
I have attached a portion of this error log.Thanks for all your help and the time you took to look at my question.
In a stored procedure I dynamically create a temp table by selecting the name of Applications from a regular table. Then I add a date column and add the last 12 months. See attachment.
So far so good. Now I want to update the data in columns by querying another regular table. Normally it would be something like:
UPDATE ##TempTable SET [columName] = (SELECT SUM(columName) FROM RegularTable WHERE FORMAT(RegularTable.Date,'MM/yyyy') = FORMAT(##TempMonths.x,'MM/yyyy'))
However, since I don't know what the name of the columns are at any given time, I need to do this dynamically.
how can I get the column names of a Temp table dynamically while doing an Update?
I have a SQL2008 database, running Standard Edition 64-bit, database owns by sa, connected to Management Studio using Windows Authentication mode. When I tried to generate scripts from a database, I got the following error messages:-
[Operation is not valid due to the current state of the object. (SqlManagerUI)]
which happened at one particular table. I have reviewed this table definitions are normal, and I could select data from it.
I couldn't find any information anywhere relating to this error messages, except that someone got it when they were trying to change the authentication mode or sa password.
I have a single table that consist of 4 columns. Entity, ParamName, ParamsValue and ParamiValue. This table stores normalized Late Fee related parameters for apartments. The Entity field contains a code that identifies the apartment complex. The ParamName in a textual field that contains the name of the parameter that the other 2 fields define the value for; ParamsValue and ParamiValue. If the Late Fee parameter (as named in ParamName is something numerical then the value for that parameter can be found in ParamiValue else its in ParamsValue.
I don't know if 'Pivot' is the correct term to use for describing what I am trying to do because I've looked at the Pivot examples and I don't see how that will work for this. Using the Table and data as provided below, how would I construct a query so that I get 1 row per Entity in which the columns are the ParamsValue or ParamiValue for the ParamName listed in the column header (for the query)?
Below is the DDL to create the table and populate it.
USE [DBA_UTIL] CREATE TABLE [dbo].[PARAMEXAMPLE]( [Entity] [varchar](16) NULL,
hi, I have settup up sql mail and did the following: 1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook 2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services 3. I used the profile that I created in outlook to test the sql mail but got an error: Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account I do have a valid domain account I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed. I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment. The error is: 19015: The encrypton is required but no available certificat has been found.
Hello, I need to perform an update to one of my columns in my gridView. Is it possible to pass in the "column name" during runtime as a parameter to a stored procedure. I tried doing that but it doesn't seem to work? I might be doing something wrong of course. Can anyone give me some advice on how to do this?
I'm sure that the try part of following code are all executedand the session("isLogin") has set to Truebut it always catch a exceptionand redirect to error1.aspx can't figure it out 1 Try 2 mySqlCon = New SqlConnection(strMySqlCon) 3 mySqlCmd = New SqlCommand(strMySqlCmd, mySqlCon) 4 5 mySqlCon.Open() 6 myDataReader = mySqlCmd.ExecuteReader() 7 8 If myDataReader.Read() = True Then 9 10 11 webPwdMd5 = System.Web.Security.FormsAuthentication. _ 12 HashPasswordForStoringInConfigFile(Me.TextBox1.Text, "MD5") 13 14 If webPwdMd5 = myDataReader.Item("password") Then 15 Session("isLogin") = True 16 'Me.TextBox1.Text = "ppp" 17 Response.Redirect("main.aspx") 18 Else 19 Session("islogin") = False 20 Me.Label1.Visible = True 21 End If 22 Else 23 Session("isLogin") = False 24 Me.Label1.Visible = True 25 End If 26 27 mySqlCon.Close() 28 29 Catch Myexception As Exception 30 Session("isLogin") = False 31 Response.Redirect("error1.aspx") 32 33 Finally 34 35 End Try
The Microsoft SQL Server icon is showing on my task bar but with a white (blank) circle "stamped" over the bottom right of the icon.
To me it seems that the implication is that somehow the server is not being recognized as (local)etSDK.
Resting the mouse arrow on the Server icon displays: unknown - \ - MSSQLServer
Needless to say something is quite wrong and I cannot open nor create ANY DATA while on WebMatrix.
If I right-click on the server icon and select "Start" I get the following error: "Invalid handle" which apparently is error number 6.
Previously, after many try-outs I managed to at least put the server icon on the task bar by making use of a setup.ini file that reads as shown below (and then typing from the MSDE sub directory while in MSDOS "setup.exe").
I have installed sql 7.0 with sp1. when I check the files I saw to more file extra i.e. distmdl.mdf and distmdl.ldf along with system and pubs and northwind database files.
Can any one tell me what are these(distmdl.mdf and distmdl.ldf ) files. Thank you!!!!!
ALTER PROCEDURE dbo.finde @columen_name nvarchar(50) /* ( @parameter1 int = 5, @parameter2 datatype OUTPUT ) */ AS declare @maxcount int,@sql varchar(8000) set @maxcount=(select max(taher)+1 from counter)
set @sql='insert into counter (' + @columen_name +') values ( @maxcount )' exec (@sql)
************************ and this is the error
Server Error in '/NTSOLUTIONS' Application. --------------------------------------------------------------------------------
Must declare the scalar variable "@maxcount". Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@maxcount".
Source Error:
********************************************* so i can not find where is the exact point
I'm running into a situation that has me adding a value of "Unknown" toa reference table. I am being pulled between two trains of thought, andwas curious to get other's input on in. I give an example below.1-) Adding "Unknown" to a reference table is bad. Doing so effectivelychanges the Nullability option of every FK that references the table toa NULLable FK relation.2-) Simply adding a "Not Known/Undetermined" value to the referencetable greatly simplifies things. No schema changes are required, andprograms that use the reference table to populate their drop-downs willautomatically see the new value.Perhaps both approaches are good, but it would all depend of thecontext, the criticality of other FKs that reference the table, how/whenthe data is being used?==============================================EXAMPLE==============================================Assume two tables. Employee & EyeColor, as described below.+===================================+|Employee |+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NOT NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+And let's say that an automated process is being built to import EyeColors from central database. In this process EyeColor may no longer beavailable.With solution #1, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | NULL |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+With solution #2, new (or existing) data is changed as follows:+----------------+------------------+|EmployeeId(PK) | EyeColorId (FK) ||NOT NULL | NULL |+----------------+------------------+|marc | 1 ||dan | 2 ||sonya | 1 ||newemp | 0 |+================+==================++================================================= ===+|EyeColor |+---------------+------------------+-----------------+|EyeColorId(PK) | EnglishName(AK1) | FrenchName(AK2) ||NOT NULL | NOT NULL | NOT NULL |+---------------+------------------+-----------------+| 0 | Unknown | Inconnu || 1 | Brown | Brun || 2 | Bloodshot | Rouge || 3 | Blue | Bleue |+===============+==================+============== ===+*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
When I try to run my package from SQL Server Agent I get the following errormessage:
Message Executed as user: NT AUTHORITYNETWORK SERVICE. The return value was unknown. The process exit code was -532459699. The step failed.
It has nothing to do with security in any way: The package actually succeeds!! (no onErrorEvent is thrown, no Error or whatsoever is logged). The only logging I get is this:
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message PackageStart,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:02,23.08.2006 17:18:02,0,0x,Beginning of package execution.
PackageEnd,KMAUSQL01SRV,NT AUTHORITYNETWORK SERVICE,Test,{3790FAE9-8300-4374-B2B7-6A630A508ED9},{E15D1815-1123-42D5-9D32-75B0237660A3},23.08.2006 17:18:24,23.08.2006 17:18:24,0,0x,End of package execution.
PackageStart -> PackageEnd .... And in Fact the package DOES exactly do what it should! Just that it throws this error anyway!
What can I do to even trace down where the error occurs?? Not to mention fix it?
Hello All!!! I have a 1.1 asp.net applications that has been in production for a little over a year. It is remoted from a webserver --> application server --> that access data server. I am using win2003 servers and sql 2000. Recently, the application has been having an issue retrieving and storing documents to the sql server. When diagnosing the problem I have ran communication testing to make sure the servers are communicating as they should, I have ran the stored procedure to test for retrieval times and/or failure. So far everything has checked out. While researching the issue, I ran across information that suggested changing from the SQLClient provider to the OLEDB provider. All the changes I have tried appear to have no affect. I will mention that this does seem to occur only when retrieving larger files(probably a communication issue which I have my communications staff looking into). Has anyone experienced this issue and maybe know of any possible solutions? Thanks in advance
With this algorithm you can sum up an unkown number of records, so that an aggregation matches a fixed value. If there is not an exakt match available, the algorithm returns the nearest possible value!-- Initialize the search parameter DECLARE@WantedValue INT
SET@WantedValue = 349
-- Stage the source data DECLARE@Data TABLE ( RecID INT IDENTITY(1, 1) PRIMARY KEY CLUSTERED, MaxItems INT, CurrentItems INT DEFAULT 0, FaceValue INT, BestUnder INT DEFAULT 0, BestOver INT DEFAULT 1 )
-- Aggregate the source data INSERT@Data ( MaxItems, FaceValue ) SELECTCOUNT(*), Qty FROM( SELECT 899 AS Qty UNION ALL SELECT 100 UNION ALL SELECT 95 UNION ALL SELECT 50 UNION ALL SELECT 55 UNION ALL SELECT 40 UNION ALL SELECT 5 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 50 UNION ALL SELECT 250 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 90 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 50 UNION ALL SELECT 350 UNION ALL SELECT 450 UNION ALL SELECT 450 UNION ALL SELECT 100 UNION ALL SELECT 100 UNION ALL SELECT 50 UNION ALL SELECT 50 UNION ALL SELECT 50 UNION ALL SELECT 1 UNION ALL SELECT 10 UNION ALL SELECT 1 ) AS d GROUP BYQty ORDER BYQty DESC
-- Declare some control variables DECLARE@CurrentSum INT, @BestUnder INT, @BestOver INT, @RecID INT
-- If productsum is less than or equal to the wanted sum, select all items! IF (SELECT SUM(MaxItems * FaceValue) FROM @Data) <= @WantedValue BEGIN SELECTMaxItems AS Items, FaceValue FROM@Data
RETURN END
-- Delete all unworkable FaceValues DELETE FROM@Data WHEREFaceValue > (SELECT MIN(FaceValue) FROM @Data WHERE FaceValue >= @WantedValue)
-- Update MaxItems to a proper value UPDATE@Data SETMaxItems =CASE WHEN 1 + (@WantedValue - 1) / FaceValue < MaxItems THEN 1 + (@WantedValue - 1) / FaceValue ELSE MaxItems END
-- Update BestOver to a proper value UPDATE@Data SETBestOver = MaxItems
-- Initialize the control mechanism SELECT@RecID = MIN(RecID), @BestUnder = 0, @BestOver = SUM(BestOver * FaceValue) FROM@Data
-- Do the loop! WHILE @RecID IS NOT NULL BEGIN -- Reset all "bits" not incremented UPDATE@Data SETCurrentItems = 0 WHERERecID < @RecID
-- Increment the current "bit" UPDATE@Data SETCurrentItems = CurrentItems + 1 WHERERecID = @RecID
-- Get the current sum SELECT@CurrentSum = SUM(CurrentItems * FaceValue) FROM@Data WHERECurrentItems > 0
-- Stop here if the current sum is equal to the sum we want IF @CurrentSum = @WantedValue BREAK ELSE -- Update the current BestUnder if previous BestUnder is less IF @CurrentSum > @BestUnder AND @CurrentSum < @WantedValue BEGIN UPDATE@Data SETBestUnder = CurrentItems
SET@BestUnder = @CurrentSum END ELSE -- Update the current BestOver if previous BestOver is more IF @CurrentSum > @WantedValue AND @CurrentSum < @BestOver BEGIN UPDATE@Data SETBestOver = CurrentItems
SET@BestOver = @CurrentSum END
-- Find the next proper "bit" to increment SELECT@RecID = MIN(RecID) FROM@Data WHERECurrentItems < MaxItems END
-- Now we have to investigate which type of sum to return IF @RecID IS NULL IF @WantedValue - @BestUnder < @BestOver - @WantedValue -- If BestUnder is closer to the sum we want, choose that SELECTBestUnder AS Items, FaceValue FROM@Data WHEREBestUnder > 0 ELSE -- If BestOver is closer to the sum we want, choose that SELECTBestOver AS Items, FaceValue FROM@Data WHEREBestOver > 0 ELSE -- We have an exact match SELECTCurrentItems AS Items, FaceValue FROM@Data WHERECurrentItems > 0With references to http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73540 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73610 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78015 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79505
Hi all,I have the below user-defined function on mssql 2000 and I can't workout why i'm getting the following error:-----Server: Msg 156, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 15Incorrect syntax near the keyword 'IF'.Server: Msg 170, Level 15, State 1, ProcedurefnCalculateOutworkerPaymentForBox, Line 23Line 23: Incorrect syntax near ')'.----------CREATE FUNCTION fnCalculateOutworkerPaymentForBox(@boxid int)RETURNS moneyASBEGINRETURN (/* if the box is a paperback */IF (SELECT COUNT(BoxID) AS NoOfBoxes FROM OutworkerBoxes WHERE BoxID= @boxid AND BoxCode LIKE '%PAPER%') > 1/* If the books are paperback, charge 15p each and add on 30p for adescription book to make 45p */SELECT ((endref - StartRef) * 0.15) + (NoOfDescriptionBooks * 0.30)FROM OutworkerBoxes WHERE BoxID = @boxidELSE/* If the books are normal, charge 25p each and add 20p on fordescription books to make 45p */SELECT ((endref - StartRef) * 0.25) + (NoOfDescriptionBooks * 0.20)FROM OutworkerBoxes WHERE BoxID = @boxid)END-----Below is the sql for the table it works with:-----CREATE TABLE [OutworkerBoxes] ([BoxID] [int] IDENTITY (1, 1) NOT NULL ,[OutworkerID] [int] NOT NULL ,[ImportedBy] [int] NULL ,[StartRef] [int] NOT NULL ,[endref] [int] NOT NULL ,[DateIssued] [datetime] NOT NULL ,[BoxCode] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,[DealerID] [int] NULL ,[StatusID] [int] NOT NULL ,[IssuedBy] [int] NOT NULL ,[BoxNotes] [nvarchar] (200) COLLATE Latin1_General_CI_AS NULL ,[DateImported] [datetime] NULL ,[NoOfDescriptionBooks] [int] NOT NULL CONSTRAINT[DF_OutworkerBoxes_NoOfDescriptionBooks] DEFAULT (0),CONSTRAINT [PK_OutworkerBoxes] PRIMARY KEY CLUSTERED([BoxID]) WITH FILLFACTOR = 90 ON [PRIMARY]) ON [PRIMARY]GO-----If anyone can advise me i'd be most grateful.Thanx in advanceJames
I have a client using SQL 2k, SP2 (due application requirements, SP3 is notan option - the application vendor will not specify why). We are receiving:[Microsoft][ODBC SQL Server Driver]Unknown token received from SQL ServerConnection BrokenThere doesn't appear to be any rhyme or reason as to why this is happening.And...it shows it's ugly head at random places during execution. Has anyoneexperienced this also, or have any ideas on what to look for? I have seennumerous suggestions stating to upgrade from MDAC 2.6 to 2.7. At thispoint, I'm not sure if thats an option based on the vendors application(which by the way they no longer support!).Any ideas will be greatly appreciated.Greg
I don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).
We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.
I recently tried Re-Installing SQL Server 2005 and setup fails with the following error message. I found a forum that instructed me to make sure that the Distributed Transaction Corrdinator Service is started and that the NT AUTHORITYNetworkService is set under the Log on as tab. I verified both of those settings in my services snap-in under the management console. Looks like setup is failing during this section: Integration Services - Configuring Components...
------------------------------ Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80131501
I have the old age question of how to process a string parameter that is passed to a Stored Procedure that has an unknown number values. The example below has 5 values but it could be anywhere between 1 and 20.
I basically need to extract each value to Insert these values into the appropriate tables.
In the SQL 2000 days I use to do this with some T-SQL code that determines where the comma is and then I get the value and so on.....
I have read somewherethat this can be achieved using the XML Data Type.
Can someone show me that or atleast get me started on how to achiev this?
This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++ A connection could not be estabished to server--Timeout expired Please verfy SQL Server is running and check your SQL Server registration properties and try again. ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.
I have a package which imports text files in a directory. The problem I am having is that the text files have differing numbers of source columns. Can anyone example me some script which handled differing numbers of source columns for a dts package...
