Programming SQL

Inserting Excel data into SQL Server
Hi, I have an auto generated excel file(.xlsx) in a particular format . I tried importing the file to the SQL server database using the query below. SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB. 12.0','Excel 12.0 Xml;Database=C:\test \DashboardData.xlsx;HDR=No;IMEX=1','SELECT * FRO... 15 Jul 2008 01:02

How to build a spreadsheet like table - Rookie
Good morning. I'd like to extract data from a single table containing expenses, aggregating monthly totals by type. Here's the simplified structure of the existing table myTBL ======= - Amount (numeric) - Date (date) - Type (numeric) ======= Assuming the Type field means what kind of expense we have, fo... 15 Jul 2008 12:19

temp tables : to index or not to index
I've heard that a good rule of thumb for table vars vs temp tables is if you might be working with 10,000 or more rows go with a temp table, otherwise a table var. So, assuming working with a temp table of 10,000 rows , should indexes be used ? I see three possibilities : 1. create with an index 2. ... 16 Jul 2008 07:50

How get data returned by Stored Procedure ?
In my calling stored procedure how do I access the recordset returned by another stored procedure that I call? I know how to retrieve output parameters but how do I retrieve a recordset? Does it make any difference if I know only one record will be returned? Thanks ... 14 Jul 2008 19:54

Comparing against a table
I'm trying to generate a list of addresses from our address table that don't use standard street abbreviations or don't have any street title or abbreviation at all. The column in the address table that I need to look at is called address_1. I have a table called 'streets' that contains the street title and the ... 15 Jul 2008 11:17

Winform sql server app
Hi I am new to sql server and need to build a one-many winform app with visual studio 2008 and sql server backend and need some pointers. I have the following questions; 1. If I create the app by creating a relationship between master and child tables in dataset and then dragging the master table and rela... 17 Jul 2008 17:53

can pivot be applied to group by ?
For this table Id bigint identity(1,1) Attribute nvarchar(50) not null PeriodNumber bigint not null DataDateTime DateTime not null Value decimal(18,5) not null I need to retrieve each period as a row with its columns as a set of attributes' values. For example, if the attributes are 'Attr1' , 'Attr2'... 15 Jul 2008 10:14

Copying whole field of data from a table to other table
I was struggling for this one for a while. It could be very easy one, but I cannot seem to get it as I get an error. 1.Here is a task I have a table A which contains Acct# & a blank Contact field. I have a table B which contains Acct# & Contact field with data. I am trying to move Contact data from table B to ... 15 Jul 2008 21:37

can I reliably rollback TRUNCATE statement?
Can I assume that I can reliably rollback TRUNCATE statement? Will something like this work reliably: (I need Result table be always consistent). BEGIN TRY TRUNCATE TABLE Work INSERT INTO Work SELECT * FROM OPENQUERY (remoteserver, 'SELECT ….’) IF (SELECT COUNT(*) FRO... 15 Jul 2008 10:14

Using a temp table in dtspackage
I would like to be able to run a query based on joining a temp table with an existing table and export the result using dts. I select the " use query to specify the data to transfer" and paste the sql in the query statement window however I receive this error. Invalid table name #n Context: Error call... 14 Jul 2008 16:49