-
- Simple Query on one table
by VBE_programmer
- 14 Replies
- Last post
by VBE_programmer
- Hi,
I am new about T sql querys.
I have one table with two columns
col1 col2
---------------------
A B
B A
C D
D C
P Q
Q P
I would like to display the result in the following way using in one query
In my view A-->B and B--->A are same and C-->D and D->C ..etc
Col1 col2
--
-
- Calculated Measure does not appear in all the drilldowns
by Gumbatman
- 5 Replies
- Last post
by Gumbatman
- Hello,
I created a hierarchy [Time].[Year-Month] that has the following
-Year
--Period
---English Month
I want to return the headcount from the 1 st Period only. This works fine. I did it by making a new measurement called LastActive by using the LastNonEmpty aggregate function. I then made a calculated measure called BeginHeadCount as the following:
([Measures].[L
-
- vista error 500
by robhare
- 24 Replies
- Last post
by robhare
- Goodday
If I go to Http://localhost/reports I get this error
I have followed the tutorial but still get the error as below. If i go to http:// localhost I get the iis7 wecome page , without a problem.
Sorry I,m a bit new at this , I see in the error message that I must type something in a command line window.
Is this the black blackground box with C:\windows\system32>_ already typed
-
- Reporting Services SQL 2005 x64 standard edition
by Francois_Benade
- 3 Replies
- Last post
by Francois_Benade
- Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005
Thanks
Francois
-
- Getting the row count of all table in several database
by Dale L.
- 2 Replies
- Last post
by The masked Dale
- Hi all,
Im working under sql server 2000 and im trying to acess to some informations to make some report.
Im trying to acess to the list of each table in the database, and for each table i would need to know its size.
I can get acess to the different table in a single database but i cant get its row count. Is there a way for me to obtain that information or to dynamicaly set a
-
- Convert ANsi-89 to Ansi-92 outer join
by sidlet
- 14 Replies
- Last post
by Tom Phillips
- I've been using this syntax for years on SQL Server and now comes the time to convert to SQL 2005 (90 compatibility). This syntax returns four rows. Basically it returns one row for each servername/component/context/property/value even when there does not exist a property of 'fff' since it's a left join:
Code Block
select t1.* from tblconfiguration t1 ,tblconfiguration t2 where t1.c
-
- Help on creating SSIS
by malhar
- 8 Replies
- Last post
by Jason Rawlins
- Hello ,
I am getting the given error message while creting SSIS. Please help me to solve the error....
Error loading 'Package.dtsx' : QI for IEnumVARIANT failed on the unmanaged server..
regards,
Malhar , THanks
-
- problem with key encryption
by LioraGirl
- 3 Replies
- Last post
by Daniel Reib
- Hello,
I am using report server sql express.
The report was working until yesturday.Sudenly the report did'nt work and give an error :
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more
-
- Issues with execute package task in SSIS
by Vivek S
- 10 Replies
- Last post
by Vivek S
- Hi,
We have used an execute package task in our master package to execute a child package and we have set the execute out of process=false. This master package is running fine in 32 bit server but is failing in 64 bit server. is there any settings to be done in the server or is it the problem with the property setting(execute out of process)
Vivek S
-
- What is necessary to create SDF-Files on desktop legally?
by csname
- 14 Replies
- Last post
by Bob - GP
- I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed
-
- 64 Bit MSDASQL.DLL
by sqlguy12
- 14 Replies
- Last post
by John Sem
- Is microsoft going to provide 64 bit version of MSDASQL ( OLEDB Wraper for ODBC) in future This was working great while accessing Data from IBM AS/400 on Iseries from 32 bit sql 2000. Now, it's all screwed up with rediculously slow OLEDB both from MS and IBM. I wonder if any of these guys really care!
-
- Regarding ManagedDTS assembly
by jaegd
- 2 Replies
- Last post
by jaegd
- Will the Microsoft.SqlServer.VSTAScriptTaskPrx assembly effectively replace MicrosoftSqlServer.ManagedDTS assembly for script tasks
There are a number of script tasks which use ManagedDTS (e.g. new Application() + associated function calls) that no longer work with Katmai. For example, I've used tasks which build and configure packages thesmselves, since certain tasks' properties do not sup
-
- Support for OLEDB Scrollable Updateable Cursor via Query
by KostyaXP
- 7 Replies
- Last post
by KevinLion
- Hi,
is there any update on the subject
Jet has it for ages.
I want to use Scrollable/Updateable Cursors & OLEDB Rowsets opened via Select query.
Last time I have heard that MSFT is planning to add this in the future.
Is there a beta version that I can try
Thanks,
Konstantin
-
- NSTL Guidelines for Motorola Q
by itsRashmi
- 2 Replies
- Last post
by itsRashmi
-
Hello all,
We have some doubts regarding NSTL guidelines for motorola Q. Our application is managed application. Which ocasionally connects to server. It is very helpful if we can get answers urgently.
Hopper Test ¨C How can we make it run on Smartphone 5.0 (Motorola Q) Is this tool only applicable for pocket pc 2003
Applicati
-
- Persist ConnectionString
by Subin556222
- 1 Replies
- Last post
by DarrenSQLIS
- Hello All,
I have changed connection string property of connectionmanger at runtime and saved package.But my new connectionstring is not persisting, i am getting my old connection string after reload package .
ConnectionManager cm = package.Connections[test.ConnectionManagerID];
cm.ConnectionString = @"C:\Test.csv" ;
app.SaveToDtsServer(package, null ,
-
- Shortcut to insert new GUID into uniqueidentifier cell in MSSQL Management Studio Express?
by Iggy Kay
- 5 Replies
- Last post
by Kent Waldrop Au07
- Hi, anyone knows if there's an easy way to insert new GUIDs into uniqueidentifier cells when editing data in table on Management Studio Express or Visual Studio 2005 Server Explorer I can't find a shortcut, and copying from external tools is pain.. I suppose it's possible to build a VB macro in Visual Studio, would it work when editing table data Thanks in advance!
-
- Query Analyzer -- Northwind dbs?
by _Leon_
- 1 Replies
- Last post
by Samuel Lester - MSFT
- Hi Everyone, I have a question in regards to SQL Server 2000 and its Query Analyzer. I am trying to create certain queries and I need a Northwind database to work with. However, I can't seem to add the database to the dbs' combo box. Basically, I could not find the way to add this database to the analyzer so I can practice with it. Only databases that are there are the system's ones: Master, Model
-
- Object reference not set...
by MLCollins
- 3 Replies
- Last post
by MLCollins
- Hello. I'm getting an error - "Object reference not set to an instance of an object" when running an SSRS report with graphs. It only happens when the returned dataset is empty (based on parameters set by the user, it is possible to return no rows). I've tried using the NoRows property (I entered "No Data" in the property box), but I still get the same error. Is there another w
-
- How to verify the validity of a file prior to attempting restore?
by hassiah
- 3 Replies
- Last post
by hassiah
- Hello, I would like a way to check a file before attempting to restore it. I want to be able to tell that this is a valid SQL backup file and not just some random file before I attempt a restore. Any help would be appreciated! hassiah
-
- ANN: Data Dynamics Reports public beta
by James Johnson - DD
- 0 Replies
- Last post
by James Johnson - DD
- Data Dynamics is pleased to announce that the Data Dynamics Reports public beta has been released.
Introducing Data Dynamics Reports, a new royalty-free reporting toolkit for Microsoft .NET developers. Based on the Report Definition Language (RDL), Data Dynamics Reports integrates into Web and Windows Forms applications and provides a rich API with which to create and modify reports.
In addi
-
- How is the data secured over the air in Merge Replication ?
by nabeelfarid
- 4 Replies
- Last post
by mmmmBeeeer
- Dear ppl,
I have a question for you. One of our client has asked us how is the data secured over the air during Replication
I have read that Merge Replication uses TLS (Transport Layer Security) protocol to secure the data over the air. But I was wondering if it is all done automatically Or do we need to install certificates like for SSL.
We have a Windows Mobile 5.0 application using SQ
-
- Possible to access no. rows in groups outside the table?
by MrOctree
- 4 Replies
- Last post
by Shyam Sundar
- Hi there,
I'm currently grouping data on some criteria, the way the data works basically means that there are between 2-3 groups guaranteed (no more). In the Group Header I have CountRows(table1_group) thus giving me the total number of rows in each group at the top of each grouping. However, I need to do a calculation in a textbox above the table using these row counts. The m
-
- sql and xphome
by NLglenna
- 3 Replies
- Last post
by bass_player
- Hello group,
I am new to sql.
We are attempting to set up sql express on o/s xphome.
The database we need to set up is for staff scheduling and the program is written using access.
Has anyone has success doing this
Thanks,
Glenna
-
- Logical fragmentation
by Ankith
- 2 Replies
- Last post
by Sherry Li from MSFT
- Hi:
when does a table not show any Logical fragmentation
1). Is it possible if the table has only non-clustered indexes and no clustered indexes, it wont show any logical fragmentation at all or shows less logical fragmentation .
Also what is the difference between logical fragmentation and Physical fragmentation of a index .Is there actually something like a physical fragmentation for a
-
- Diagram to Clipboard
by JimBobJames
- 1 Replies
- Last post
by Jens K. Suessmeyer
- Does anyone know how to automate the copying of a sql server 2005 database diagram to the clipboard so that this could for instance be accomplished from a word template. Does SQL Server 2005 expose an interface so that you can do this
I am trying to automate the copying of a database diagram into a word doc - can be done manually by right clicking on the diagram and sending to clipboard, p