• Retrieving specific XML data in SQL Server

    I have a question regarding SQL Server. I have a table with an ntext datatype column where I am storing XML data. My question is: How do I write a user-defined function to retrieve a particular xml attribute in that column?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Are the data warehousing,data-mining and document warehousing under the Database Management System?

    Hanzter5 pointsBadges:
  • Stop Error (C000021a)

    I am receiving this stop error(C000021a) "windows logon process system process terminated unexpectedly" with win 2000 server. Safe mode and Last Known Good Conf. works fine. Is there any solution without reformating the HDD? I have ERD with me. Will that help me? Any advise on this would be highly...

    BinooDas123410 pointsBadges:
  • About data management

    Hi i have same date like this; 1 ..... ..... 2 ..... ..... 3 -26 -28 4 36 -53 5 -40 -46 6 ... ..... 7 56 -64 8 -31 -29 ı want to change this date like this 1 ..... -28 2 -26 -53 3 36 -46 4 -40 ... 5 ... -64 6 56 -29 7 -31 ... 8 ... ... one column go up a line other column go up two line but...

    Bronzemoon5 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Working with totals

    I am trying to run cross-tabs (year x gender) on a data set made up of total scores (rather than frequencies) in each cell, but the output only gives me counts. Is there a command to let SPSS know that the cell figure is a total?

    Spcase5 pointsBadges:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003

    Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over...

    Sahaj5 pointsBadges:
  • How do I integrate SQL Server Integration Services and Blaze Advisor?

    I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • VFP9 DBF to Ms SQL

    is there tools available for converting VFP9 DBF to Ms SQL? or what is the best approach? thanks.

    B385 pointsBadges:
  • Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit

    The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

    Jmc5 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE352,580 pointsBadges:
  • access2k unicode text column even # of bytes error

    a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

    Santa35 pointsBadges:
  • Classic Applications Display as “Unix Executable Files” in Tiger and Don’t Load

    We just purchased an iMac G5, and I copied all of the applications/documents/etc. from the old computer, a G4 running 9.2.2 over to it. I installed the Classic system folder on the iMac (running Tiger) and have no problems getting it to load. The problem is that all applications that were copied...

    HailiFrank15 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • domain operational data stores vs. enterprise operational data stores

    When do use a domain operational data stores rather than a enterprise operational data store?

    Alisonnelson5 pointsBadges:
  • How to create blocks in SPSS

    I have a data file with 12,00 trial inputs. When I run my descriptives, I want to combine every 100 trials together as 1 block so instead of comparing 12,00 trials, I am looking at 120 blocks and comparing those. Is there anyway to do this without first going through and running the statistics on...

    Audreye5 pointsBadges:
  • having problem with SSIS package

    i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

    Atif5 pointsBadges:
  • DTS schedule package

    How can I see the scheduled run time of an existing DTS package?

    Hoverman5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following