-
- Moving Average using Select Statement or Cursor based?
by djun_kang
- 14 Replies
- Last post
by Kent Waldrop Jl07
- ID DATE(dd/mm/yy) TYPE QTYIN COST_IN_AMT COST_OUT_AMT(MOVING AVERAGE) 1 01/01/2007 PURCHASE 10 1000 2 01/01/2007 PURCHAES 5 1100 3 01/01/2007 SALES -5 *TobeCalculated 4 02/01/2007 Purchase 20 9000 5 02/01/2007 SALES -10 *TobeCalculated 5 02/01/2007 purchase 50
-
- foreign language/function sequence error problem
by bilioskatsaros
- 9 Replies
- Last post
by bilioskatsaros
- Am using sql 2000 to store data in the greek language. Using delphi built program to enter the data. The delphi program communicates with sql server via the ODBC connection I created. When I type in above 150 characters in a varchar column that can hold 600, the message (odbc manager - function sequence error) appears and does not allow me to save. However if I type in the english language, it sav
-
- Combining the dates
by mitasid
- 12 Replies
- Last post
by rusag2
- Hi Guys
I have got two columns- one is the year and the other is the month number. I need to combine these two columns so that they form a date
For Ex
Year Month CombinedColumn
2000 11 2000/11
2003 01 2003/01
I am using SQL Server 2005
Thanks
-
- Finding table type (System/User) from INFORMATION_SCHEMA
by EvilPenguin
- 6 Replies
- Last post
by EvilPenguin
- Hi, I have a (hopefully) simple problem: I'm to get a list of User tables (as opposed to System tables, not sure if I'm using the correct terminology here) for the user to select from, with: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.Tables WHERE table_type = 'BASE TABLE' However, I've found that on some servers that this returns System tables too, but as the user will only be concerned with User t
-
- Reporting Wizard Error
by Audrey N. T.
- 0 Replies
- Last post
by Audrey N. T.
- I am getting the error below everytime I get to the Choose Table style.
Key cannot be null
Parameter name: key
I don't know why I am getting this. I have not messed with anything involving my stylestemplate.xml
Before I get this error a message box opos up saying: "Specified argument was out of range of valid values. Parameter name '0' not a valid Value for 'value'
-
- disable trigger syntax?
by o00oo00o
- 5 Replies
- Last post
by o00oo00o
- Code Snippet
CREATE PROCEDURE Staff_NoteGroup_insert
(
@staffID AS int ,
@owner AS int ,
@subject AS varchar ( 256 ),
@message AS varchar ( 512 ),
@date_add AS DateTime
)
AS
BEGIN TRANSACTION SERIALIZABLE
DECLARE @id as int
SELECT @id = ( SELECT MAX ( id ) FROM Staff_NoteGroup ) + 1
IF @id IS N
-
- Identity Specification limit
by David_Wilson
- 2 Replies
- Last post
by David_Wilson
- what happens when a column marked as Identity Specification reaches the limit for example, I have some code tables using tinyints as keys, the actual number of entries will be 20 or so but there is some volatility, so eventually the 255 limit will be reached, what happens then
the same thing applies to ints or bigints used as keys, eventually the database must run out of numbers
information
-
- Date Range filter
by Galin Iliev
- 4 Replies
- Last post
by Dave Balsillie
- Hi guys,
I need to filter result in MDX query by passed Start Date and EndDate
I come up with following solution
-
- Restore to a new database failed
by insurancefusion
- 4 Replies
- Last post
by insurancefusion
- Hello, I have a database backup taken from SQL Server 2005. I originally had placed the backup into a file in My Documents, but when I went to locate the backup file there (C:/Documents and Settings...), the folders would not expand. So I moved the backup to the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup directory and was able to select the file there. When I try to restore this fi
-
- Transaction log backup error
by JulieShop1
- 6 Replies
- Last post
by Sue Hoegemeier
- I've created 2 new jobs in Microsoft SQL Management Studio - one for full backup of database, and another - for backup of tran logs. The full backup is scheduled to run once every morning, and it runs just fine. However, tran log backup, which is scheduled to run every hour, has some problems. Sometimes it runs successfully 3-4 times and failing after that with this error:
Executing the query &
-
- Transaction log backup error
by JulieShop1
- 6 Replies
- Last post
by Sue Hoegemeier
- I've created 2 new jobs in Microsoft SQL Management Studio - one for full backup of database, and another - for backup of tran logs. The full backup is scheduled to run once every morning, and it runs just fine. However, tran log backup, which is scheduled to run every hour, has some problems. Sometimes it runs successfully 3-4 times and failing after that with this error:
Executing the query &
-
- Upgrading SQL Server 2000 Enterprise Edition to SQL Server 2005 Standard Edition
by Buk usu
- 5 Replies
- Last post
by Arnie Rowland
- Hi,
I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)
The Instance has many logins and jobs etc and I dont want to loose those
A document or some advice on how to go about it would help
Thanks
-
- Error installing SQL Server 2000 Developer Edition
by Hardin77
- 2 Replies
- Last post
by Hardin77
- Hello, I hope someone knows the answer to this issue. I am trying to install SQL Server 2000 Developer Edition and once I get to the screen that is asking for the SQL Server instance and Login Information I receive the following error when trying to proceed.
(Report Server database is a different version and cannot be used for this installation)
I have installed reporting services 2000 devel
-
- Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of '
by sb001
- 8 Replies
- Last post
by Tulkinghorn
- When I deploy the cube which is sitting on my PC (local) the following 4 errors come up:
Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations. 0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'AdventureWorksDW'
-
- Scaling width of report to fit to page width
by pamt1984
- 3 Replies
- Last post
by Teo Lachev
- Hi, I've a report projects where each report has a number of columns and the spec is to have all the columns print-out on the same page. Is there a setting that will auto-scale these columns to fit to the page or will I have to edit the font size and widths manually on each report to fit to the page Thanks for any comments.
-
- Trigger on Select?
by Scott Pascoe
- 1 Replies
- Last post
by Arnie Rowland
- Hi,
I'm using Microsoft Identity Integration Server and want to be able, within SQL 2005 to know when MIIS selects data from a table. I've found the APP_NAME() function to be able to identify that the app is MIIS, but I'm stuck with figuring out how to trigger a response on the select.
If you have any experience with MIIS, you will know that it supports reading information from a Del
-
- SSRS Report Designer Background Image does NOT align with Text in preview
by RobDob
- 2 Replies
- Last post
by RobDob
- Hi,
I'm using the SSRS report designer within VS2005 and I have a .rdl report that I have placed a background form as an image background. I then have text placed on top of the form, the problem is that everything is aligned within the report designer layout view but when I go to view the report in report preview the text no longer remains vertically aligned within the background form.
-
- Splitting a comma delimited string
by Krishna.S
- 3 Replies
- Last post
by Krishna.S
- I have a string like say: '3:4:5:4,2:4:1,4:1:2:5:2'. Now I need to split the substrings delimited by commas. So my final output shall be 3:4:5:4 2:4:1 4:1:2:5:2 I did write a piece of code to achieve the same, but I feel its not so efficient. Can anyone suggest me a better way, if any My code is as follows: Declare @person as varchar(255), @cnt smallint,@loc smallint,@prevloc smallint, @str varc
-
- Clearing parameter input
by Roy2331
- 7 Replies
- Last post
by Roy2331
- Hi everyone,
I have a question that I believe should be simple to answer yet I cannot find the answer anywhere. I am trying to make it possible for my report to clear the input box whenever the report is run or when anything in a dropdown list is selected. The reason why I want this is because my report has a dropdown list that inputs date ranges for "quick" report info. The other op
-
- SQL Server Management Studio Express 2005 can't see SQL Server Compact
by Trushar
- 4 Replies
- Last post
by Paul P Clement IV
- Hi,
I am very new to SQL Compact. I am trying to create one database which can work on the desktop application and also on a pda application. I want to create the database but I am unable to start without Management Studio. Can you guide me to the right tools so that I can create database, view it and manage it use something like Management Studio Express.
Also one more question is if my dat
-
- to microsoft
by elzamek
- 0 Replies
- Last post
by elzamek
-
- TOP N + Others (Need your Help)
by Ashok Ojha
- 10 Replies
- Last post
by Lisa Nicholls
- I want to make something like this: TOP 3 Sellers! Seller Profits ----------------------------- Maggie 130 John 70 Mike 30 Others 200 ------------------------------- TOTAL 430 Showing the TOP 3 Sellers it's easy using the TOP N filter, the problem comes when I have to show Others of sellers (the ones not included in the top 3) grouped in a row. My dataset it's linke
-
- Row data can`t be set _ native exception
by besharah
- 2 Replies
- Last post
by besharah
- Dear brothers, still have problem with .net compact framework 1.1 (2003) when i try to sync the data between sqlce and sql server 2000 " not from the first time some times from several times of using the syncronization"
is there any services pack for sql ce
what is appropriate cab file(.NET COMPACT FRAMEWORK, SQLCE etc is ARMI,ARM4....) version for windows mobile 5 with int
-
- Time dimension limits kills performance
by Philippe Cand
- 9 Replies
- Last post
by Philippe
- Hi,
I have a cube with a fiscal time dimension like that:
Year = 2005, 2006, 2007
Quarter = 20051, 20052, 20053
Then months and weeks using format like 200501, 200502 etc.
Cube is partitioned by quarters, 12 partitions in total.
Now what puzzles me is this:
- When I query this from an Excel pivot and set no limit on the time dimension so I get something like total 2005, 2006 b
-
- A question on @@IDENTITY
by Chester03
- 3 Replies
- Last post
by Waldrop
- There is a stored procedure in our partner's application on MS SQL 2005 server like this(simplified):
Create Proc sp_SubmitData
{
@data int
@ID int OUTPUT
}
AS
BEGIN TRAN
INSERT INTO dataTable (data) VALUES(@data)
-- Check @@ERROR
SET @ID=@@IDENTITY
COMMIT TRAN
RETURN 0
In most cases @ID returns the primay key of newly inserted row in dataTable. But in so