• Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

    NET20085 pointsBadges:
  • Error inserting into table with identity column

    I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I'm not). Here is the code from the 2...

    Bleeb45 pointsBadges:
  • Alter SQL table

    hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i'm wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb 4 |cc |null 5 |dd |ee thx

    Lazy16755 pointsBadges:
  • SQL 2000 Upgrade

    I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

    0 pointsBadges:
  • How to make VB6 and SQL Server 2000 multiuser and client-server?

    how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx

    Chibi5 pointsBadges:
  • Running a lengthy query on SQL Server 2005

    We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server query

    how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

    Hodhod5 pointsBadges:
  • WSUS Server multiple instances of computers listed.

    I am very new to the Windows update server (WSUS). I installed and configured the update server and everything seems to be working. I added some settings in my group policy and applied the GP to an OU and went on my way. The clients started to appear in the list of workstations on the WSUS server;...

    Skepticals0 pointsBadges:
  • Making two records into one

    I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail AS...

    Fscopel15 pointsBadges:
  • DBCC CHECKDB

    before runing DBCC CHECKDB WITH repair_allow_data_loss, How can i know what table and data that will be deleted

    Sreenu125 pointsBadges:
  • SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 pointsBadges:
  • Retrieving Records based on Record Selection from another table

    I have an Access database (which eventually is going to SQL)that contains several tables. One table is contains categories of items that are available for purchase. The other tables contain those items that belong to the appropriate category. In other words I have categories of flowers, vegetables,...

    Tjlevin10 pointsBadges:
  • Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • DTS import/export

    Hi, I was wondering if the DTS import/export also recreate the table, the reason I am asking this I want to recreate a database using the Generate SQL Script but change the collation of the columns of the table, then import the data from that database to this new database. If it does recreate the...

    Db23290 pointsBadges:
  • Removing data in a column after a hyphen

    We imported a text file and one of the columns has first and last names in it. However, there is sometimes a hyphen with a title after the name. We need to create a SQL statement that will look for the hyphen and remove it and anything following it. Example: Column 1 Column 2 02/18/09 John Doe...

    Sunitalynn15 pointsBadges:
  • Changing Database Collation

    Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

    Db23290 pointsBadges:
  • Changing SQL Server name and SQL Server group name

    Hi, I have notice that our dev and prod SQL Server has SQL Server name and SQL Server group name that is different to the machine name. We are planning to change it to match the machine name. To do this, from what we have read, you change the SQL Server name using the sp stored procedures to drop...

    Db23290 pointsBadges:
  • Remote connection on SQL Server 2005 Express

    shibu.govind is online. shahina: http://support.microsoft.com/kb/914277 Sent at 11:26 PM on Tuesday shahina: F:\C#PROJECTS\QMSED2.0\QMSED\BIN\DEBUG\QMSED\QMSED.MDF Sent at 11:52 PM on Tuesday shahina: firewall.cpl Sent at 12:20 AM on Wednesday shahina: C:\Program Files\VMS\Rlink SMS Ed V2.0 3:35 AM...

    999559534735 pointsBadges:
  • Finding nth most recent action with SQL

    I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

    Munona995 pointsBadges:
  • Display Query for OS/400 SQL script

    Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

    Tomotsk75 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