Dynamically Creating Features Grid

Mar 17, 2006

I was given what at first seemed a simple task (and maybe it is, but with everything else on my plate, I can't seem to get my head wrapped around this)...create a grid or table something similar to below:

               Plan A           Plan B                  PlanC                  PlanD

Item1         yes                yes                        no                        no

Item2         yes                 yes                      no                        no

Item3         yes                  no                     yes                        no

etc.....

 

The "plans" are stored in one db table, the "items" in another. What I can't seem to get straight in my mind is how to relate the yess and nos and then generate a tabular layout similar to the above.

I don't need anyone to do it for me, but a push in the right direction would sure be nice (using SQL 2005) Thanks!

View 2 Replies


ADVERTISEMENT

Dynamically Creating A SQL Connection

Mar 6, 2008

 Hi - hope someone can help. We're creating a ASP.NET C# site that allows a user to connect to any of our 100+ SQL Servers and query a database that sits on every server. I'm trying to work out (and failing) how we can set the 'Data Source' in a connection string dynamically using the server name selected by the user in a drop down box. Any help appreciated, thanks in advance, 

View 2 Replies View Related

Dynamically Creating Cube

Jun 21, 2005

Hi guys

I'm investigating whether if its possible to Dynamically create a cube. Then Process this cube before exporting it to a .cub file.

I know that DTS in sqlserver is able to process a cube given at a scheduled time interval. But I'm not sure how I can export a cube to a offline .cub file dynamically. The only way that i know to create a .cub file is via PivotTable in Excel.

Any help in pointing me to the right direction is appreciated.

Thankyou :)
Tom

View 1 Replies View Related

Creating A Table Dynamically

Jun 10, 2008

Greetings all,

I want to be able to generate a table on the fly. I know I can use dynamic sql to do this but my brains have forzen this afternoon so any help would be much appreciated.

I have the first query that returns one column with three rows. The contents of the these three rows will form the new columns in the dynamically generated table. How can I do this?

Thanks.

View 11 Replies View Related

Problem Creating Database Dynamically

Jul 29, 2004

Hi everybody,

I have a problem. When I try to create a database with this code:

strConnection = "server=(local);Integrated Security=SSPI"
objConnection = New SqlConnection(strConnection)
objConnection.Open()
Dim strSQL = "CREATE DATABASE xxxxxx ON PRIMARY"
strSQL += "(Name=test_data, filename = 'xxxxx.mdf', size=3,"
strSQL += "maxsize=5, filegrowth=10%)log on"
strSQL += "(name=mydbb_log, filename='xxxxx.ldf',size=3,"
strSQL += "maxsize=20,filegrowth=1)"
objCommand = New SqlCommand(strSQL, objConnection)
objCommand.ExecuteNonQuery()

it usually works, except when the name of the database (xxxxxx) contains a number in the beginning of the name or if it is all made up completely by numbers. I also converted the database name into a string, but it doesn't work either.

What is the problem?
How can I solve it?


Thanks in advance

View 1 Replies View Related

Dynamically Creating A Excel File In DTS

Feb 13, 2006

Hi
Some one Please guide me... How to create a Excel File Dynamically in DTS.

Once i run my DTS Package the result should be moved to a new Excel sheet( This should be created dynamically).

I tries in this way but it says....Syntax error at the DTS GlobalVariables.....

Function Main()

Dim appExcel
Dim newBook
Dim oSheet

dim oPackage
dim oConn

Set appExcel = CreateObject("Excel.Application")
Set newBook = appExcel.Workbooks.Add
Set oSheet = newBook.Worksheets(1)

oSheet.Range("A1").Value = "au_lname"
oSheet.Range("B1").Value = "au_fname"
oSheet.Range("C1").Value = "phone"
oSheet.Range("D1").Value = "address"
oSheet.Range("E1").Value = "city"


DTSGlobalVariables("fileName").Value = "C:\" & Month(Now) & "-" &
Day(Now) & "-" & Year(Now) & "-" & Hour(Time) & "-" &Minute(Time) & "-" &
Second(Time) & ".xls"

With newBook
.SaveAs DTSGlobalVariables("fileName").Value
.save
End With

appExcel.quit

set oPackage = DTSGlobalVariables.parent

set oConn = oPackage.connections(2)
oConn.datasource = DTSGlobalVariables("fileName").Value

set oPackage = nothing
set oConn = nothing

Main = DTSTaskExecResult_Success

End Function

View 2 Replies View Related

Dynamically Altering/creating Tables

Jul 22, 1998

Folks,
Is there any way I can dynamically alter the structure of a table? In other words if my Transact SQL
statement returns 5 rows I want to alter an existing table and put in 5 columns. Strange?!
Something like
alter table add
column+@i
The alter table statement is within a Cursor and ideally @i should increment each time and alter
the table to put in a new column.
If I went 3 times thru the loop, I should have
column1
column2
column3

added to the new table.

Any pointers would be greatly appreciated. Thanks much in advance.

View 1 Replies View Related

Dynamically Creating Report Width

Apr 5, 2007

Has anyone found out how to dynamically create report width.



If I have 20 columns on a report all of 2cm, then report will be 40cm width.



If I display the columns based on specific criteria using the iif function and then setting the an expression for the Visibility Hidden property, the report could potentially reduce in width.



I cannot see how to build an expression for the report width or table width, to accommodate the potential change in the width of the report when columns are not shown, thus it pages incorrectly, leaving huge white space on the right of the report when columns are hidden... has anyone come across this requirement, and hopefully a solution for it?



Many Thanks people



View 1 Replies View Related

Creating A Table Dynamically In SQL Server Express With Asp.net And Vb

Jun 11, 2006

Hi,
Is there a way to dynamically create a new table in sql server express using the code behind with vb on a Page_Load event?
Thanks Matt

View 2 Replies View Related

Dynamically Creating File Name With Todays Date

Jun 15, 2008

Hi

My SSIS package automatically creates Excel files everyday.
i want the excel files to get todays date when they are created .
Eg:06152008 for today and 06162008 for tomorrow
please help

View 3 Replies View Related

Dynamically Creating Temp Table Names

Jul 20, 2005

Hello,I am interested in dynamically creating temp tables using avariable in MS SQL Server 2000.For example:DECLARE @l_personsUID intselect @l_personsUID = 9842create table ##Test1table /*then the @l_personsUID */(resultset1 int)The key to the problem is that I want to use the variable@l_personsUID to name then temp table. The name of the temp tableshould be ##Test1table9842 not ##Test1table.Thanks for you help.Billy

View 5 Replies View Related

Dynamically Creating A New Excel Spreadsheet In SSIS

Feb 25, 2008

Hi everybody, i'm a newbie to SSIS and I'm having a problem dynamically creating a new excel spreadsheet in SSIS.
What I need to do is be able to dynamically create a brand new Excel spreadsheet after a data flow task completes.

Any help would be most appreciated. Thank you.

View 1 Replies View Related

Reporting Services :: Creating Cells Dynamically

Nov 2, 2015

i have a ssrs report in which i have creating rows with heading of months name from jan to dec i.e. jan|feb|mar|apr|....i have a parameter start date.i want when i enter start date from march supoose i enter date 03/22/2015 then display months from mar to dec.

View 5 Replies View Related

Any Progress On Creating Columns Dynamically On SQL 2005 Report?

Nov 6, 2007

thanks

View 4 Replies View Related

Dynamically Creating SSIS Package For Each Flat File

Apr 18, 2007

Trying to figure out the best method of reading in a number of flat files, all with different number of columns and data types and outputting them to a database.



Here's the problem: They are EBCDIC encoded and some of the columns are packed decimal. I've set up one package that takes the flat file, unpacks the decimal (Using UnpackDecimal component) and then sending the rest through a second component to go from EBCDIC -> ASCII.



What I need is a way to do this for every flat file based on the schema for that flat file. One current solution is to write a script/app to create the .dtsx XML file and then execute that for each flat file. It appears like this may be possible, but I haven't gotten far enough to know for sure. So my questions are this:



1) Is there an easier way to do this (ie somehow feed the schema to the package and use it to dynamically set up the column makers and determine which columns get fed to the unpack decimal component.



2) If there isn't a better way, will dynamically creating the .dtsx XML file based on the necessary input/output columns for each flat file work? If so, what is a good source of information on this (information about how the .dtsx XML file is set up, what needs to be changed/what doesn't, etc).



Thanks,

Travis

View 1 Replies View Related

Dynamically Creating New Worksheets To An Existing Excel Document

Aug 31, 2007

Hi All,

I have an exiting excel workbook say master.xls. Now I need to dynamically create and append a new worksheet to the above master.xls every month end using the Reporting services.

Could you please guide me how dynamically creating the worksheets task can be achieved using the reporting services?

Your any guidance or help in this matter will be highly appreciated.

Thanks in advance

Regards
Raman Kohli

View 3 Replies View Related

SQL Server 2012 :: Syntax Error While Creating Table Dynamically

Apr 19, 2015

I am getting error when I am trying to create table on runtime

Declare @FileName varchar(100)
Declare @File varchar(100)
set @FileName='brkrte_121227102828'
SET @File = SUBSTRING(@FileName,1,CHARINDEX('_',@FileName)-1)
--=select @File

[Code] ....

Error massage:-
Msg 203, Level 16, State 2, Line 16

The name 'CREATE TABLE DataStaging.dbo.Staging_brkrte ( [COL001] VARCHAR (4000) NOT NULL, [Id] Int Identity(1,1), [LoadDate] datetime default getdate() )' is not a valid identifier.

How to resolve above error....

View 4 Replies View Related

Dynamically Creating The Data Source Of A Report At Run Time Using Parameters

Feb 13, 2008



I have three databases which have the identical data structure. When the user runs a report, he has to select a database.
For example, my report query would look like:

Select * from <theDatabase>.dbo.MyTable

How could I assign the value of <theDatabase> at run time depending on what the user selects from the list?
In my datasource, I have only specified the server name and no value for initial catalog.

View 1 Replies View Related

Transact SQL :: Dynamically Creating And Running A Database Restore Command

Jun 17, 2015

If I run the following command in a Query window it works:

RESTORE DATABASE CIS_Source_Data_Test FROM DISK = 'y:CIS_Source_Data_backup_2015_06_17_085557_7782407.bak' WITH RECOVERY, REPLACE

If I dynamically put together the command and store it in variable @cmd and then execute it using
exec sp_executesql @cmd or exec (@cmd) it does not work. I get the following:

Msg 2745, Level 16, State 2, Procedure CIS_Source_Data_Refresh, Line 92
Process ID 62 has raised user error 50000, severity 20. SQL Server is terminating this process.
Msg 50000, Level 20, State 1, Procedure CIS_Source_Data_Refresh, Line 92
RESTORE DATABASE is terminating abnormally.
Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command.  The results, if any, should be discarded.

Why it won't work when I try to create and run it dynamically?

View 8 Replies View Related

Dynamically Creating Excel Worksheets Based On Groupings From Query In SSIS

Apr 24, 2008

Is there anyway to dynamically create Excel Worksheets based on a group identity results from a query?

Thanks!

SkySeek.

View 7 Replies View Related

Creating Table Fields Dynamically From Another Table Row

Aug 31, 2006

Hello all:

Is it possible to creates fields of the table dynamically?. I have this situation in my project. This is just a small sample. I have row of length 140. I don't wan't to declare all this fields manually using the create table command.

The description of table is as, in this table all the field are of type varchar only, there are like 140 columns.

create dummy emp (
field1 VARCHAR(100), field2 varchar(200), field3 VARCHAR(100).... )

Table: Dummy
================================================== ==
field1 field2 field3..........
Empid Empname empaage1 sam 23...........
2 rai 22............
.
.
.
n raj 45.............
================================================== ==
Now I want to create another table as "EMP" , with proper data type
fields too..

create table emp (
empid int, empname varchar(100), empage int....)

The table should look like as:

Table: EMP
================================================== ==
Empid Empname empaage............
1 sam 23...............
2 rai 22................
.
.
.
n raj 45.................
================================================== ==

I want to do this dynamically.....
Some how I need to extract those field from table[dummy]; the first row acts as a column header for the table[Emp] and the subsequent row acts as a record for the table[Emp]

A small rough snippet of the code will be appreciated....

Waiting for replies........
saby

View 1 Replies View Related

Features Of Sql

Jan 10, 2008

hi,

how i know the extra features added in the sql2005 than sql 2000

View 2 Replies View Related

SQL 2000 Features

Mar 8, 2000

Does SQL 2000 support nested tables? Also, how many columns does it support?

View 3 Replies View Related

Discontinued Features ???

Sep 14, 1998

Are there any features in 6.5 that have been discontinued in 7.0? I read in Technet that "future versions of SQL Server might not support some statements where the same functionality can be achieved using other means." Technet gave the following examples:

- Device Mirroring
- Outer Join Syntax
- SELECT FOR BROWSE
- Handling of NULLs

I`m curious how our applications will be effected. Will we be making a lot of code changes when we migrate to 7.0?

Thanks, Dave Holtz
First Penn-Pacific

View 3 Replies View Related

New Features And Comparison.

Aug 13, 2004

Morning!
Folks, i want some links where i could find healthy stuff regarding New Features and Compliance levels, performance comparisons, TPC tests etc about SQL 2000 and Yukon specially.
I've to submit a document regarding Top database features that shall be used for a Medical-Billing Software in plan.

Howdy!

View 2 Replies View Related

Does SSIS Have These Features????

Feb 20, 2006

1> Support for rules based and change-data-capture extracts

2> Push and Pull methods supported

3> Convert between ASCII and EBCDIC

4> Ability to extract from packages like SAP and Peoplesoft natively

5> Extract from multiple sources simultaneously

6> Support for native database features like database bulk loaders

View 7 Replies View Related

SQL Server Security Features

Jul 2, 2003

Hi,

Can any one give me the details of the Security level or measure which are supported my MS Sql Server.
How much it is security while we are accessing any database over the internet and what are the Security measure we have to take and level did Software provides.
It is URGENT

Thanks

View 2 Replies View Related

Advanced Features For DTSs?

Apr 17, 2006

Hi,

Since I am new to DTSs therefore currently I am making my DTSs in a manner where there probably is a room for improvement e.g. When I have to Import data from one server to another I use the Import feature and then I go through all the steps of the wizard (at the end of which I get the option to save my DTS)....

In the DTS "design window" there are many options under the TASK menu option and is there a url from where I can learn how to use these options (under TASK i.e. File Transfer Protocaol task, ActiveX Script Task, Transform Data Task, etc. etc.).

Maybe if I know how to use these options, I might be able to write my DTS in better and flexible manner...

Hope my posts is making some sense????

Thanks

View 1 Replies View Related

Advanced Features For DTSs?

Apr 17, 2006

Hi,

Since I am new to DTSs therefore currently I am making my DTSs in a manner where there probably is a room for improvement e.g. When I have to Import data from one server to another I use the Import feature and then I go through all the steps of the wizard (at the end of which I get the option to save my DTS)....

In the DTS "design window" there are many options under the TASK menu option and is there a url from where I can learn how to use these options (under TASK i.e. File Transfer Protocaol task, ActiveX Script Task, Transform Data Task, etc. etc.).

Maybe if I know how to use these options, I might be able to write my DTS in better and flexible manner...

Hope my posts is making some sense????

Thanks

View 1 Replies View Related

Sql Server 2000 New Features ?

Jan 28, 2004

Please help ,

What are the major differences between SQL SERver 7 and 2000 ?
Looking for a job and found a position where the client prefers the database developer specifically expericenced in SQL 2000.
What is really so hot and important to know?

THanks a lot .

View 6 Replies View Related

Transact-SQL Common Features?????

Jan 12, 2007

Hi



The white paper which compares SQL Express and SQL Compact says that they both share Common Features

Can someone please indicate if SQL Compact will support functions like

Average, STDEv etc

Thanks

Touraj

View 7 Replies View Related

Using SSIS Security Features

Apr 22, 2007

I have simple package and trying to use the security feature of ssis. I set the protection level as "EncryptSensitiveWithPassword" and also specify the password. But it doesn't prompts me for the password. Can anybody help me in that?

View 1 Replies View Related

How To Use Web Services And Interactive Features

Dec 26, 2006

I've been having trouble getting my RS2005 reports with interactive features (drilldowns) to work in an Iframe and rendered with SOAP.

The main problem now is that the toggle buttons (+ / -) point to the reporting services server and do a URL Access call. I've tried the <ReplacementRoot> element in the DeviceInfo parameter but it doesn't appear to do anything.

I keep on reading about how everything is possible through the web services but it looks as if these interactive features are only available using the URL Access. Is this true?

Kwan

View 3 Replies View Related







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