Hi
I can't work with my sql server 2000,
When I try to open a table I get the message:
"The query cannot be executed because some files are missing or not registered.
run setup again to make sure the required files are registered.
I uninstall and install again (few time)
But all the time i get this message.
Does any one know who to fix it??
Thanks
Efrat
I am using 6.5 and on this i used different program
and people execute query
Can i place a trace to show what query is being executed from which program and at what time
Meaning the syntax of it and by whom
I start tracing and it paging file becomes to large
sej
Anyone know what causes this?
When trying to deploy a package using the deploy wizard, following error is received:
===================================Could not save the package "H:SSISRSlogRSExecutionLog_UpdateinDeploymentRSExecutionLog_Update.dtsx" to SQL Server "xxxxxxxxxxxxxxxxxxxxx". (Package Installation Wizard)===================================No description found------------------------------Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)
I'm trying to import XML Data from a .xml file and then running openXML command to insert relevent data into SQL server 2005.
First I'm importing XML records with help of Script Task(In SSIS) in batch of 1000 records in temporary String n passing this to Stored procedure ,which parses XML String with help of "sp_xml_preparedocument" .This SP it gives following error..
"An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name."
I'm clueless about error,can some someone guide to workaround?
I was in the process of migrating a server from one physical box to another. They are identical drive setups, same OS (2003), same SQL install (2005). Our server team did a 'PlateSpin', which copies the drives from one server to another, as long as the files are not in use. I did not reinstall SQL on the new box, i let the 'PlateSpin' tool copy everything over for me. I then stopped the SQL services on the old server and new server and copied over all of the system database (.mdf & .ldf) files. As soon as i started up the services on the new server, it looked great with one exception. The TempDB was only showing one datafile. When i queried sys.master_files, it was showing me 8 TempDB files. I tried restarting the services, but i still saw the same, only 1 file. I then tried to re-add TempDB files with the same name, but it would error saying they already existed. In turn, i could add new files with different names and they showed up fine. However, on a restart, they would not show up in the properties of the TempDB.
When i queried, sys.master_files again, i now had 16 Temp db files listed in the results. I deleted all but the original single file that was recognized out of the sys.master_files table and re-added the additional 7 files with he original names, restarted the service and then they all appeared.
My Snapshot Agent for SQL Server 2005 sometimes does not fully complete. I am expecting around 2073 files in the snapshot folder but only get 492 (this number does change). I have immediate_sync set to true, so I should get a full snapshot every time. It seems to quit after all data has been BCP'ed out and before the schema generation starts. I do get the "The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active. " message in the MSSnapshot_history table.
I am guessing that there is some sort of blocking that is preventing the snapshot agent from continuing and then it times out and dies. But that is a total guess as I have not been able to observe the behavior, only the outcome.
Any suggestions to what the cause is or how I can fix it?
Thanks, Amy
I want to skip running the SSIS data flow task when the source file is missing. We have a scheduler that copies the source file to the staging area. This SSIS package runs as SQL server job. So when a SSIS package fails due to missing file the remaining steps in the SQL scheduler won't execute. I want to handle the missing source file condition grace fully. Please advise.
Thanks in advance.
Hi All,
I don't know if anyone faced this issue. We are having a strange problem. Our process was working well when it was implemented on 32 bit processor.IT ran perfectly for 6 months with out a problem. But when we moved the packages to a 64 bit machine, this issue along with some other issues started to show up.
The issue is we are missing files in the source folder.
Our process is designed such that a source process, brings in a file and updates a status for the file in a audit table. The ETL process picks up the file, then assigns the status as €˜running€™ when SRC process is complete and loads into Target DB, and updates ETL status to complete. But current problem is the ETL is losing files after it assigns the status as running. When we looked into the DB weather the data is loaded, we could not find any data related to these files.
we are have mapping level parameters for source path and target path.
We are using a For Each Loop task, and processing files(which are simple flat files) in the source path. The file name is stored in the mapping level parameter. Once the file is process we are moving them into a target path.
Our src and target file paths are on the same drive, just have src folder, inside src folder we have processed folder and failed folder. So files are picked from the source folder and moved into processed folder after processing. The files are not even moved to a failed folder.
There are lot other processing going on this box, and the trend observed is that when more processors are running at peak hour, the missing files€™ count is more.
Right now we are refetching those files, as a work around, but does any one has any suggestion why this is happening or any better implementation suggestions?
Thanks
Hello All,
I have a package in which I have enabled "Package Configuration".
When I run the package i am sure that it reads the configuration file and executes the package correctly.
However if I remove the configuration file, the package still executes correctly with the settings which were used at the time of development.
I have event handlers for OnError and OnWarning and both these are NOT invoked.
IMO, this is incorrect behavior because if a package has been configured for "package configuration, then we should atleast have a warning generated that SSIS did not find the configuration and it would execute the package with hard coded values (from the time of development).
Is there any work around for this? how can I make SSIS warn me if the config file is missing for a package which was configured for package configuration?
Been practicing DR strategies with a test SQL instance by following the scenarios listed here: [URL] ....
> Took a backup of the Model database
> Stopped SQL Server
> Deleted model database data & log file
> Started SQL Server and it obviously wouldn't start because TempDB needs a model database present.
> Started SQL instance with trace flags 3608 & 3609
> Connected to SQL instance using command prompt.
> Issued restore command but was met with this error:
Shared Memory Provider: The pipe has been ended.
Communication link failure
And found this in the SQL log..
2015-08-12 16:21:32.83 spid51 Starting up database 'tempdb'.
2015-08-12 16:21:36.88 spid51 Error: 3456, Severity: 21, State: 1.
2015-08-12 16:21:36.88 spid51 Could not redo log record (59:136:21), for transaction ID (0:0), on page (1:20), allocation unit 458752, database 'tempdb' (database ID 2). Page: LSN = (30:165:3), allocation unit = 458752, type = 1.
[Code] .....
Hi,
Hopefully someone can help me with this.
When I downloaded the files and after burning the DVD to create the DVD to setup the 7031A - Upgrading to Microsoft SQL 2005 course, all of the executable files (BCBase.exe, Upgrade.exe, InPlace.exe, SideBySide.exe and SQL7Upgrade.exe) are not in the Setup/Drives folder...the only item in that folder is a file called "placeholder.txt".
Please, if anyone knows how to get these exectuables let me know.
Thanks,
David - EduCorp Training & Consulting
I have to load on SS2012 hundeds of excel files produced by an application over the last five years, during time few columns have been added to the initial set.I created on SS2012 a table to match with the full set of columns and want to load all the files inside the table leaving the missing cells to NULL. I think SSIS can do the job but every trial failed do far.
View 4 Replies View Relatedin order to use an SSIS package as a data source in a report, I need to enable the SSIS extension in the RSReprotDesigner.config and RSReportServer.config files. That extension is in neither of these files. I have SSIS running on my machine with Reporting Services.
The path to RSReportServer.config: C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServer
The path to RSReportDesigner.config: C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies
Why is this extension not in either of these files?
The following is an abbreviated list of what's present in the RSReportServer.config file:
<Data>
 <Extension Name="SQL"
 <Extension Name="SQLAZURE"
 <Extension Name="SQLPDW"
 <Extension Name="OLEDB"
[Code] ....
The following is an abbreviated list of what present in the RSReporDesigner.config file:
<Data>
 <Extension Name="SQL"
 <Extension Name="SQLAZURE"
 <Extension Name="SQLPDW"
 <Extension Name="OLEDB"
[Code] ....
I'm running SQL Server 2008 R2
ProductVersion  ProductLevel  Edition 10.50.1600.1 RTM   Enterprise Edition (64-bit)
The operating system is Windows 7 Professional 64 bit.
In SQL Studio, I can go to the restore window and the click "verify backup media". This would check the restore plan listed in this window and check if some of the file are missed.Is there any way to reach this with TQSL? I know there is a "restore verify" command, but this will only verify one backup/file and not the complete restore path. I'm looking for a TSQL solution which is able to control that all necessary backup files are still present on the file System and not moved or deleted (e.g through cleanup task).
View 3 Replies View RelatedI have configured windows failover clustering 2012 on 4 of my test nodes.
I am trying to add another node into this cluster but its not happening. I am not even able to start the cluster service in services.msc
After installing windows failover clustering, when I go to the C:WindowsCluster folder, I am unable to find CLUSDB, CLUSDB.1.container, CLUSDB.2.container and CLUSDB.blf files in the folder.
These files are very much present on the other nodes where cluster service is running.
I tried copying these files manually to server where its missing but still no luck.
I scheduled automatic backup process but its only showing backup of the only one .sql file in the backup folder. Other created .sql files are not backed up. Why is it so?
View 5 Replies View RelatedI have a table of following structure
Time Node
2012-06-15 12:00 Node1
2012-06-15 12:00 Node2
2012-06-15 12:00 Node3
2012-06-15 12:15 Node1
2012-06-15 12:15 Node2
2012-06-15 12:15 Node4
2012-06-15 12:30 Node2
2012-06-15 12:30 Node3
I need a query that will give me a list for which time period which node's data is missing
The table should look like this
2012-06-15 12:00 Node4
2012-06-15 12:15 Node3
2012-06-15 12:30 Node1
2012-06-15 12:30 Node4
In database i have field pwd type varchar(3)
Values inside that field are 1, 2, 3, 4, 5, 7, 8, 9
If you take closely you will notice that 6 is missing. With this code i can found the missing one.
[code]SELECT MIN(u.pwd) + 1 AS FirstMissing
FROM users u
WHERE (u.pwd + 1) <> (SELECT TOP 1 u2.pwd
FROM users u2
WHERE u2.pwd > u.pwd)[code]
But what if there is not missing number. How can i get the highest one + 1.
I have 1, 2, 3 assuming there is no missing number my result needs to be 4.
Suppose in a table, there is some data in a field: 1, 2, 3, 5, 6, 8, 9. I need a sql query which will list the missing numbers: 4,7 (Missing digits)
Query: Select * From table1
field
------
1
2
3
5
6
8
9
Expected query:??
filed1
------
4
7
Please help me to get a query which will provide my expected data.
Thanks.
/Fakhrul(mfhossain@gmail.com)
I have a table like FK_ID, Value, Date (here FK_ID is foreign key)this table getting updated frequently by daily bases that means one record per one day(For example in January month it has maximum 31 records or minimum 0 records, in February it has maximum 28 or 29 or minimum 0 records, based on calender year)I need to query this table to get missing dates in between particular monthsfor example for one FK_ID has only 25 records in Jan 2008 month and in Feb 2008 it has 10 records , so i need to get those missing 6 dates from JAN month and 18 dates from FEB monthhow can i query this
View 2 Replies View RelatedI have two columns, where I have the start and stop numbers (and each of them ordered asc). I would like to get a query that will tell me the missing range.
For example, after the first row, the second row is now 2617 and 3775. However, I would like to know the missing values, i.e. 2297 for start and 2616 for stop and so on as we go down the series. Thanks in advance to any help provided!
StartStop
---------
20452296
26173775
568936948
3727084237
84409178779
179013179995
180278259121
259292306409
307617366511
Dear All
i have a problem In Query Analyzer .When I create two diffrent table with two diffrent schemas dbo and guest but when i log on query analyzer and run query from guest schema's tahle it gives error object not found i think its some rights problem ..
Hello,I need to write a query to find out a set of missing number in a givensequence.Eg : a Column in some table has the following dataCol11234568910Here I need to write a query to find out that number 7 is missing in thegiven sequence.One possible solution is by using any loop. But I am looking out if the samecan be achieved using any query.Thanks in advance.Regards,Mahesh
View 4 Replies View RelatedWe have an SSIS package which runs regularly throughout the day, on 15 minute intervals. This package is moving data between two SQL Server instances, performing some simple identity mapping along the way. The primary source table is large, and we want to move only those records which have changed since the last time the package ran, so we use VersionDatestamps in the table, and pick up the dataset to be transferred by using the pacakge execution time, and the (previously recorded by the package) last-run time.
The problem we are having, is that the initial dataset picked up by SSIS is often missing records. The missing records are clearly within the time window that the package queried for, though they are near the boundary (within a minute, of the boundary, but as much as 30 seconds away) and typically all have an identical version datestamp to each other, within a single execution of the package.
At first, we thought this was an issue with date precision, but we've both truncated the dates, and even expanded the time window, and we still experience the same phenomenon.
The stored procedure which is responsible for updating the records in question, runs as a previous step to the SSIS package, within a single SQL Server Agent Job.
Has anyone experienced anything similar, or have some recommendation on how to track the source of this down?
Getting a trouble call for yet another program someone else did...
A DTS package runs every time a Coldfusion page is called. The call is now making IE crawl to a halt and creating an unending memory leak. I'm told that calling a DTS package from a page itself is a bad idea, and I'm not one to disagree, but the main problem here seems to be that the number of rows being returned is far greater than what it should be (a few thousand should be returned at most, I'm getting over 130,000 records).
Looking at the data that's being compared (corporate vs. local) it appears that the problem stems from the local data having an extra 0 on the front of numbers in one column. This means that the IDs created from the various columns won't match up. (I should note that all columns discussed here are of type varchar.) Here's the part of the DTS package giving me trouble:
sql Code:
Original
- sql Code
SELECT
LTRIM(RTRIM(REG_NR)) + LTRIM(RTRIM(COY_NA)) + LTRIM(RTRIM(DIS_NR)) + LTRIM(RTRIM(PKG_CTR_NR)) +
LTRIM(RTRIM(BDG_NR)) + LTRIM(RTRIM(PSL_CD)) + LTRIM(RTRIM(CTY_NA)) +
LTRIM(RTRIM(IN_BDG_LOC_NR)) + LTRIM(RTRIM(PFR_CTY_NA)) AS ID,
MIN(TABLE1) as Version,
REG_NR, DIS_NR, PKG_CTR_NR, BDG_NR, CTY_NA, COY_NA, PSL_CD, ST_CD, ST_NA, CNY_CD, PFR_CTY_NA, IN_BDG_LOC_NR
FROM
(
SELECT 'Corporate' as TABLE1,
A.REG_NR, A.DIS_NR, A.PKG_CTR_NR, A.BDG_NR, A.CTY_NA, A.COY_NA,
A.PSL_CD, A.ST_CD, A.ST_NA, A.CNY_CD, A.PFR_CTY_NA, A.IN_BDG_LOC_NR
FROM TABLE1 A
UNION ALL
SELECT 'LOCAL' as TABLE2,
B.REG_NR, B.DIS_NR, B.PKG_CTR_NR, B.BDG_NR, B.CTY_NA, B.COY_NA,
B.PSL_CD, B.ST_CD, B.ST_NA, B.CNY_CD, B.PFR_CTY_NA, B.IN_BDG_LOC_NR
FROM TABLE2 B
) tmp
GROUP BY
REG_NR, DIS_NR, PKG_CTR_NR, BDG_NR, CTY_NA, COY_NA, PSL_CD, ST_CD, ST_NA, CNY_CD, PFR_CTY_NA, IN_BDG_LOC_NR
HAVING COUNT(*) = 1
ORDER BY PSL_CD
SELECT LTRIM(RTRIM(REG_NR)) + LTRIM(RTRIM(COY_NA)) + LTRIM(RTRIM(DIS_NR)) + LTRIM(RTRIM(PKG_CTR_NR)) + LTRIM(RTRIM(BDG_NR)) + LTRIM(RTRIM(PSL_CD)) + LTRIM(RTRIM(CTY_NA)) + LTRIM(RTRIM(IN_BDG_LOC_NR)) + LTRIM(RTRIM(PFR_CTY_NA)) AS ID, MIN(TABLE1) AS Version, REG_NR, DIS_NR, PKG_CTR_NR, BDG_NR, CTY_NA, COY_NA, PSL_CD, ST_CD, ST_NA, CNY_CD, PFR_CTY_NA, IN_BDG_LOC_NR FROM( SELECT 'Corporate' AS TABLE1, A.REG_NR, A.DIS_NR, A.PKG_CTR_NR, A.BDG_NR, A.CTY_NA, A.COY_NA, A.PSL_CD, A.ST_CD, A.ST_NA, A.CNY_CD, A.PFR_CTY_NA, A.IN_BDG_LOC_NR FROM TABLE1 A UNION ALL SELECT 'LOCAL' AS TABLE2, B.REG_NR, B.DIS_NR, B.PKG_CTR_NR, B.BDG_NR, B.CTY_NA, B.COY_NA, B.PSL_CD, B.ST_CD, B.ST_NA, B.CNY_CD, B.PFR_CTY_NA, B.IN_BDG_LOC_NR FROM TABLE2 B) tmpGROUP BY REG_NR, DIS_NR, PKG_CTR_NR, BDG_NR, CTY_NA, COY_NA, PSL_CD, ST_CD, ST_NA, CNY_CD, PFR_CTY_NA, IN_BDG_LOC_NRHAVING COUNT(*) = 1ORDER BY PSL_CD
Since it was just one extra 0 (in the local table), I thought I could add a 0 to the beginning of the string in the first table:
sql Code:
Original
- sql Code
SELECT 'Corporate' as TABLE1,
A.REG_NR, A.DIS_NR, A.PKG_CTR_NR, '0'+A.BDG_NR, A.CTY_NA, A.COY_NA,
A.PSL_CD, A.ST_CD, A.ST_NA, A.CNY_CD, A.PFR_CTY_NA, A.IN_BDG_LOC_NR
FROM TABLE1 A
SELECT 'Corporate' AS TABLE1, A.REG_NR, A.DIS_NR, A.PKG_CTR_NR, '0'+A.BDG_NR, A.CTY_NA, A.COY_NA, A.PSL_CD, A.ST_CD, A.ST_NA, A.CNY_CD, A.PFR_CTY_NA, A.IN_BDG_LOC_NR FROM TABLE1 A
However, this keeps giving me the error 'no column specified for column 5 of tmp'. Unsure how to fix that, I try to instead trim the local database to four numbers:
sql Code:
Original
- sql Code
SELECT 'LOCAL' as TABLE2,
B.REG_NR, B.DIS_NR, B.PKG_CTR_NR, RIGHT(B.BDG_NR,4), B.CTY_NA, B.COY_NA,
B.PSL_CD, B.ST_CD, B.ST_NA, B.CNY_CD, B.PFR_CTY_NA, B.IN_BDG_LOC_NR
FROM TABLE2 B
SELECT 'LOCAL' AS TABLE2, B.REG_NR, B.DIS_NR, B.PKG_CTR_NR, RIGHT(B.BDG_NR,4), B.CTY_NA, B.COY_NA, B.PSL_CD, B.ST_CD, B.ST_NA, B.CNY_CD, B.PFR_CTY_NA, B.IN_BDG_LOC_NR FROM TABLE2 B
This works, and I am only getting about 10,000 rows (perhaps not quite right, but better than before). The two columns now line up. However, this has an unintended (and really crazy) sideffect: The IN_BDG_LOC_NR column (and thus part of the ID) is now completely empty for the corporate data, and 00 for the local data (both were originally a two digit number that was not 00).
I have absolutely no idea what is causing this, and google isn't helping. Is there a way to make the first idea I had work? If so, I'd prefer to use that. If not, I would appreciate thoughts on making the second idea work.
Hi all,I have a query as follows:update stage.FinanceVehicleSummaryset vin = (select VIN from stage.ChasisLookup wherestage.chasislookup.chasis = stage.FinanceVehicleSummary.ChasisNoand stage.chasislookup.sr_registration_number =stage.FinanceVehicleSummary.srregno)and i get this message: Subquery returned more than 1 value. This is notpermitted when the subquery follows =, !=, <, <= , >, >= or when thesubquery is used as an expression.The statement has been terminated.and I have no idea what could be causing this or how to resolve it?Many thanksSam*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies View RelatedKEYIDGROUP
1 1 a
2 1 b
3 2 a
4 2 b
5 3 a
6 3 b
7 4 a
8 5 a
This is my simple table I need a query that will identity the ID's that are missing the group "b" but I don't want ID 1,2,3 to come up because they are part of a and b. I just need to see anything missing only "b" but not if it's part of a and b.
query should reveal answer should be missing the group b
KEYID
7 4
8 5
I tried the NULL search but since the records don't exist it cant find a null. I am writing a query to identify the missing ID without B but exclude ID that are part of A and B
SELECT T1.lnumber AS LOT_Number,(T2.time_out - T1.time_in) AS Duration,
((DATEPART (hour, (T2.time_out-T1.time_in)) *60) + DATEPART (minute, (T2.time_out-T1.time_in))) AS Minutes, COUNT(DISTINCT T2.test_desc) AS Number_of_Process
FROM Results AS T1 JOIN Results AS T2 ON T1.lnumber = T2.lnumber
WHERE T2.test_desc = 'Shipping' AND T1.test_desc = 'Receiving'
I have an error message that says:
Msg 8120, Level 16, State 1, Line 3
Column 'Results.lnumber' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
If I take this line out: COUNT(DISTINCT T2.test_desc) AS Number_of_Process
The query runs ok.
Also if I run [COUNT(DISTINCT T2.test_desc) AS Number_of_Process] in:
SELECT COUNT(DISTINCT T2.test_desc) AS Number_of_Process, T2.lnumber AS Lot_number
FROM Results AS T1 JOIN Results AS T2 ON T1.lnumber = T2.lnumber
GROUP BY T2.lnumber
It will also give me result.
Please help....
Thanks for your time
Hi, Please could someone assist - the above error occurs. This is my code: Protected Sub btnReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) ' Response.Redirect("CrystalreportTEST_Print.aspx?C_id=" & ddlCompany.SelectedValue) Dim myConnection As New OleDbConnection(connString) Dim Str As String = "SELECT clientid,company FROM Client WHERE company =" & ddlCompany.SelectedItem.Text Dim cmd As New OleDbCommand(Str, myConnection) Dim ds As New DataSet Dim da As New OleDbDataAdapter(cmd) da.Fill(ds) Label7.Text = ds.Tables(0).Rows(0).Item("clientid") ' Response.Redirect("CrystalreportTEST_Print.aspx?C_id=" & ds.Tables(0).Rows(0).Item("clientid")) End Sub Thank you in advance
View 1 Replies View RelatedI'm getting the error listed above. To create this I used the wizard in VS2005 for the datagrid. The delete works but not the updating. I can't seem to find what's wrong. In the update parameters I've removed eventID and added it, neither works. Delete does work. Here's the code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="ds1" DataKeyNames="eventID"><asp:CommandField ButtonType="Button" ShowEditButton="True" ShowDeleteButton="True" /><asp:BoundField DataField="eventID" HeaderText="ID" SortExpression="eventID" ReadOnly="True" /><asp:BoundField DataField="trainer" HeaderText="trainer" SortExpression="trainer" /><asp:BoundField DataField="employeeNumber" HeaderText="Emp#" SortExpression="employeeNumber" /><asp:BoundField DataField="area" HeaderText="Area" SortExpression="area" /><asp:TemplateField HeaderText="Training Date" SortExpression="trainingDate"><EditItemTemplate><asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("trainingDate", "{0:M/dd/yy}") %>'></asp:TextBox></EditItemTemplate><ItemTemplate><asp:Label ID="Label2" runat="server" Text='<%# Bind("trainingDate", "{0:M/dd/yy}") %>'></asp:Label></ItemTemplate></asp:TemplateField><asp:CheckBoxField DataField="additionalTrainerExpected" HeaderText="Addl Trainer Expected" SortExpression="additionalTrainerExpected" ><asp:TemplateField HeaderText="Ext Trainer" SortExpression="extendedTrainer"><EditItemTemplate><asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("extendedTrainer") %>' /></EditItemTemplate><ItemTemplate><asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("extendedTrainer") %>' Enabled="false" /></ItemTemplate><HeaderStyle Font-Names="Verdana" Font-Size="Small" /><ItemStyle Font-Bold="False" HorizontalAlign="Center" /></asp:TemplateField><asp:TemplateField HeaderText="NonExt Trainer" SortExpression="nonextendedTrainer"><EditItemTemplate><asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("nonextendedTrainer") %>' /></EditItemTemplate><ItemTemplate><asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("nonextendedTrainer") %>' Enabled="false" /></ItemTemplate><HeaderStyle Font-Names="Verdana" Font-Size="Small" /><ItemStyle HorizontalAlign="Center" /></asp:TemplateField><asp:SqlDataSource ID="ds1" runat="server" ConnectionString="<%$ ConnectionStrings:TrainingClassTrackingConnectionString %>"ProviderName="<%$ ConnectionStrings:TrainingClassTrackingConnectionString.ProviderName %>"
UpdateCommand="UPDATE [trainingLog] SET [trainer] = ?, [employeeNumber] = ?, [additionalTrainerExpected] = ?, [extendedTrainer] = ?, [nonextendedTrainer] = ?, [area] = ?, [trainingDate] = ? FROM [trainingLog] WHERE [eventID] = ?">
<UpdateParameters><asp:Parameter Name="eventID" Type="Int32" /><asp:Parameter Name="trainer" Type="String" /><asp:Parameter Name="employeeNumber" Type="String" /><asp:Parameter Name="additionalTrainerExpected" Type="Boolean" /><asp:Parameter Name="extendedTrainer" Type="Boolean" /><asp:Parameter Name="nonextendedTrainer" Type="Boolean" /><asp:Parameter Name="area" Type="String" /><asp:Parameter Name="trainingDate" Type="DateTime" /></UpdateParameters>
<DeleteParameters><asp:Parameter Name="eventID" Type="Int32" /></DeleteParameters>
I'm developing my first Analysis Server report in SRS. Everything was going well when I discovered the filters & parameters pane was missing in the MDX Query Designer in data mode. I have my columns and rows but need to drag a dimension into the filters & parameters pane in MDX Query Designer and set a filter and parameter on it. Any idea how to make it viewable?
View 1 Replies View RelatedHi,
on executing the below query i am getting the following error
ERROR: Errors in the back-end database access module. Nested table keys in a SHAPE query must be sorted in the same order as the parent table. The nested query may be missing an ORDER BY clause.
even though the order by clause is presenet in the nested query
SELECT t.[ProductId], Predict ([Association].[Product Basket],3)
From
[Association]
PREDICTION JOIN
SHAPE {
OPENQUERY([Adventure Works Cycle MSCRM],
'SELECT DISTINCT [ProductId] FROM (SELECT ProductId FROM ProductBase) as [Product] ORDER BY [ProductId]')}
APPEND
({OPENQUERY([Adventure Works Cycle MSCRM],
'SELECT [ProductId] FROM (SELECT ProductId FROM ProductBase) as [Product] ORDER BY [ProductId]')}
RELATE [ProductId] To [ProductId]
)
AS
[Product] AS t
ON
[Association].[Product Id] = t.[ProductId] AND
[Association].[Product Basket].[Product Id] = t.[Product].[ProductId]
Hello,
I have the following query which grabs monthly usage data which is logged to a database table from a web page:
SELECT Button = CASE ButtonClicked
WHEN 1 THEN '1st Button'
WHEN 2 THEN '2nd Button'
WHEN 3 THEN '3rd Button'
WHEN 4 THEN '4th Button'
WHEN 5 THEN '5th Button'
WHEN 6 THEN '6th Button'
WHEN 7 THEN '7th Button'
WHEN 8 THEN '8th Button'
WHEN 9 THEN '9th Button'
ELSE 'TOTAL'
END,
COUNT(*) AS [Times Clicked]
FROM WebPageUsageLog (NOLOCK)
WHERE DateClicked BETWEEN @firstOfMonth AND @lastOfMonth
GROUP BY ButtonClicked WITH ROLLUP
ORDER BY ButtonClicked
The results look like this:
TOTAL 303
1st Button 53
2nd Button 177
3rd Button 10
4th Button 4
6th Button 18
7th Button 19
8th Button 21
9th Button 1
If a button is never clicked in a given month, it never gets logged to the table. In this example, the 5th button was not clicked during the month of December, so it does not appear in the results. I want to modify my query so it displays the name of the button and a zero (in this case "5th Button 0") in the results for any buttons that were not clicked. For some reason I am drawing a blank on how to do this. Thanks in advance.
-Dave