Exchange – extracting email properties
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]

Answer Question   |  March 29, 2013  9:35 PM
Microsoft Exchange 2007, SQL Server tables

Joining unmatched tables with duplicates
Hi, I am a beginner SQL user and am trying to take table 1 (contracts) and pull in the calltype from table2 (equipment) with the control number as the common field. However, there are duplicate control numbers in table2 which are causing me an issue. I have created this query on table 2 to get [...]

Answer Question   |  November 29, 2012  5:50 PM
Microsoft SQL Server 2005, SQL Server tables

SQL Query
how to select only those table name from database that have a two field in table like PID amd EID table that have PID also have a EID in a single table those table i want to select

Answer Question   |  June 4, 2012  1:14 PM
SQL Server, SQL Server tables

Matching key question – resubmitted
Hi, resubmitting because the first upload did not seem to work… Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3…) Col2 has [...]

Answer Question   |  March 16, 2012  10:25 PM
SQL Server tables, SQLServer

Reading xml url into SQL Server 2008 Table with OpenXML
I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url [...]

Answer Question   |  June 28, 2011  5:21 PM
SQL Server, SQL Server 2008, SQL Server tables, SQL tables, XML, XML development

The SSIS 2008 R2 job does not complete execution
I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP’s some files to the local folder. I verified to confirm the files are downloaded correctly. 2. Truncate [...]

Answer Question   |  June 13, 2011  5:10 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Integration Services, SQL Server tables, SSIS, SSIS 2008, SSIS Job

SQL command question
I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don’t know how good this design is. Anyways I need to find out [...]

Answer Question   |  January 27, 2011  4:20 PM
SQL commands, SQL Server, SQL Server tables, SQL tables

Alter proc to fetch a table structure from SQL Server 2005 database
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]

Answer Question   |  January 7, 2011  9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

Create QA database with only some production tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They’re all in the same filegroup in the original database. I’ve done [...]

Answer Question   |  December 16, 2010  1:50 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables

Access or SQL Server tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]

Answer Question   |  December 16, 2010  4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables

Question on SQL 2005 table
tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000 ANAND             VIDEO TITLING                   16000 JULIANA           INVENTORY                        3500 KAMALA           PAYROLL PKG                    20000 MARY                FINANCIAL ACCT             85000 MARY               CODE GENERATOR          20000 PATTRICK        README                            1200 QADIR               BOMBS AWAY                 3000 QADIR               VACCINES                      3100 RAMESH             HOTEL MGMT                35000 RAMESH               DEAD LEE                    4500 REMITHA              PC UTILITIES                5000 REMITHA               TSR HELP PKG             6000 REVATHI             [...]

Answer Question   |  December 11, 2010  8:39 PM
SQL 2005, SQL Server 2005, SQL Server tables, SQL tables

Complex SQL query in SQL Server 2008 tables
Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

Answer Question   |  February 9, 2011  12:42 PM
SQL, SQL Query, SQL Server, SQL Server 2008, SQL Server tables

How to update one table field with the help of more than one table in SQL Server 2000
How to Update one table field with the help of more than one table

Answer Question   |  October 4, 2010  10:25 AM
SQL Server 2000, SQL Server tables, SQL Server Updates, SQL tables

Without Using Script in SSIS
HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script… please help me T_T…. Thx so much…

Answer Question   |  September 27, 2010  2:05 AM
Scripting, SQL Server tables, SQL tables, SSIS, Visual Studio 2005

Help navigating SQL Server 2008 database?
Hi all, I’m facing an interesting challenge… Lets say: I have a payment coming in and of course my client has not specified which of the 45 open invoices he is paying. The amount does not match any single invoice so it has to be a combined payment for 2 or more invoices. Now, I [...]

Answer Question   |  August 31, 2010  8:44 AM
SQL Server 2008, SQL Server 2008 administration, SQL Server database, SQL Server tables, VB.NET

How to display values in one table by referring and checking values in another table?
how to display values in one table by refering and checking values in another table

Answer Question   |  July 28, 2010  8:08 AM
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables

Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager
Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

Answer Question   |  July 16, 2010  6:05 AM
MySQL, SQL Server Enterprise Manager, SQL Server Table Migration, SQL Server tables

How to split a column into SQL data..
I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" width="590"> [strong]complete_name[/strong] [/td] [/tr] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" [...]

Answer Question   |  June 24, 2010  4:09 PM
SQL Server 2005, SQL Server tables, T-SQL

SQL Server table structure
Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

Answer Question   |  June 16, 2010  4:05 AM
SQL commands, SQL Server, SQL Server tables

Replicating a partitioned table to a secondary server
I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is done [...]

Answer Question   |  September 16, 2010  3:31 PM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning