Switch Of Query Design Mode

Feb 13, 2007

Hi all,

I have a couple of reports with predefined queries. When I try to edit a data set query it goes directly to query design mode losing the query I already had. As you can see this is a real problem because I can't edit queries. How can I switch off design mode? any ideas are pretty much appreciated.

Cheers

View 3 Replies


ADVERTISEMENT

Is It Possible To Switch From Pure Window's Authenticated Mode Ro Mixed Mode? (SQL 2005)

Jan 18, 2007

Durning install I selected Window's Authentication only, but now it seems we may need to use a Mixed Mode with an SA account etc... is there anyway to switch SQL 2005 to use Mixed Mode after the fact?

View 1 Replies View Related

How To Switch Debugging Mode In SSIS?

Nov 29, 2007


I added an activeX package and then try to execute it, when I run it comes up with following error:-

Error 1 Validation error. DTSTask_DTSDataPumpTask_1: OLE DB Destination [181]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The Acquire Connection method call to the connection manager "Microsoft OLE DB Provider for SQL Server Copy" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the Acquire Connection method call failed. SearsCDCC_Transfer.dtsx 0 0


I did some research on line and I came to know that I need to switch the debugging mode to change the 64 bit to false. But I am too novice in SSIS, so I am not sure how to switch the debugging mode. Any idea about it?

View 1 Replies View Related

Reporting Services :: Query Timeout In Report Builder Design Mode

May 18, 2012

I have a very frustrating problem.  But given that this is a development forum, I'll keep that for my 'Envelope Lickers Rehab' and instead talk about an issue I'm having.

I have a very large query (line-wise) that executes in less than a minute when run from the SQL Management Studio as well as via Excel Services. 

It is a stored procedure with one parameter. When I try to prime the designer with this query it gives me the following message:

"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated."

I've considered cracking open the xml source and manually creating the fields, but I'd rather not go there.

View 8 Replies View Related

DB Design :: How To Switch Security Context In A View

Jun 5, 2015

I have 2 databases one for datawarehouse and one for reporting.

I created a view in the reporting database joining several tables from datawahourse. The view is meant for a users who uses powerpivot. It will contain a few million of rows.

I set up a role in the reporting database. I assigned select rights to that role on the view.

When the  user wants to access the view, he can see the view but a select gives

The server principal "pp_user" is not able to access the database "datawarehouse" under the current security context.

How can I fix this ? I don't want to give the user select rights on tables in the datawarehouse.

View 3 Replies View Related

Query Executes Faster In Grid Mode Than In Text Mode!!

Mar 9, 2000

Hello,everyone!!

There is a query which when executed in the grid mode(ctrl+d) takes approx 0.02 seconds(about 21,000
rows) But when I execute in the text mode, it takes about 0.40 seconds!!
Why is this difference?
Also, when the records from this table are read from a VB application, they are equally slow (as in the text mode!)
Why is it so slow on the text mode & relatively faster in the grid mode?
Has anyone got any idea on ‘Firehose’ style cursor ?(which may speed up access of data in the VB application)

Rgds,
Adie

View 1 Replies View Related

UTC Datetime Not Available In Design Mode

May 22, 2008

Greetings:

When creating a table in design mode, there is no option to set the field as UTC datetime.

Is the logical work around to issue an ALTER TABLE statement and how would this look? That is, how would the ALTER statement look to include constraints:


ALTER TABLE [dbo].[My_Table](
??? DROP CONSTRAINTS HERE ???

[Item_ID] [smallint] IDENTITY(1,1) NOT NULL,

[Started] [datetime] NOT NULL CONSTRAINT [DF_CL_Items_Started] DEFAULT (GETUTCDATE()),

[Ended] [datetime] NULL CONSTRAINT [DF_CL_Items_Ended] DEFAULT (null),

CONSTRAINT [PK_My_Table] PRIMARY KEY CLUSTERED

(

[Item_ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Thanks

View 9 Replies View Related

DB Design :: What To Do If Database Under Went To Suspect Mode

Jun 1, 2015

In the work I came up against a situation when the working database at the end of day went to the Suspect Mode.And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to run because the database is in this mode.

View 7 Replies View Related

Can I Access My Data Source In Custom Report Item During Design Mode?

Mar 19, 2007

Hi,

I'm developing a Custom Report Item and would like to fill my properties dialog in design mode with real data. I have the name of the data source and the command text for the corresponding report dataset, read from the report design.

Is it possible to create an ado.net dataset so that I can display and use real data in my properties dialog box? First problem I have is to get the connection string from the data source string. I found no docs for that, especially the Microsoft.ReportingServices.DataExtensions.ReportDataSource class is not documented. Am I on the right way with that?

Thomas

View 3 Replies View Related

Possible To Stop SSRS GUI From Destroying Hand Rolled Mdx In Datasets By Silently Reverting To Design Mode?

May 30, 2007

Since as soon as you extend your mdx datasets manually you can no longer switch back into design mode without losing your changes, right?

If that's the case, is there some way to disable design mode completely? i'm finding that the GUI has the tendency to SILENTLY revert the dataset editor back to design mode while I'm busy editing a layout, thereby losing my carefully crafted MDX.

View 4 Replies View Related

Database Design/query Design

Feb 13, 2002

Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:

-------
Fixture
-------
fix_id
fix_date
fix_played

----
Team
----
tem_id
tem_name

-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals

It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.

Fixture contains the details about the fixture like date and fixture id and has it been played

Team contains team info like team id, name, associated graphic

TeamFixture is the table which links the fixture to it's home and away team.

TeamFixture exists to prevent a many to many type relationship.

Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!

View 2 Replies View Related

Can A Query Tell Us What Recovery Mode Is Being Used?

Oct 29, 2007

can t-sql be used to find out which recovery mode is on for a given db?

View 1 Replies View Related

OVER Is Not Supported In Query Wizard Mode

Jul 15, 2007

I'm using VS 2005, and I built a website with a TableAdapter method using the wizard.I hand wrote a line of code: 1 WITH srtAS
2 (
3 SELECT *,
4 ROW_NUMBER() OVER (ORDER BY date DESC) AS 'RowNumber'
5 FROM table1
6 )
7 SELECT *
8 FROM srt
9 WHERE RowNumber BETWEEN @start AND @end; I didn't find any syntax errors, but the Wizard keeps alerting "the over sql construct or statement is not supported." From my research, I found that it's caused by the Wizard that doesnt support some syntax. Afterall, the problem is:1. I have two parameters @start AND @end. normally if there is no "syntax error", then it will show in the TableAdapter: GetData(@Start,@end). But now since there is this "Syntax error", I won't load these two parameters.2. I saw some solutions to this "syntax error" problem, and they suggested to write query manually, don't use wizard. But I don't know how.  thanks in advance-noPC-     

View 4 Replies View Related

SQL Server Admin 2014 :: SSRS SharePoint Integrated Mode Versus Native Mode

Jul 25, 2014

We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.

Any articles which give me information as to what happens when a report is run from SharePoint server and where does it log.

View 1 Replies View Related

Transact SQL :: Trigger Database In Suspect Mode And Get It Out To Normal Mode?

Jul 27, 2015

how to put sql server database in suspect mode intensely and  get it out from suspect mode to normal mode.

   i am using SQL server 2008 R2

View 5 Replies View Related

SQL 2012 :: Compatibility Mode Causes Query Not To Finish

Aug 8, 2015

We recently upgraded out SQL version from SQL2008R2 to SQL2014. As such, the compatibility mode changed to SQL2104 (120).

We have several queries that used to run fine that now take forever to bring back results. There are no errors (which surprised me). They just take way too long now. PLus they seem to be causing high I/O and CPU.

If I change the compt level back to SQL2008 - these queries run fine.

QUERY with SQL2008 compt level - finished in 2 minutes.
QUERY with SQL2014 compt level - finishes in 3 hours 22 minutes.

same exact query - same server - only thing changed was compatibility level.

WHat do I look for in the queries that could be causing this? (they look fine but obviously I'm missing something here)..

View 9 Replies View Related

Query To Find Databases In Full Mode

May 4, 2007

I have a stored proc that runs through my databases doing transaction logs. Currently it uses database names but this keeps being changed as a database will be added without me knowing. Next thing the transaction log job is goosed.



I really need something along the lines of select db from sys???? where mode = 'Full'



Any help appreciated.



MPM

View 1 Replies View Related

What Is The Fiber Mode(lightweighting Pool Mode) Of SQL Server?

Mar 26, 2005

Recently I read such statments 'When SQL Server is run in "lightweight pooling" mode (fiber mode) and the DTC service is started, unexpected behavior may occur.'
Can someone say anything about fibe mode?I am appreciated for it.:)

View 3 Replies View Related

Local Intranet Mode Versus Internet Mode.

Jul 16, 2007

Hi,



Currently, our Report Builder is running on Local Intranet mode. I'm investigating what the security implications are in changing it to Internet mode. However, I've not been able to find any documentation on this.



Does anyone know of any documentation that addresses this issue or have experience that they can share with changing Report Builder security zone from Intranet mode to Internet mode?



Thanks very much.

View 1 Replies View Related

Mixed Mode To Windows Mode Without Trace....

Jan 3, 2006

Hi folks,

I have a SQL 2005 OTC. CTP version running on Windows 2003 server.

I would like to find out how the SQL server option changed to Windows Authentication mode from Mixed mode over the weekend.  From the SQL log, I don't see when it changed.  I would like to see Date/Time and client IP.  If I can see User ID (windows) that would be great.  Where I can find these info in SQL server?

Thank you in advance...

SHJ

View 1 Replies View Related

Query:how To Transfer Data From A .net Application In Wireless Mode In A WLAN Enviornment.

Sep 27, 2005

Hi All,

View 5 Replies View Related

SQL Server 2014 :: Column Store Query Reverting To Row Mode With CROSS JOIN

May 20, 2015

I have two inline selects against a table with a nonclustered columnstore on SQL 2014 (12.0.2000). Both execute in batch mode and when I inner-join the two, they continue to execute in batch mode. When I cross join them, one executes in row mode. Below is some SQL to simulate the issue.

-- The purpose of this script is to demonstrate that
-- two queries against a columnstore index that each execute in batch mode
-- will continue to execute in batch mode when inner joined.
-- However, one of the queries will execute in row mode when cross-joined.

-- Create function to return 0 to n rows
IF OBJECT_ID('dbo.IntCount') IS NOT NULL
DROP FUNCTION dbo.IntCount;

[Code] .....

View 6 Replies View Related

How To Design This Query?

Aug 20, 2007

table a
id pct
1 0.1
2 0.24
3 0.5

table b
year amount
2001 10
2002 20
2003 30
2004 23
2005 67
2006 80

I want to create a table ret
wiht this
year newamount
2006 80*0.1+67*0.24+23*0.25
2005 67*0.1+27*0.24+30*0.25
2004 23*0.1+30*0.24+20*0.25
2003 30*0.1+20*0.24+10*0.25=9.9

How can i do that.
Thanks.
Jeff

View 5 Replies View Related

Query Design

Oct 27, 2007

hi

i am new to t-sql. the problem is i have to subtract a field from a column A in table X from a field in Column R from Table Y and put the subtracted value in the Column K in the Table Z

ex:

Table Name: Order
Field Name: Boxes

Table Name: Despatch
Field Name: Boxes

Table Name: Balance
Field Name: Boxes

the problem is i have to subtract the values(Boxes) in the table Despatch, from the values(Boxes) in the table Order, and the subtracted value has to be put in values(Boxes) in the table Balance.


can any one help?

one more thing: Where i can get the basics of t-sql



regards.,

sekar.r

View 2 Replies View Related

Query Design / Capability

Oct 2, 2007

Hello, I am trying to achieve a query results with not much luck. I am struggling the query design of how to construct to get the right results.
My table has the following data
RoomID  Subject         StartDate                Duration(min)           EndDate
  201       test       28/09/2007 07:00:00            180              28/09/2007 10:00:00
  202       test       28/09/2007 09:00:00            240              28/09/2007 13:00:00
 
The best way to describe is a scheduling system with the StartDate, Duration, EndDate.
I am trying to query for datetime periods which are allocated, eg the table records show from 7am - 10am and 9am - 1pm are allocated.
When I query on StartDate >=  28/09/2007 07:00:00   AND    EndDate <= 28/09/2007 13:00:00, record 201 & 202 shows which is correct because they are within query parameters and are allocated.
When I query on StartDate >=  28/09/2007 07:30:00   AND    EndDate <= 28/09/2007 13:00:00, record 202 only shows which is correct because record 201 StartDate is before 07:00:00.
But my problem is I require record 201 to show because the time period between 07:00:00 and 09:00:00 is allocated and the query parameter is 07:30:00 which is still between 07:00:00 and 09:00:00.
I have researched where on similar situations, the use of duration is used, but I am unsure on its application to achieve results.
I have also read of other situations where a lookup table should be used, but again I cannot get my head around the application of alookup table to query the resuults.
 
Does anyone have any theories, design thoughts or real work solutions they can help me with.
 
Thanks
Peter Smith
 
 

View 9 Replies View Related

Database/Query Design Help

Oct 2, 2005

I am designing an ASP.NET app that can be used to keep track of
attendance at office hours for a class.  The purpose of this is
that we need to know if a student is attending office hours by
different people (so that we can flag them as "in trouble").  I
don't know if I have chosen the best database design, and I'm lost as
to how to accomplish a query I need.

I have a table HoursAttendance that has the following design.

Column_Name   Data_Type   Length   Allow_Nulls
TA              
      char        
      4         
n
Date              
    smalldatetime 4     
    n
Start              
    smallint         
2          n
End              
     smallint     
    2          n
Student1            
bit              
  1          y
Student2            
bit              
  1          y
Student3            
bit              
  1          y
Student4            
bit              
  1          y
Student5            
bit              
  1          y

I chose to have the students as columns because the students don't
change, and then you add rows of office hours.  If students are
the rows, then you would be adding columns as the semester continued
which I thought was odder...?  I'm completely open to suggestions
on Database Design, because I really wasn't sure.

Ok, so now I need useful queries.  The one that I am stuck on (and
also the first one besides select * from HoursAttendance) is that I
want the names of Students who have attended more than x office
hours.  So I need something like

    select <column name> from HoursAttendance where count(sum(<column name>)) > x

Granted a better table design could help with this.  I'm
relatively new to design, so constructive criticism is desired please

View 7 Replies View Related

Simple SQL Query Or Design Problem?

Nov 21, 2005

Dear All

I have posted this a few days ago, but probably didn’t describe it properly so I’ll attempt it again.

I’m wondering if it’s the design that needs to be changed or I simply can’t put this together.

I have 3 tables.

1. people (peopId, peopFName, peopSName etc.)
2. codes (codeId, codeName)
3. codedPeople(codePeopleId, peopId, codeId)

Codes represent different skills that people might have, like:

Technology-Founder
Technology-Chief Executive Officer
Technology-Systems Designer
etc.

people, clearly holds data about people.

CodedPeople holds data on which people in the db are coded what skills.

What I need is a query that returns all distinct people records and takes a number of codeNames as input.

So if I have person1 and person2 in the db and they are coded as:

Person1 is a t-Founder
Person1 is a t-CEO

Person2 is a t-Systems Designer

Query 1, looking for all t-CEO
Result 1: person1

Query 2, looking for all t-CEO AND t-Founder
Result 2: person1

Query 3, looking for all t-CEO OR t-Systems Designer
Result 3: person1, person2

Query 4, looking for all t-Founder AND t-Systems Designer
Result 4: -


I have:

[ code]
SELECT people.peopId, peopFName, peopSName, peopPhoneHome, peopPhoneMobile, peopEmail, codes.codeId, codename
FROM people INNER JOIN codedPeople ON people.peopId = codedPeople.peopId
INNER JOIN codes ON codes.codeId = codedPeople.codeId
WHERE ( parameter )
ORDER BY peopSName, peopFName
[ /code]

And I add in parameters from my front end to the WHERE clause, like in the example:

Parameter = ( codeName LIKE 't-CEO' ) OR ( codeName LIKE 't-CFO' )


This works fine when using OR but doesn’t work when trying to use AND in a sense of a person is coded with skill1 AND skill2 AND skill3 etc.

Any idea how to implement what I need to achieve?

View 14 Replies View Related

Can Not See Columns In Query Design View

Nov 3, 2006

Even though I select "Column Names" in Design View when creating a query (or view), only "* (All Columns)" appears in the table box.

In InfoPath, when I connect a combo-box, err drop down box, to the database, I am unable to connect directly to a table... no tables are shown. If I select a different database, these problems do not exist.

I can not find any setting to allow these columns to be shown in the design view or any setting that will "expose" the tables in InfoPath.

I tried creating a new database and exporting the data, tables and data, from the troubled DB to the new DB; however, the new DB exhibited the same behaviour. The system tables, Master and Model, have the same behaviour. Please help me with your ideas and suggestions... thank you very much for your time.

This database was upsized from Access 2003 to SQL Server 2000 SP4.

rogge

View 7 Replies View Related

How Would You Design This Query Better ( Does Not Contain Lots Of Code)

Apr 18, 2006

i have a number of business programs. Each program is started anew at the beginning of each fiscal year. each program has a number of goals and customers subscribe to the goals.

i have to pull all this info out of the database.

i have a cursor that gets the first program, inside this program i have a cursor that gets the first period, and inside that i have a cursor that gets the info on each goal.

program cursor

{

period cursor

{

goal cursor

}

}

}

}

this takes ages ( hours and hours ) to run. is there any way i could have designed this using joins and simple selects to make it more efficient??

View 4 Replies View Related

/3GB Switch

Sep 2, 2007

Hi All
Server 2003 standard edition, MSsql 2005 standard edition
As I understand it server 2003 standard only supports 4gb. Does this mean I can only use up to 4gb as the maximum memory for server 2005?
If that is the case I would like to use the 3GB switch, and leave the other gig for other apps. If I set the 3GB switch in boot.ini do I then also have to enable AWE (which I can't seem to do) or can I forget about AWE altogether?

Many thanks
Martin

View 5 Replies View Related

3gb Switch And AWE

Apr 10, 2007

in configuring AWE whether i need use both 3GB in boot.ini and AWE Enabling option in SQL Server

View 3 Replies View Related

SQL Query Analyzer -&> Design View -&>Save

May 14, 2007

in SQL Query analyzer i get the desired result for the following querry succesfull.

But can any one help me in getting the same result in design view so that i can save this view and get the required result on my aspx page.(Web page)

A beginer !!!! not much familiar with MS SQl.....HELP>>>

USE nfxdash SELECT *, DATEDIFF(day, Date_Opened, getdate()) AS no_of_days
FROM nf_Tickets

View 1 Replies View Related

Blonde To Write Query Or Design Fault

Nov 18, 2005

Dear All,

I’m wondering if it’s the design that needs to be changed or I simply can’t put this together.

I have 3 tables.

1. people (peopId, peopFName, peopSName etc.)
2. codes (codeId, codeName)
3. codedPeople(codePeopleId, peopId, codeId)

Codes represent different skills of people, example the sort of job functions they’ve held in their employment. Like:

t-CEO,
t-CFO
t-Founder
etc.

people, clearly holds data about people.

CodedPeople holds data about which people are coded. So person1 can be coded as t-CEO as well t-Founder, and person2 coded as t-CFO

What I need is a query that returns all distinct people records and takes a number of codeNames as input. So if I throw in t-CEO OR t-Founder I get person1, again if I define t-CEO AND t-Founder I get person1.

However when I add t-CEO OR t-CFO I get person1 and person2 but when the query takes t-CEO AND t-CFO I get no result.

I can’t seem to come up with anything that would give me a good starting point. Is there a design fault here? All opinions are much appreciated, thanks in advance!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved