Why Would My Int Primary Key Jump To Higher Number
Apr 19, 2008Why would my int identity primary key column go from one day being 847 and the next number being inserted to 49048?
View 2 Replies
ADVERTISEMENT
Reset The Primary Key Number To 1
Oct 4, 2007Hi all... how to reset the primary key to 1?
thanks
Ron
RON
________________________________________________________________________________________________
"I won't last a day without SQL"
Navigate To:Jump To Url Then Jump To Url Again!
Apr 17, 2007I am stuck on this and its happening no matter what I do. I have a huge project that holds tons of reports. Most are sub-reports.
I have 5 sections I will just use one for example
communictions (totals)
jump to report - summary data
Jump to report - detail data.
The when I get to the detail data I always get the error:
The path of the item '(null)' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
I have tried to do all sorts of things and no matter what I do I cant get it to work.
This is a web application using the ReportViewer for the web, SQL Server 2005 SP2
I have searched high and low for an answer to this and nothing works, not even the get instead of the post.
Any ideas on how I can get this to work?
Thanks
Stokh
Using Jump To Report Navigation Option- Jump To The Same Report
Apr 28, 2008
I have a report that uses report parameters and navigation in the textbox.
When I click in the textbox, it jumps to the same report, but I cannot see the report parameters any more(hidden ). I cannot change the report parameters.
When I use only the report paramenters (no navigation option), they appear always during the run time.
How can I do to keep the report parameters visible all the time using "jump to the same report"??
Thank you so much. indyw
Higher CPU Utilization With SQL Server 2005
Jan 16, 2007HI
I am facing a strange problem with SQL Server 2005 . The CPU utilization with SQL Server 2005 is higer by about 70% comapared to SQL 2000.
In the same kind of Hardware and with the DB server up , I performed the following tests
Declare @i int
Set @i = 10
While @i < 100000
Begin
Insert into arup_emp values(@i,'M',0)
Set @i = @i + 1
end
The CPU utilization average on SQL 2005 was 45% and on SQL 2K it was just 25% , I am seeing a lot of people who seems to be facing this problem but unfortunately not seeing any solution to this.
Can anyone through some light .
Please note that I have tried to also see the MAXDOP options, but get the same results.
Please help.
Thanks
Arup
Update Rows With Next Higher Id, If It Exists
Jul 20, 2005I am trying to determine the next registered session of a student so Ican calculate the number of skipped sessions.Scenario: I have a student registration summary table. One row foreach student and the student's registered session. I want to update agiven row with the next higher registered session (into a field callednext_registered_session_skey if the row exists). I can then use thediff of the skeys to determine how many sessions the student skippedfor each registration period.Example: Student X registers each fall for one session for 4 years.The file might look like:STUDENT_ID SESSION_ID SESSION_SKEYNEXT_REGISTRED_SESSION_SKEY123456789 200201 100null123456789 200301 104null123456789 200401 108null123456789 200501 112nullI need to update the NEXT_REGISTRED_SESSION_SKEY so I end up with:STUDENT_ID SESSION_ID SESSION_SKEYNEXT_REGISTRED_SESSION_SKEY123456789 200201 100104123456789 200301 104108123456789 200401 108112123456789 200501 112nullI can then say SESSIONS_SKIPPED = NEXT_REGISTRED_SESSION_SKEY –SESSION_KEY (logically speaking, not syntactically)This is what I have so far as example:UPDATE F_REGISTRATIONSET NEXT_REGISTERED_SESSION_SKEY = (select top 1 nextr.session_skeyfrom f_registration rinner joinf_registration nextron r.student_skey = nextr.student_skey and nextr.session_skey[color=blue]> r.session_skey[/color]order by r.session_skey desc)WHERE STUDENT_ID = '577665705';SELECT student_skey, student_id, session_id, session_skey,next_registered_session_skey, * FROM F_REGISTRATION WHERE STUDENT_ID= '577665705' order by session_skey descRESULTS:STUDENT_SKEY STUDENT_ID SESSION_ID SESSION_SKEYNEXT_REGISTERED_SESSION_SKEY125137 577665705 200404 309 311125137 577665705 200403 308 311125137 577665705 200402 307 311125137 577665705 199804 285 311125137 577665705 199803 284 311125137 577665705 199802 283 311125137 577665705 199704 281 311TIARob(I restricted with the where = ‘577665705' so I did not have to waitto update all the rows)
View 6 Replies View RelatedSSIS Importing XML And Using A TAG From Higher Hierarchy
Sep 25, 2007I want to read data from a XML into SQL Server database tables "tour" and "stop".
There is a 1:n relation between tour and stop.
(a shortened XML sample, relation Tour : Stop = 1 : n)
<Tour>
<Mandator>mein kunde</Mandator>
<TourNoPlan>TNP_1</TourNoPlan>
<TourNo>1</TourNo>
<Stop>
<StopNo>SN_1</StopNo>
<GPSGeoDec>+8.0000,+48.0000</GPSGeoDec>
</Stop>
<Stop>
<StopNo>SN_2</StopNo>
<GPSGeoDec>+8.3000,+48.5000</GPSGeoDec>
</Stop>
</Tour>
I am able to insert elements from <Tour> into the table "tour" with the data flow in the Integration Services. But I need the values from the tag <TourNoPlan> in the rows for the table stop (it is the foreign key) in the second step. How can I get the values in the SSIS from the <Tour> in the dataflow for the different <stop>? It is a hierarchicle structure - normal for a XML. Is there a sample for reading such a XML into a Database? I have tried it with [Tour::TourNoPlan] or similar, but it was wrong. Second try was setting a UserVariable in the tour dataflow to the actual value of the TourNoPlan and using it in the data flow for the stop tags - but only a setting in a script at PostExecution was possible - to late.
I think a very simple problem and the same for each XML Import. Any ideas ???
Thanks and Best regards
Wolfram
How To Get The Value Of System::TaskName Of A Higher Up Level?
May 14, 2007Hi there,
I was wondering how can I get the value of System::TaskName of a higher scope when I have a Master Package that have several sequence task, data flow tasks and execute package tasks. For each task inside this Master Package on the Post-Execute event handler I have a script task that logs the execution of each task.
After running this master package I saw in my db that I have a row for every single tasks executed in the process and not only the tasks that exist in the master package. For instance, for simplicity let's say my master package looks like this:
SQL Task Script
|
Exec Package 2
|
Exec Package 3
|
Exec Package 4
Package 2,3 and 4 have a SQL Task Script with name Execute SQL Task Package 2, Execute SQL Task Package 3, Execute SQL Task Package 4.
Here's what I got in my db:
Execute SQL Task
Execute SQL Task Package 2
Package2
Execute Package 2
Execute SQL Task Package 3
Package3
Execute Package 3
Execute SQL Task Package 4
Package4
Execute Package 4
I see two TaskName variables in the Variable window, one with OnPostExec scope and the other with Execute Package 2 for instance. I want to get the value of System::TaskName with Execute Package 2 scope.
I want to see in my db only the tasks in bold. Any ideas of how can I do this? I hope you understand what I'm trying to achieve.
Thanks!
Migrate Higher Version Of MDAC
Aug 14, 2007Hi Friends,
I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.
This is use of,
I am going to install sql server 2005 express edition advanced services SP2.
Please help me, how can i upgrade higher version of MDAC?
Thanks in Advance
Rameshkumar Thirumalaisamy
Error:... It Requires A Higher Level Edition.
Apr 28, 2006I've read some threads on this topic and all have been solved by installing the SSIS service. This would be fine except for the fact that I already have SSIS installed and working on the server the package is being called from.
I have several scheduled packages that work without error and a few that fail, telling me "Error: ... it requires a higher level edition." Does SSIS need to be installed on the target server as well? Do I need to do a reinstall? Please advise. Thanks.
-Matt
SSIS Higher Level Edition Error When Run In A Sql Job
Dec 27, 2006Hi,
I am receiving the following error in Sql Job agent when I try to run an SSIS package : The task "Create Excel File" cannot run on this edition of Integration Services. It requires a higher level edition. It then goes on to tell me : The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. I have tried reseting the error count to allow for the "errors" , but it stills fails. The job suceeds in Visual Studio, but not when scheduled in Sql Management Studio. Any suggestions?
Thanks,
J.
Group By Customer And Item Higher Sale Price?
Mar 5, 2015I'm developing and sql 2008 view that shows me the last month of sales of every customer and every item sold, the problem is that I need group by customer with the higher Sale Price of every item of the customer, example:
1.If We sold the same item to one customer then it must show just the higher sale price of every item
2.If the same item was sold to the same customer at the same price then it must show just the last sold date record of that item
This is I get :
OrderDate |DebNr|DebName|ItemCode|Descript|Qty|CostPrice|SalePrice|
2015-03-05|0001 |Deb0001|Item-001|Item 001| 3 | 223.10 | 289.00 |
2015-02-25|0001 |Deb0001|Item-001|Item 001| 2 | 220.00 | 286.00 |
2015-03-05|0001 |Deb0001|Item-002|Item 002| 1 | 75.00 | 110.00 |
2015-03-02|0002 |Deb0002|Item-001|Item 001| 1 | 218.00 | 265.00 |
2015-02-27|0002 |Deb0002|Item-001|Item 001| 1 | 218.00 | 265.00 |
This is I need :
OrderDate |DebNr|DebName|ItemCode|Descript|Qty|CostPrice|SalePrice|
2015-03-05|0001 |Deb0001|Item-001|Item 001| 3 | 223.10 | 289.00 |
2015-03-05|0001 |Deb0001|Item-002|Item 002| 1 | 75.00 | 110.00 |
2015-03-02|0002 |Deb0002|Item-001|Item 001| 1 | 218.00 | 265.00 |
This is my code :
SELECT TOP (100) PERCENT OrderDate, DebtorNr, DebtorName, ItemCode, Description, Qty, CostPrice, SalePrice
FROM dbo.VK_SALE_ORDERS
WHERE (OrderDate >= DATEADD(MM, - 1, GETDATE()))
ORDER BY DebtorNr, ItemCode
Under What Kind Of Circumstances,the LSN On The Page Is Higher Than The Actual LSN For This Log Record
Aug 16, 2007I'm reading <inside sql server 2005torage engine> recently.
The author mentioned about " If the LSN on the page is equal to or higher than the actual LSN for this log record, SQL Server will skip the REDO operation" in chapter 5 and section 1.
As we all know,the transaction log will be written before the changes to the database are written.
So i think the the LSN on the page is equal to or lower than the actual LSN for this log record....
Any suggestions?
SQL Server Admin 2014 :: Heap Table Fragmentation Is Higher Than 50
Dec 1, 2014I have bunch of heap tables and the fragmentation seems to be high, i am not sure whether i shall add index for them, as these tables are inserted and updated every day.
View 4 Replies View RelatedMatrix - Centering Higher Level Column Group Values In Viewing Area Instead Of Entire Cell Band Width
Dec 28, 2007I have 2 higher level column groupings of month name and year above my actual date groups. It looks a little weird aligning them left but there is no guarantee that centering them will even allow them to show until I've scrolled right to the middle of the cell width that they occupy.
Is there a feature that comes with, or a well known trick for making them center in the area that is being viewed instead of the potentially very wide cell that they occupy?
Jump To URL
May 8, 2007to open a report in a new window
i looked up the following line of code
=window.open('" & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" & "&rs:Command=Render&rc:toolbar=true','','width=800,height=600,left=10,top=10,resizable=1,menubar=no,location=no,status=no'),_top"
I do not understand what & Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & "myreport" &
this implies.
I have the current report name as
http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000648
and I need to jump to
http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000699
both reports are in same folder IMS-Reports.
Thanks
Jump To Url
Nov 2, 2006I use the "jump to url" in a report that links out to a page on our company intranet. Our internal users have to use http and an external user needs to be routed to the site w/ https. How can I account for this in a report?
View 3 Replies View RelatedJump To URL ....
Apr 2, 2008
Hi...
I want to add two link(navigation) buttons in SINGLE CELL ... if i click on 1st it should navigate to xyz page and if i click on second then it should navigate to abc page...can u pls help me...
Waiting for ur reply...
Roopesh Babu V
SQL Server Admin 2014 :: Restore A Database Of Higher Version To Lower Version?
Sep 1, 2014Is there any way to restore a database of higher version to lower version.
E.g. I have created a database in sql server 2012, created some tables & procedures in that.I took Full backup of that database. Can I restore it to sql 2008r2 or any lower version.
I know direct restore is not possible, I have to use either import or export option or generating script,but i want to know is there any easy step to do so.
Vimal Lohani
SQL DBA | MCP (70-461,70-462)
Jump To URL & Javascript
Oct 23, 2007Hi, I am trying to link to a page outside of reporting services from a report. I am using SQL Server 2005 Reporting Services [Standard Edition]. The hyperlink works if it is a straight URL, however, nothing happens if I modify it to use Javascript so I can open the link in a new window. I have found many posts on the web from others indicating it should be really easy, but I can not get the link to recognize ANY Javascript (also tried a basic alert with no luck).
The Javascript I am using is well formatted. I can place it into a test page and it runs fine. I can also RC and View Source on my report, grab the entire link, put it in a test page and it works fine. It just doesn't work from the report - ?
Any ideas?
Thanks in advance,
Francine
Jump To Document Map
May 9, 2008When you use the Jump to Report feature is there a way to also go to a specific document map link?
View 5 Replies View RelatedJump To Report
Feb 1, 2007Hi
I want to use Jump to Report option under Navigation tab.
I have two reports both with Same parameters and parameters are multiple value selectable.
In Jump to Report this is how I set the parameter value.
LeadershipTeamId =Join(Parameters!LeadershipTeamId.Value,", ")
CostCentreId =Join(Parameters!CostCentreId.Value,", ")
CostElementGroupId =Fields!CostElementGroupId.Value
This works fine if I have only one value selected for CostCentre and LeadershipTeam but when I select the multiple value I get the following error.
The value provided for the report parameter 'LeadershipTeamId' is not valid for its type. (rsReportParameterTypeMismatch)
Am I missing anything here?
Any help would be highly appreciated.
Best Regards
Jump To URL Error
Jul 27, 2007I'm trying to put a hyperlink in a field on a report. I've found the action property and set the "Jump To" box with the following:
="http://dveowb01.wbhq.com/UnitsStatusLog/StatusEntry.aspx?Unit=" & Fields!Unit.Value
I'm getting this error message:
The Hyperlink expression for the textbox €˜textbox24€™ refers to the field €˜Unit€™. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Please help.
Thanks,
Jennifer
Jump To Report
Mar 5, 2007Hi all,
I have created a hyperlink(textbox) with an action property setting of "Jump to report" The report I am jumping to takes 5 parameters. I want to pass 4 of the parameters from the main report and have the user enter the 5th. I have mapped the 4 parameters and in preview mode, everthing works great. In preview mode, the parametrs are passed and the last parameter is left waiting for entry. After deployment, this is not the case. In the deployed state, I simply get an error that parameter #5 is blank. Is there there something I am missing?
regards,
Bill
Jump To Report In New Window?
May 11, 2007Hi all,
Is it possible to use the "jump to report " action and have the report open in a new window?
regards,
Bill
Jump From Every Point On A Report
Dec 4, 2007Hello.
I have a report with a graph in it.
I want to jump to another url when I'm clicking on my report.
I know how to sat the action for clicking inside the report on one of the data number but I want it to jump when I'm ckicking anywhere on the report.
Is there a way to do so?
Thanks.
Question About Jump To URL Function
May 19, 2006Hi !
When using the Jump to URL function, is it possible to open the URL in a new page instance of doing a redirect?
Thanks !
How Can I Jump Out Of An Iteration When Using A Cursor?
Jan 24, 2008Is there a key word one can use to immediately jump out of an iteration when using a cursor, and move to the next record using 'fetch next' cursor?
View 1 Replies View RelatedJump To Report Navigation
Sep 11, 2007
Can I have a report that is nothing more than a parameter and when the user selects from the list it will jump to another report based on which parameter was selected?
I can create a report with a text box that I can click to jump. I'd like to be able to eliminate the click on text box if possible and jump directly from parameter select pull down box.
Thanks.
Jump To Bookmark In Reports
Aug 17, 2007Hi,
Please tell me how to implement the "Jump to Bookmark" in reports,
I mean to say, i have to move to another area or page in a report.
Please provide a sample for the same.
Thanks and Regards
Altaf Nizamuddin
Hyperlink:Jump To Report
Mar 14, 2008Hi,
I have a report that uses Jump to Report and passes Reportname with parameter. Is
there a way to suppress the parameter value in the URL so the user is unable
to manipulate the parameter and execute the changed URL?
This is what I have so far..
="http://<servername>/ReportServer?/<folder>/<reportname>&<parametername>="+Fields!<fieldname>.Value.tostring
because when reports exported to excel, hyperlink path will be displayed and should not display to the user.
Or can we set Hyperline action dyamically?
Thank you.
RSUser
Jump To Report With Parameters
Dec 7, 2007Hello,
I have a report (Report1) with a subreport (SubReport2). The subreport is a barchart. On the data values for the chart, I have a "Jump to Report" action defined. This jumps to another report(Report3) that has some parameters on it. Neither Report 1 nor SubReport2 have any parameters, only Report3.
When I jump to Report3, I would like to have it open up blank with the parameters open to be selected. I don't want to pass in any parameters as I jump to it. This works perfectly when I test it in my Preview pane in BIDS. However, when I upload the report to the ReportServer, when I click on SubReport2 to jump to Report3, I get an error saying
The 'Months' parameter is missing a value
There is no parameter pane for me to choose the parameters (or any other report viewer pane). However, if I open Report3 directly without trying to use Report1 and SubReport2 to jump to it, the parameter pane is there, everything works right.
Does anyone know how I can get the parameters pane to show up when I jump to Report3?
Thanks,
Andy
Jump To URL With A New Target _blank
Mar 10, 2007Hi all,
In Opening a display of invoices in Report Server I have a ULR link in the Jump to URL section under the navigation tab.
html code given : <a href="url" TARGET="_top">my value</a>
I would like have this code html : <a href="url" TARGET="_blank">my value</a>
How can I do it ?
Thanks.