Pre-Populating Report Tables

Nov 28, 2007

Hi. I have a report which has several datasources which require a table to be populated before they read from it.
i.e. The first thing that needs to happen whenever the report is run, is a call to a stored procedure which populates the table the report datasources are based off of. The SP takes several minutes to complete and MUST complete before any of the datasources fetch their data.

How can this be achieved?

I can not find anything in the Visual Studio Report Designer which allows to me to instruct Datasource B to not execute before Datasource A has completed (or any other way to call a data population SP, before the data reader SP's execute).

Thanks.

View 2 Replies


ADVERTISEMENT

Populating A DB From 2 Tables (Dynamic)

Apr 27, 2005

Hi

I am quite new to the complexities of MS SQL and have a problem, I would like to resolve. I have 2 tables with a unique identifier in both and want to populate a new table with information from both, but the second table I would like to populate just some fields that have a DOB eg

Table 1:
uniqueId
Name
Address

Table2:
uniqueId
Type
Setting

example of content for Table 2:
uniqueId Type Setting
123 DOB 03/04/74
234 TFN 12345678
567 POA Mr Smith

So the new table needs to be populated with a ll of info in table 1 and has a new field called DOB so only the clients with a DOB should populate this field, if the client in Table 1 has a TFN reference, this record should be added to the new table but no value needs to be entered eg

123 Chris Smith 1 high street 03/04/74
234 Jon brown 2 high terrace <Null>

Cheers
pommoz

View 1 Replies View Related

Populating 2 Tables At A Time

Oct 19, 2007



Hi,


I have a table in Sql 2005 called

Customers
CustomerId
CustomerName
CustomerAge
CustomerRank
CustomerStCode


I have to transfer the records into 2 tables


CustomerMaster
CustomerId
CustomerStCode


CustomerDetails
CustomerId
CustomerName
CustomerAge
CustomerRank


I have to pick up a row from Customers and transfer it to CustomerMaster and CustomerDetails. CustomerId of CustomerMaster will be the CustomerId of CustomerDetails while transfer. Similarly for all other rows in Customers.


How to do this?

thanks

View 5 Replies View Related

Report Populating Incorrectly

Aug 29, 2004

I have a customer who is running a script that generates a custom report. IT is not populating as it should and is returning zeros for everything.

I have tested the the script in the office and it is populating as intended. I have run a debug on the script and it is executing the correct SQL commands. The debug results for the customer and for the one tested in the office are identical. For some reason, the script is not writing to file but is looking at the correct data. I suspect that it is an environment issue most likely on the SQL level.

Could this be an issue with character set? How can I check their character set and language preferences? I understand they are set during installation.

They are using the same collation as us.

What else can I check as I am running low on ideas.

I advised the client to create a new DB and restore over the top. The script was then tested and it was found to be working fine. As it was given an inappropriate name (ie test), I advised to create a new DB with a production name and restore over the top again. We have since returned back to where we started as the report is generating only zeros.

H E L P !

View 1 Replies View Related

No Data In The Report After Populating DB

Oct 31, 2007



HI,

I populed my data base. But before I populate I created some reports beased on this DB. Now after I populating I can execute query and see results in Management studio or query designer. But When I change it the report to preview mode I can not see it.
Does anyone know why this is?

Thanks

View 2 Replies View Related

Automating Populating Tables At A Certain Time.

Apr 21, 2000

Hi,

I am new to SQL Server7. I need to populate some tables from an SQL Server7
database at the end of the day. How can I automate this process?
I also need to export these populated tables to a text file on daily basis.
I know I can use "DTS" to do this. But is there any way to make these
automated also? Or is there any third party tool to do all these?

Thanks in advance.

Mkhan

View 1 Replies View Related

Populating 2 Tables Using Flat File

Dec 12, 2005

Hi!

I'm trying to setup a DTS that reads a flat file uses a Data Driven Query task and then selects ONLY records that does not exist in the database and then INSERT them to DB1.

This works fine but I need to add another functionality.

I need to create a record on another table(DB2) based on the freshly inserted records in DB1 using only some of the fields. How do I do it?

Is setting up a trigger possible so that everytime a record is inerted in DB1 it will automatically a populate DB2?

Flat file:
ID
Name
Phone

DB1
ID
Name
Phone

DB2
ID
PHone
Event (from 00 to 10)
NumActions (initialized to 0)

Please help.

Thanks.


$3.99/yr .COM!
http://www.greatdomains4less.com

View 2 Replies View Related

Populating DataGridView With Data From Two Tables?

Oct 11, 2007

I am sorry for asking such a broad question, but I have been working on this and from what I can gather it can be done. My problem is that much of it has gone right over my head and I am getting more confused the more I read... I'm really, really confused...

Basically, I have a dataGridView that is populated with a number of fields from Table1 (ID, NameID, Status, Phone, Notes). This works fine, BUT I would like to access Table2 and have, where ID in Table2 = NameID in Table1, it load the First Name & Last Name into the dataGridView. I am able to load the information from Table 2 like so: SELECT NameFirst + ' ' + NameLast from Table2", but I can't get both Tables to work correctly.

I would like the dataGridView to be layed out like this:

ID NameID Name (NameFirst + NameLast) Status Phone Notes

I can't for the life of me understand or get this to work (Or for that matter even understand what I am trying to do...

Also, I am using Access 2007.

I would greatly appreciate some help, and possibly some explanation in laymans terms so that I might be able to understand this. I have read a lot about this, but for whatever reason it is just soooooo over my head that I can't follow it whatsoever.

Here is the code as it stands now:

//Populate the DataGridView
string conString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Environment.CurrentDirectory + @"DB.accdb;Jet OLEDBatabase Password=MyPassword;";

// create and open the connection
OleDbConnection conn = new OleDbConnection(conString);
OleDbCommand command = new OleDbCommand();
command = conn.CreateCommand();

// create the DataSet
DataSet ds = new DataSet();

// run the query
command.CommandText = "SELECT ID AS [#], NameID AS [Name], Status AS [Status], Phone AS [Phone], Notes AS [Notes] FROM Table1 WHERE ID = " + textBox13.Text + ";";
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter = new OleDbDataAdapter(command);
adapter.Fill(ds);

// close the connection
conn.Close();

bindingSource1.DataSource = ds.Tables[0];

dataGridView1.DataSource = bindingSource1;

// set the size of the dataGridView Columns
this.dataGridView1.Columns[0].Width = 10;
this.dataGridView1.Columns[1].Width = 100;
this.dataGridView1.Columns[2].Width = 100;
this.dataGridView1.Columns[3].Width = 100;
this.dataGridView1.Columns[4].Width = 176;

Any help and information is greatly appreciated.

Thanks Again,

View 5 Replies View Related

Populating Existing Tables With Excel File

Aug 12, 2005

I need to populate tables in my MS SQL 2000 DB with content from an excel file. I am not sure how this is done or how to format the excel file. If someone could help me with this it would be much appreciated!Thanks!

View 3 Replies View Related

Beginner: Trouble Creating And Populating Tables

Oct 16, 2007

Hey guys, I'm an old DevShed member, but my old account isn't working for some reason, so I had to recreate..

I've recently decided to learn MS SQL, and having some trouble with creating and populating tables. Using MS SQL Express 2005.

Heres the code, I keep reading through my notes on how to do it, but I cant see what I'm doing wrong. This is my first attempt at it, so there may be more wrong that I think.


Code:


drop table Property_rental;
drop table Property_type;
drop table Property_owner;
drop table Staff;
drop table Tenant;
drop table Tenant_category;

create table Tenant_category
(TCATID SMALLINT PRIMARY KEY NOT NULL,
TTYPE NVARCHAR(15))
;
create table Property_type
(PTYPEID SMALLINT PRIMARY KEY NOT NULL,
PTYPE NVARCHAR(20) NULL)
;
create table Property_owner
(POWNERID SMALLINT PRIMARY KEY NOT NULL,
FNAME NVARCHAR(20) NULL,
SNAME NVARCHAR(20) NULL,
CONTACT NVARCHAR(15) NULL,
ADDR NVARCHAR(50) NULL)
;
create table Staff
(STAFFID SMALLINT PRIMARY KEY NOT NULL,
FNAME NVARCHAR(20),
SNAME NVARCHAR(20),
CONTACT NVARCHAR(20))
;
create table Property_rental
(ID SMALLINT PRIMARY KEY NOT NULL,
PTYPEID SMALLINT NOT NULL,
STAFFID SMALLINT NOT NULL,
POWNERID SMALLINT NOT NULL,
CONSTRAINT Prop_Type_fk FOREIGN KEY(PTYPEID) REFERENCES Property_type(PTYPEID),
CONSTRAINT Prop_Staff_fk FOREIGN KEY(STAFFID) REFERENCES Staff(STAFFID),
CONSTRAINT Prop_Owner_fk FOREIGN KEY(POWNERID) REFERENCES Property_owner(POWNERID))
;
create table Tenant
(TENANTID SMALLINT NOT NULL,
TCATID SMALLINT NOT NULL,
ID SMALLINT NOT NULL,
FNAME NVARCHAR(20),
SNAME NVARCHAR(20),
CONTACT NVARCHAR(20),
COMMENTS NVARCHAR(20),
CONSTRAINT Ten_Cat_fk FOREIGN KEY(TCATID) REFERENCES Tenant_category(TCATID),
CONSTRAINT Ten_Prop_fk FOREIGN KEY(ID) REFERENCES Property_rental(ID),
CONSTRAINT Ten_pk PRIMARY KEY (TENANTID, TCATID, ID))
;




Error messages I'm getting;


Code:


Msg 547, Level 16, State 0, Line 55
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 56
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 57
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 58
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 59
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 60
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 61
The INSERT statement conflicted with the FOREIGN KEY constraint "Ten_Prop_fk". The conflict occurred in database "master", table "dbo.Property_rental", column 'ID'.
The statement has been terminated.

Msg 547, Level 16, State 0, Line 82
The INSERT statement conflicted with the FOREIGN KEY constraint "Prop_Staff_fk". The conflict occurred in database "master", table "dbo.Staff", column 'STAFFID'.
The statement has been terminated.

View 6 Replies View Related

Test - Populating Tables With Dummy Data

Aug 24, 2006

In 2000, BCP seemed the way to go. DTS packages would also work. My question is, in 2005, what is the best choice? I seem to remember that BCP ignored all referential integrity constraints, and applying them afterwords was a royal pain. I'm not a BCP expert by any means. Running this at the command line means using the DOS prompt correct?

What is 2005's answer to this?

View 4 Replies View Related

Saving A Report To Excel And Populating Formula's

Feb 12, 2008

Is there a property or a format type that I can use on a field to enter an excel formula and have it actually be a formula once it is saved to excel out of reporting services.

This is a 'what if' report. That the users want to fiddle with after it is generated.

I have item number, cost, sell price, and discount from the database. I calculate the gross profit and the percent from those fields. They want to take this report, save it to excel and then have the gross profit change when they enter a new discount amount.

I have tried to just enter the fields like they would look in excel but the report just shows A3 - A2. If I use the = before it will not run and says A3 is not defined. I have tried quotes, parenthesis, square brackets any thing that looked remotely possible in properties menu to have the values save as a formula.

I don't think it is possible but would like a second opinion.

View 1 Replies View Related

T-SQL (SS2K8) :: Populating Tables With Entries From Windows Folders?

May 18, 2015

I have 14 Windows folders containing a mix of Word and PDF documents. Each folder contains up to 500,000 files and these documents are the source for a document management system.

I need to create an audit table which can take the file names and date modified for every document in each folder but I want to avoid having to do a DOS command like dir *.* > filenames.txt then importing as a text file 14 times. Is there a way of automating this in T-SQL?

Each Windows folder is named by year e.g. 2002Docs, 2003Docs, 2004Docs etc.

Documents within the folders are named like this - 20020401_doc1.doc, 20020401_doc2, 20020401_doc678.pdf etc.

View 9 Replies View Related

Fact Table With 3 Keys From Dimension Tables - Avoid Populating NULLs

Jun 10, 2014

I created a Fact Table with 3 Keys from dimension tables, like Customer Key, property key and territory key. Since I can ONLY have one Identity key on a table, what do I need to do to avoid populating NULLs on these columns..

View 3 Replies View Related

Data Warehousing :: Populating Fact Tables With Surrogate Key From Dimension Table?

Sep 11, 2015

How do I correctly populate a fact table with the surrogate key from the dimension table?

View 4 Replies View Related

Report Parameter Populating Another Report Parameter

Feb 16, 2007

OK, I'm pretty sure that the answer to my questions is "no", but the boss is pushing, and I thought I'd double check.

I want the selection of one report parameter to decide what shows up for another report parameter. Specifically in my case it has to do with dates. I have narrowed the results down to monthly dates, meaning that the starting dates always start with mm/1/yyyy and the ending dates are always mm/31/yyyy (for a 31 day month).

The boss wants the ending dates to always be >= the month of the starting dates. So, if the user choose 1/1/2007 for starting, the minimum ending date would be 1/31/2007, etc.. Since the parameters are loaded at report initiation, and SSRS isn't really event driven, I didn't think this was possible. I just wanted to make sure before I tell the boss that it's not. Please advise.

View 2 Replies View Related

Reporting Services :: SSRS Report Export In Excel To 2 Pages Where Have 2 Tables In Report

Sep 21, 2015

I have a ssrs report having 2 tables in with 4 columns in each. When I go to export option in preview I can see all data coming in one excel sheet, But I am trying to get 2 tables in 2 different pages in Excel when I export.First page of excel comes with first table data with 4 columns and second page of excel comes with second table data with 4 columns .

View 2 Replies View Related

Multiple 1:N Tables In Single Report Builder Report

May 31, 2007

The version of Report Builder I have will only let me choose from a very limited range of layouts. For example, the tabular layout displays a single table on a page.



Is there a way to produce a report containing two tables and other fields?



For example, I would like to create a very simple customer report with customer name and address at the top, then a table containing all contacts I have for the the customer (a 1:N sub-table of customer) and then a second table containing all the orders from the customer (a 1:N sub-table of customer).



Is this possible in the current version of Report Builder or is it planned in a future relase?



P.S. I know this is easy in VS Report Designer but I specifically want to do this in Report Builder. The Report Designer client is simply too complex for my non-technical user base. Report Builder would be ideal.

View 3 Replies View Related

Need Help Populating A Variable (using .Net && C#)

Mar 28, 2008

I'm trying to populate the variable "STATUS" with the BEFORE value from TABLE1 to insert into TABLE2, but not sure how to do that. Attached is a stripped down code I'm working on. Sorry, I'm new at this...// some variable stuff      protected ErrorText ErrorText1;protected System.Web.UI.WebControls.DropDownList DISP_CD;public System.Web.UI.HtmlControls.HtmlInputText DISP_DOC;protected System.Web.UI.HtmlControls.HtmlInputText DISP_DATE;protected System.Web.UI.WebControls.DataList DataTagList;protected System.Web.UI.WebControls.Button BtnUpd;public string STATUS = string.Empty; <---- Help me.// some update stuffprivate void UpdateTable(){ using(DatabaseConnection conn = new DatabaseConnection()) {      try  {   conn.OpenConnection(devSettings.junk);   for (int i = 0; i < DataTagList.Items.Count; i++)   {    HtmlInputText textTag =    (HtmlInputText)DataTagList.Items[i].FindControl("TagList");         if (textTag.Value.Trim() != string.Empty)     {      GetOldStatus(conn, textTag.Value.Trim()); <---- Help me.      UpdateTable1(conn, textTag.Value.Trim());      UpdateTable2(conn, textTag.Value.Trim());     }     }   }   catch ( Exception ex )   {    conn.Rollback();    throw ex;   }  }}// some sql table stuffprivate string GetOldStatus(DatabaseConnection conn, string tag){ StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("  SELECT  "); sqlStr.Append("  STATUS  AS STATUS"); <---- Help me. sqlStr.Append("  FROM  "); sqlStr.Append("  TABLE1  "); sqlStr.AppendFormat(" WHERE TAG in '{0}'", Functions.DBFormatUpper(tag)); conn.Update(sqlStr.ToString()); return sqlStr.ToString();}private string UpdateTable1(DatabaseConnection conn, string tag){ StringBuilder sqlStr = new StringBuilder(); sqlStr.Append(" UPDATE TABLE1 "); sqlStr.AppendFormat(" SET DISP_DOC = '{0}',",Functions.DBFormatUpper(this.DISP_DOC.Value)); sqlStr.AppendFormat(" DISP_DATE = to_date('{0}', 'mm/dd/yyyy'),", DISP_DATE.Value); sqlStr.AppendFormat(" STATUS = '{0}',", Functions.DBFormatUpper(DISP_CD.SelectedValue)); sqlStr.Append(" UPDT_DATE = sysdate "); sqlStr.AppendFormat(" WHERE TAG in '{0}'", Functions.DBFormatUpper(tag)); sqlStr.Append(" AND STATUS in ('1','2','3')"); conn.Update(sqlStr.ToString()); return sqlStr.ToString();}private string UpdateTable2(DatabaseConnection conn, string tag){ StringBuilder sqlStr = new StringBuilder(); sqlStr.Append(" INSERT INTO TABLE2 ("); sqlStr.Append("  TAG"); sqlStr.Append(" ,DATE"); sqlStr.Append(" ,FIELD1"); sqlStr.Append(" ,FIELD2"); sqlStr.Append(" ,BEFORE"); <---- Help me. sqlStr.Append(" ,AFTER");  sqlStr.Append(" ,USER"); sqlStr.Append("   )"); sqlStr.Append(" VALUES ("); sqlStr.AppendFormat("  '{0}'", Functions.DBFormatUpper(tag)); sqlStr.Append(" ,sysdate "); sqlStr.Append(" ,'JUNK1'"); sqlStr.Append(" ,'JUNK2' "); sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(this.STATUS)); <---- Help me. sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(DISP_CD.SelectedValue)); sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(devState.UserId)); sqlStr.Append("   )"); conn.Update(sqlStr.ToString()); return sqlStr.ToString();}

View 1 Replies View Related

Populating Dropdownlist

Mar 23, 2006

I've got the following code and it's not really what I want. With the below code I can select in a dropdownlist a value and in the other dropdownlist the correspondending value will be selected. But when I select a value the second dropdownlist won't be filled with all the data in the database. It is filled only with the correspondending value and not with the rest of the value. When someone changes his mind and want to select a value in the dropdownlist it can't be done. Any ideas??Default.aspx:<body>    <form id="form1" runat="server">    <div>        <asp:Label            ID="Label1"            runat="server"            Text="Botanische Naam: ">        </asp:Label>        <asp:DropDownList            ID="DDL1"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeBotanicName"            DataSourceID="SqlDataSource1"            DataTextField="Botanische_Naam"            DataValueField="Botanische_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource1"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource2"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]WHERE [Botanische Naam] = @Title1">          <selectparameters>              <asp:controlparameter              name="Title1"              controlid="DDL1"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>         <asp:Label            ID="Label2"            runat="server">Nederlandse Naam:</asp:Label>                <asp:DropDownList            ID="DDL2"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeDutchName"            DataSourceID="SqlDataSource3"            DataTextField="Nederlandse_Naam"            DataValueField="Nederlandse_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource3"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource4"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]WHERE [Nederlandse Naam] = @Title2">          <selectparameters>              <asp:controlparameter              name="Title2"              controlid="DDL2"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>     </div>    </form></body>Default.aspx.vb:Partial Class _Default    Inherits System.Web.UI.Page    Sub ChangeBotanicName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL2.DataSourceID = "SqlDataSource2"    End Sub    Sub ChangeDutchName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL1.DataSourceID = "SqlDataSource4"    End SubEnd Class
P.S. I posted this before but can't find it anymore so here it is again

View 3 Replies View Related

Populating A Table

May 19, 2004

I have a table with a list of products,once I enter the data into the table and start using it on my web site as a drop down list,the list is sorted as an alphabetical list,is there are way to have a single drop down list but still be able to group the those products,in order words force them not to get sorted aphabetically.


Thanks

View 11 Replies View Related

Populating A Table

May 11, 2007

Hi, I have two tables:

1. RubricReportDetail with columns LocalPerf, Age
2. SppIndicator with columns Pct, Age

How can I populate the values of LocalPerf with Pct by matching

RubricReportDetail.Age = SppIndicator.Age ??

Please help me. Thanks in advance.

View 15 Replies View Related

One Of The DatSets Is Not Populating

Aug 16, 2007

Hi Guys!!

I have a DataSet (which requires 2 parameters), and for some reason even though it works in Query Analyzer and on the Data Tab of VS2003 it will not work when I choose to Preview it. Can anybody shed some light on this behaviour?

If you need to see the dataSet I can post it up!
Thanks!

View 2 Replies View Related

Report From 2 Tables

May 24, 2007

Hi Guys,

I am trying to build a report that will present data from 2 sql tables. Here is the scenario:



I have 2 Tbales:

1. TimeSlots - has SlotID and Time columns

2. Reserv - has SlotID, Name, Comments, Date



I am trying to build a report that will show all SlotID's from TimeSlots for a certain Day. The report should show all Time slots regardles if there is a reservation for that TimeSlot, also the Name and Comments for the Time Slot that is reserved.

The idea is that if a time slot is not reserved it should still print on the report which will then be given to the user who will manually pencil in the data should a pop up reservation occurs.



For Example:



SlotID Time Name Comments

1 6:00

2 6:15 Sven Employee

3 7:00 Randy Employee

4 7:15



Please help as i am lost!



regards

SD

View 3 Replies View Related

Populating A Table With A Dataset

Apr 17, 2007

I am running a program that populates tables on my local database by querying another database. 

View 2 Replies View Related

Populating Data Between Ranges

Oct 3, 2007

Hi All,
I have a startdate (01/11/2007) and a enddate (01/11/2008).  I need to add dates into a table for everyday between these dates.  Can anyone help?

View 1 Replies View Related

Populating Labels From A Query

Apr 22, 2008

 
I have a page that is part of a 5 page wizard.  The wizard gathers data for a claim filter.  The second page is laid out with four labels at the top
Filter Name:  <filterName>     -- filterName_LFilter Description: <filterDescription>    -- filterDescription_LFilter Data Source: <filterDataSource>    -- filterDataSource_LFilter Purpose: <filterPurpose>     -- filterPurpose_L
--I have written an sp to populate these four label.Text values. I want to populate them on page load. 
Two questions. How do I get four output values out of the sp?  Is there a better way to do this than an sp?
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO
 
-- =============================================-- Author:  <Author,,Name>-- ALTER  date: <ALTER  Date,,>-- Description: <Description,,>-- =============================================ALTER   PROCEDURE [dbo].[a_spNewFilter_Step1_Summary] -- Add the parameters for the stored procedure here @filterID int ,
 @filtername varchar(100) OUTPUT, @filterdescription varchar(250) OUTPUT, @filterOwnerID int OUTPUT, @filterDataSourceID INT OUTPUT, @filterPurposeID int OUTPUT
ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements.SET NOCOUNT ON;
--DECLARE @FilterID int
--SET @filterID = 14
SELECT   filterIsComplete, filterCreateDate, filterStep1Complete, filterName, filterDescription,  das.AuditorFirstName + ' ' + das.AuditorLastName as FilterOwner, dfds.filterDataSource, dfp.filterPurposeFROM a_factSamplingFilter_2 fsfINNER JOIN dbo.a_dimFilterDataSource dfdsON dfds.filterDataSourceID = fsf.filterDataSourceIDINNER JOIN dbo.a_dimAuditStaff dasON das.AuditorID = fsf.filterOwnerIDINNER JOIN dbo.a_dimfilterPurpose dfpON dfp.filterPurposeID = fsf.filterPurposeIDWHERE filterID = @filterIDGROUP BY  filterIsComplete, filterCreateDate, filterStep1Complete, filterName,  filterDescription,  das.AuditorFirstName, das.AuditorLastName, dfds.filterDataSource, dfp.filterPurpose
 
END
 
GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO
----
protected void Page_Load(object sender, EventArgs e)    {
        int filterID = int.Parse(Request.QueryString["filterID"]);  /// grab the filterID from the URL query string
        string connectionString = WebConfigurationManager.ConnectionStrings["DDT"].ConnectionString;        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand("a_spNewFilter_Step1_Summary", con); // get the values from filter setup step1        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@FilterID", SqlDbType.Int)); // using the filterID created in step1        cmd.Parameters["@FilterID"].Value = filterID;
        cmd.Parameters.Add(new SqlParameter("@FilterName", SqlDbType.VarChar, 100));        cmd.Parameters["@FilterName"].Direction = FilterName_TB.Text;
        cmd.Parameters.Add(new SqlParameter("@FilterDescription", SqlDbType.VarChar, 255));        cmd.Parameters["@FilterDescription"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterOwner", SqlDbType.VarChar,50));        cmd.Parameters["@FilterOwner"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterDataSource", SqlDbType.VarChar,50));        cmd.Parameters["@FilterDataSource"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterPurpose", SqlDbType.VarChar,100));        cmd.Parameters["@FilterPurpose"].Direction = ParameterDirection.Output;
        con.Open();
        try        {            cmd.ExecuteNonQuery();        }        finally        {            con.Close();        }
        ///get name, description, owner, datasource, purpose
 
    }
 

View 1 Replies View Related

Populating An Array From A Sqlreader

Jun 8, 2006

I am trying to populate an array from a sqlreader.  I am getting the error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".  Can anyone help?  I have my code below.
        Try            sql = "...."            cmd = New SqlCommand(sql, conn)            SqlReader = cmd.ExecuteReader       'Get the data from SQL Server            Dim Counter As Integer = 0                        Do While SqlReader.Read()                    Counter += 1                    PageArray(Counter) = SqlReader("WebPageID")           Loop                    Catch ex As Exception            lblMessage.Text = ex.Message        End Try

View 5 Replies View Related

Populating 2 Variable At The Same Time In An SP.

Dec 3, 2001

Following is an example of a query which I use in a SP.
<BR><BR>
What I would really like to do is set both variables with one query. Can I get both data elements with one query, or do I have to run 2 queries to set 2 variables? This query is going to run over 2 servers and would like to save the extra trip.
<BR><BR>
set @int_MCID = (select top 1 iPID from customers inner join tblPersonnel on MtgConsultant = iPid where phone1 = @str_Phone and Position = 'Consultant')
<BR><BR>
set @int_LocID = (select top 1 iLocID from customers inner join tblPersonnel on MtgConsultant = iPid where phone1 = @str_Phone and Position = 'Consultant')
<BR><BR>
Select @int_LocID, @int_MCID
<BR><BR>

View 2 Replies View Related

Populating Data In A Pdf File

Jan 18, 2005

Hi

Need to populate data from SQL Server in a pdf file which is basically a government form.

Data should be fetched from the SQL server database and needs to be displayed in a pdf file.

Advice me on how to implement this.

Suggest me if there is any other idea for implementing the same.

Thanks in advance

View 1 Replies View Related

Populating Database With Timestamps...

Jan 19, 2005

Hi Everyone....

Crazy one here....

I need to populate a table with all the times that
are available in a 24 hour period, down to the 5 minute
interval.

So the table should look like....

id ds (datetime stamp)
--- --------------------------
0 1/1/2005 00:00:00
1 1/1/2005 00:05:00
2 1/1/2005 00:10:00
3 1/1/2005 00:15:00
.........
xx 1/1/2005 23:55:00



Please advise on a way to accomplish this in a script....

thanks
tony

View 14 Replies View Related

Populating Data From One SQL Database To Another

Jul 13, 2007

I have a project that entails the following:

There are two separate SQL Server databases involved that reside on two different servers. One of the depts within our building wants to have building permit data imported from Permit Database on Server "A" to their own database on Server "B".

I dont think this will be an overly complicated process. There are only a few fields they want populated (5 or 6 tops). This will have to be ran every
weeknight via some sort of scheduled task in Windows or SQL.

I was just interested in seeing if anyone has had prior experience working on data transfer like this. I would like to know what would be the best and most efficient way to approach this.

Thanks in advance.

View 9 Replies View Related

T-SQL (SS2K8) :: CTE Populating TVP Parameter

Aug 19, 2014

The stored procedure accepts a TVP table as a parameter. Will something like this work?

BEGIN
;with tree(Id) as
(
SELECT 1
UNION ALL
SELECT 2
)
EXECUTE [dbo].[Get_FooByIds] @tvpId = tree
END

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved