I have a database and i need to get some reports from it
table name is newatt
Sname Time Date
x 08:30 24/4/2010
x 10:30 24/4/2010
x 11:30 24/4/2010
y 12:00 24/4/2010
x 05:00 24/4/2010
View Complete Post
I have a requirement where i had to migrate the table structure and data from ODBC database to SQL Server. I have dynamic source reader that uses sql query from variable to get the data and the next step is to get the create statement and create table and
then to insert data. how can i get Create Statement the destination produces and use sql task to create the table and then insert the data using data flow task.
Here is an example of my question
I have a column called Department, a column called Employee Name and a column called EmployeeAbsent.
Obviously i can easily use a select satement to get each employee's absent status. However, I would like to generate an additional field called DepartmentAbsent to see if anyone in a particular depart is absent based on the EmployeeAbset field.
how should I write the query?
Any one please tell me how to create as object or attribute for the below Call statement.
Otherwise please guide me how to use the below statement in SSAS.
"Provider=SQLNCLI10.1;Data Source=DWHSRV01;Integrated Security=SSPI;Initial Catalog=Banking"
,"Exec Key 1")
I am using the following code to generate scripts, but no matter how i configure the options, it always generate create user statement
CREATE USER [tm] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[tm]
CREATE USER [SA_TenderManager] FOR LOGIN [SA_TenderManager] WITH DEFAULT_SCHEMA=[dbo]
CREATE SCHEMA [tm] AUTHORIZATION [tm]
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[FWRKFLWGATEREQ](
// Connection to Server
Server srv = new Server(ConfigurationManager.AppSettings["Server"]);
srv.ConnectionContext.LoginSecure = false;