Answer Questions

• Kajal Sinha Getting the latest data from different fields in one SQL

  Hi, I'm trying to write some SQL which will give me the following result from the table below.. Currently I can do each of the PRICEx fields in a seperate query then join the results together. I do this by getting the MAX(Date) WHERE PRICEx IS NOT NULL then using that date to get PRICEx, and then repeat until I've done all the PRICE fields. This is acceptable for a small selection, but for a large selection this can get quite slow. I was just wondering if there is there a way to do this in one single SQL without having to join the table to itself 3 times (for all 3 PRICE fields) Now if you combine mine and limos you should actually get the correct result. create table #x ( ProductID int, MarketID int, Date datetim ...Show All

• JR2006 Displaying selected rows from a Fact table

  I have a fact table which stores data ( customer name, document type, editing start time, editing end time, editor, revision id etc) for each revision of a document. While displaying data however i need to take into account only the last revision of each document. What is the best way of doing this Do I need to create a separate dimension table with the document id and max revision id as fields or is there a better way of doing it I also need to create calculated members based on the lastnonemptychild. How do I do that Eg: for last nonemptychild ie. last revision I need to count the number of records that are of type 'S' I also need to calculate percentage of records of last revision that are greater than target ti ...Show All

• Kent Boogaart bit field---

  HI, while saving in bit field sometimes it is saved as true or false. sometimes it is saved as 0 or 1. how to make it true or false when i needed. if i set default value to 0 will it save 1 or 0 always. with default 0 i need to store truee or false. how it is possible this way. thanks venp--- Do the same query in the query window of SSMS and you will see that this is just a question of presentation. SSMS will display BIT as true / false but SQL Server stores 1/0. -Jens. Hi, 00 True False 01 True False 02 True False 210 True False 220 True False 250 True False 03 False False   ...Show All

• Peter D.252325 Database stress tester

  Hello Are there any database stress testing tools like database hammer bundled with any editions of 2005 Or is there a resource kit somewhere that has one Thanks Thanks for the replies I had heard of the database hammer, but I have never used it. I will try it as, as soon as I can find a copy of it somewhere! Is it available to download this is the closest thing from MSFT http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/ . The original DBHammer tool works with SQL 2005, I've used it several times on it, have you tried it third-party tool... ht ...Show All

• glasgow ERROR using GROUP BY

  Hi guys, The code below works fine if I take the "GROUP BY" Sentence out. Without the group by, I am getting something that looks like: Proj Nr Proj Name Proj Nr & Name 001 Proj 1 001 - Proj 1 001 Proj 1 001 - Proj 1 001 Proj 1 001 - Proj 1 002 Proj 2 002 - Proj 2 002 Proj 2 002 - Proj 2 002 Proj 2 002 - Proj 2 And I need only one line for each Proj, like: 001 Proj 1 001 - Proj 1 002 Proj 2 002 - Proj 2 (It is not because of the tables. It is because the Nr "001" is only a substring of the data) I thought I can use GROUP BY in order to get only one line for each Proj. This is the code I am trying: ...Show All

• KitWest Improvements to Scheduling of reports...

  The scheduler is difficult to use when debugging. There is not test-oriented "execute now" function or button, and there is no way to generate and email reports (these are data-driven) to a test user recipient (e.g., send every report to the developer, not to each individual recipient from the data source) without editing the To: field to a static value. Why not have a way to execute the report on demand, but with an option to substitute a static value in each of the to:, cc: and bcc: fields so it does not go to the query-based recipeints, without having to edit these fields and then edit them back Also, provide a way to see what parameters after @ can be used, such as @ReportName - what is the list of available param names C ...Show All

• Arty Saravana Sql2000 and C# express

  Hi, I'm experiencing a very strange problem I setuped sql2000 and c# 2005 express edition, and i created a database application, i create the sqlconnection inside the code dynamically, using ConnectionStringBuilder after i used System.Data.Sql. SqlDataSourceEnumerator .Instance.GetDatasources(); but it doesn't return instances, even when i disabled the firewall on my pc, but after i install sqlexpress it returns all of them, but in both cases i cannont access database in any instance when i try to addconnection from the wizard, the default data source is ./sqlexpress, and it's also in config files, why , and what changes i shall make so i can access sql2000 Thanks in Advance Hello, Thanks very much for help, ...Show All

• Object01 Regarding 3rd party SQL tools (Free Secure?)

  Hi guys, I just curious about 3rd party tools whether there are free secure to use and any recommend tools for SQL Currently I am using some tools like 'SQL Server Online Backup' and 'ApexSQL'. When I am using those 3rd party tools,is there any trace file or information (username & password) will be keep and send to other locations or 3rd party Thanx and hope can get any assistance or opinion here. Have a nice day. Best Regards, Hans Refer to http://www.sql-server-performance.com website and refer to the software spotlight for such information. Moving to Tools section as per the subject relevancy. ...Show All

• Mike Martin24365 No process on the other end

  Hi In installing sql express/management, during installion I get an error message when it comes to sql db services - It says setup failed because there is no process on the other end of the pipe. Also, When I go to Start/All Programs/Microsoft Server 2005/Configuration Tool it says empty This is running on Vista RC1 There is no way for me to enable remote connection When I start Microsoft Sql Server Management Studio there is no server name to select from or choose from browseing There is no sqlbrowser in SERVICES for me to start. Also not install during installation is the work station component. Any help Thanks I guess you won’t find any successfull help here, though Vista R ...Show All

• jitendra badkas SQL Server 2005 and SQL Server Compact Edition side-by-side

  Hi! It is possibile to install SQL Server Compact Edition side-by-side on the same machine where SQL Server 2005 is already installed Thanks, Marco. Sure. Consider that "SQL Server" Compact Edition does not use the same binaries as all of the other editions. It's based on an entirely different engine. There are many situations where it makes sense to use the lighter SQLCe database in lieu of or in addition to a full-blown SQL Server DBMS engine. hth Yes - no problem there ...Show All

• Damien Morton Outer join blues-sql 2005

  Hi there!! I want to have right outer join on two or more column between two tables.how can we do that in SQL 2005 as it does not allow us to use =* operator. basically i need below query in sql 2005 Select * from T1,T2 where T1.c1=* T2.c1 and T1.c2=* T2.c2 I tried this one Select * from T1 right outer join T2 on T1.c1=T2.c1 and T1.c2=T2.c2 --But this gave me different result. Thanks Rahul Kumar, Software Engineer the syntax u have used is correct... Select * from T1 right outer join T2 on T1.c1=T2.c1 and T1.c2=T2.c2 just see if u need right outer or left or full outer join......or maybe inner....=* is same as right out ...Show All

• PeterTPeterT Exam 70–443 (MCITP)

  Hi, Somebody can speak (tips) about exam Exam 70–443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Tips Amount Questions Time :-) ... also the book and the practice tests will give you a better idea of what to expect in the exam which is worth gold. all i can say is buy the 70-443 study guide book from amazon and signup for the practice test on www.measureup.com best way i think, the book will give you a voucher for 15% off when you sit the exam and if you signup to the newsletter from www.measureup.com they'll send you a voucher for 25% off their tests (runs january 2007). other than that, get dedicated and burn thru the book as best you can. i've set myself the end of feb ...Show All

• MaryAnn80 SQL Data Mirror Question

  Does any one have any recommendations concerning replication when it comes to hardware failure. I have many sites with one SQL Server in each - i'm contemplating the installation of hot spare servers in some locations - should a server die - I can put the hot spare into production fairly quickly, mainly because the DATA would Already be on the server - in other words a restore would not be needed thus lessening the time to get the spare server running etc etc. I'm exploring a third party tool called "Double-take" - byte level replication But then i read about SQL2005 (which we have not yet implemeted) that may have a built in SQL mirror possibility - (i might need primary server - a Secondary - and a "witness" ...Show All

• dotnetsr Sensitive data

  Hi all, How can we protect sensitive data (custom properties) in a custom connection manager or a custom data flow component The SSIS Books Online indicates in the " Security Considerations for Integration Services" page that "If you write custom tasks, connection managers, or data flow components, you can specify which properties should be treated as sensitive by Integration Services". But how to do it programmatically Are there any attributes that can be applied on custom properties Thanks. Pascal You might have more than one option here. I personally use DontSaveSensitive as protection level of the package and the use Package configuration to set the value of sensitive ...Show All

• Tiarnan SQL Server 2000 and 2005 on one machine?

  Hi, i have SQL Server 2000 running on my notebook for learning purposes. Is it possible to run SQL Server 2005 on the same notebook without using virtual machines Thank you, Tobias One thing to note about multiple instances in one box - make sure you have enough hardware resources to serve client requests Is it also possible to use both of them at the same time Without having one SQL stoped for accessing the other Because I still need SQL2000 for older projects, but the recent ones will run with SQL2005 and Reporting Services 2005. Thx Hi tki, yes this is possible. HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All