Reference Material
Feb 23, 2004does any one know any good pages to get some sql commands
and explainations thanks
ADVERTISEMENT
Any Recommendations On Reference Material
Nov 27, 2007
I am in the process of creating a user interface that will give the users a list of reports to choose from. I wanted to write an interface in ASP .NET with C# to pull information for different reports from the reporting services web service. I have successfully done this with C# Windows Form. The project requires it to be web-based.
Problem is, I am new to web forms and would like a recommendation for reference materials to help me program ASP .NET with C# and using the web service. I am still learning ASP .NET and C#, so I would like something fairly basic.
Any help is appreciated.
Need Some Reading Material.
Jun 27, 2006Hi
I was searching some books about SQL but all that i found was "Big books", i mean, i found books about all SQL Server and i just need to know a few things.
I'll need to make queries to a DB and make excel or acces reports based on the query result.
Well, thanks in advance
SSIS Learning Material.
Mar 21, 2008Hi,
I am new to SSIS.
1) I want to create a SSIS package to execute 5 stored procedures one by one. Stored procedures has parameters.
2) I want to create a SSIS package for ETL. To extract data from different tables from a database and insert into a new table in the same database on a monthly basis. How do i do these two?
Is there a good material i can go through to achieve these tasks?
Thanks in advance
Creation Of Material Views.
Feb 13, 2008Hi,
I would like to create views in TOAD 9.1 Application.
Could any one help me how to write Sql.
Below are the tables which i have created.
1) DIM_RANK_GRP:
CREATE TABLE DIM_RANK_GRP
(RANK_GRP_ID NUMBER NOT NULL,
RANK_GRP VARCHAR (20),
PARENT_RANK_GRP VARCHAR (20)
HIERARCHY_TYPE VARCHAR (20)
);
ALTER TABLE DIM_RANK_GRP
ADD PRIMARY KEY (RANK_GRP_ID)
2) DIM_PROFITABILITY:
CREATE TABLE DIM_PROFITABILITY
(
PROFIT_ID NUMBER NOT NULL,
PROFIT_VAL NUMBER,
PROFIT_DESC VARCHAR (30)
);
ALTER TABLE DIM_PROFITABILITY
ADD PRIMARY_KEY (PROFIT_ID)
3) Fact Table: Agg_Rx_Weekly_Sales:
CREATE TABLE AGG_RX_WKLY_SLS
(TERR_ID Number,PFZ_PROD_ID Number ,DT_SK Date,CHNL_ID Number,SPEC_ID Number,RANK_GRP_ID Number,PRFTY_ID Number,Nrx Float(64),Trx Float(64),
Nrx_unit Float(64),Trx_unit Float(64),Nrx_Dol Float(64),Trx_Dol Float(64),Mkt_Nrx_Unit Float(64),Mkt_Trx_Unit Float(64),Mkt_Nrx_Dol Float(64),Mkt_Trx_Dol Float(64),Mkt_Nrx Float(64),Mkt_Trx Float(64)
);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_TERR
FOREIGN KEY (“TERR_ID�)
REFERENCES “DIM_TERR� (“TERR_ID�);
ALTER TABLE�AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PERD
FOREIGN KEY (“DT_SK�)
REFERENCES “DIM_PERD� (“DT_SK�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_SPEC
FOREIGN KEY (“SPEC_ID�)
REFERENCES “DIM_SPEC� (“SPEC_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_CHNL
FOREIGN KEY (“CHNL_ID�)
REFERENCES “DIM_CHNL� (“CHNL_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_REL_PROD_MKT
FOREIGN KEY (“PFZ_PROD_ID�)
REFERENCES “REL_PROD_MKT� (PFZ_PROD_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_RANK_GRP
FOREIGN KEY (“RANK_GRP_ID�)
REFERENCES “DIM_RANK_GRP�(RANK_GRP_ID�);
ALTER TABLE “AGG_RX_WKLY_SLS�
ADD CONSTRAINT FK_DIM_PRFTY
FOREIGN KEY (“PRFTY_ID�)
REFERENCES “DIM_PRFTY� (PRFTY_ID�)
Advanced Thanks.
VENKAT
Need Advice On Reading Material
Sep 9, 2006Hello,I'm new to SQL Server, have alot of experience with DB2 and Oracle,and have beentasked with supporting SQL Server. Could anyone suggest a goodadministrator book?Thanks!!Dave Schaeffer
View 1 Replies View RelatedSQL 2012 :: DTSX Giving Errors - Object Reference Not Set To Instance Reference
Sep 10, 2014I am using vs 2010 to write my dtsx import scripts.I use a script component as a source to create a flat file destination file.Everything have been working fine,but then my development machine crashed and we have to install everything again.Now when i use the execute package utility to test my scripts i get the following error:
Error system.NullReferenceException: Object refrence not set to an instance reference.
In PreExecute section
TextReader = new system.io.streamreader(" file name")
In the CreateNewOutputRows:
dim nextLine as string
nextLine = textReader.ReadLine
[code]...
is there something which i did not install or what can be the error?
Self Training Software?? Study Material?
Aug 30, 1999Has anyone used any CBT's for SQL7 or could recommend a good company for study materials. I have seen the product from CBT systems and Keystone and was not impressed.
View 2 Replies View RelatedNeed Material For Sybase To Sql Server Migration
Dec 6, 2005Greetings,Can someone recommend me some online redbooks or anylink regarding "Migration from Sybase to Sql Server"?Any feedback will be appreciatedTIA
View 2 Replies View RelatedFind SQL Server 2005 Teaching Material
Apr 11, 2006Who has SQL Server 2005 teaching material? Anyting is ok. thanks. :)
View 2 Replies View RelatedUsing Hierarchy ID Data Type In Material Database
Nov 10, 2014How to use hierarchy id data type in Bill of material database.
The msdn example [URL] ....
Exchange MCDBA/MCSD Self Test Software And Material With OCP And MCSE STS
Jan 4, 2002Dear Sir/Madam
I am certified Oracle DBA/Developer/Internet Developer. Now, I am interested in Microsoft Certificated DBA (MCDBA/MCSD).
By the way, I don't want to waste money to purchase the Microsoft exam software (Self Test Software) and training material. So, I want to exchange the MCDBA exam software and training material with you by using Oracle OCP 8i, Developer 2000 Rel 2.0 and MCSE 2000 Self Test Software.
I can use Oracle 8iDBA, Oracle Developer and MCSE 2000 self test software listed below to exchange 70-228,70-229,70-215,70-216,70-175 or other MCDBA 2000 and MCSE 2000 self test software and training materials.
<Oracle 8i DBA>
1Z0-001 Introduction to Oracle: SQL and PL/SQL
1Z0-023 Oracle8i: Architecture and Administration
1Z0-024 Oracle8i: Performance Tuning
1Z0-025 Oracle8i: Backup and Recovery
1Z0-026 Oracle8i: Network Administration
<Oracle Developer>
1Z0-101 Develop PL/SQL Program Units
1Z0-121 Developer/2000: Build Forms I
1Z0-122 Developer/2000: Build Forms II
1Z0-123 Developer/2000: Build Reports
<MCSE 2000>
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-219 Designing a Windows 2000 Directory Services Infrastructure - (Includes 4 Case Studies)
By the way, if you have any one of 70-228,70-229,70-175,70-176,70-100, I can use whole set of Self test software to exchange yours.
Please provide email accounts with at least 5MB space for exchanging Self Test Software.
Thanks and Regards,
Jack
OCP DBA/Developer/Internet Developer
jacklam@tom.com
Business Problem: Range Of Coverage Of Material Stocks / Need Help With Design
Mar 24, 2008I'd like to display the our range of coverage of material stocks via SSRS. The underlying database provides all the actual stocks of our materials as well as the current and planned consumption. Now, my problems are the design, as I am not sure If I can realise it with SSRS, and the way of displaying the actual range of coverage as I have no future time informations.
Has anybody made experiences with reports like that?
Transact SQL :: Query That Returns Material (items) That Are Used In Event On Certain Day - RIGHT JOIN
Nov 29, 2015I have a query that returns material(items) that are used in an event on a certain day.
SELECT C.categoryName, count(I.itemID) AS InMission
from items as I
RIGHT JOIN Categories AS C on I.categoryID = C.categoryID
INNER JOIN LinkMissionItem as LM on I.itemID = LM.itemID
INNER JOIN Missions as M on LM.missionID = M.MissionID
where '2015/12/19' BETWEEN M.freightLeave and M.freightReturn AND isReturned = 0
GROUP BY C.categoryName, C.categoryID
ORDER BY C.categoryID
There are a total of 20 categories and I would like all the categories listed in the result even though there are no items booked in a mission. At the moment, I can only get the categories that have items in that category booked in a mission. I hoped that the RIGHT JOIN on the categories table would do the trick but it doesn't.
Transact SQL :: Return Preset Data Values Based On User Material ID
Jul 22, 2015I have 2 tables each containing a material type. Table 1 contains material from their 3D application. Table 2 contains material with specific values that is not ours and we cannot rename or edit the data. I need a type of junction or mapping table that can connect the user material to the preset material. for example:
User Material = Wood-MDF
Preset Material = MDF Panel
I figured that i would make this table with 3 fields (ID, UserMaterialID, PresetMaterialID).How would i then construct a query view / Stored procedure that would return the Preset data values based on the user material id?
T-SQL Reference?
Feb 6, 2004Hi y'all
Does anybody know reference or pdf file or free e-learning on the web?
Reference
Jun 18, 2001DECLARE Loan_cursor CURSOR FOR
SELECT Loan_No,store
FROM loan
WHERE maturity_date > '2001-04-30' and loan_no like 'ABL%'
OPEN Loan_cursor
-- Perform the first fetch.
FETCH NEXT FROM Loan_cursor
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
Declare @LoanNo varchar(12)
** Set @LoanNo = Loan_No
-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM Loan_cursor
END
CLOSE Loan_cursor
DEALLOCATE Loan_cursor
when l run the cursor l get the error
Server: Msg 207, Level 16, State 3, Line 15
Invalid column name 'Loan_No'.
.
If l reference it as Set @LoanNo = LoanTable.Loan_No l get the error
Server: Msg 107, Level 16, State 3, Line 15
The column prefix 'loan' does not match with a table name or alias name used in the query.
All l'm trying to do is to compare the loan number that l get from the cursor to the value in the loans table. Maybe reference is a better word
Old Sp Reference
Jun 6, 2008Hi friends,
Just i modified one sub stored procedures which is not getting affected in the main stored procedures
Create procedure main
as
begin
set nocount on
--First sp
exec Data_transfer_sp
--Second sp
Exec Clearance_sp
set nocount off
end
In data_transfer_sp,i have commented the select statement
but still iam use to the select result while execution the main sp.
Note:I have compiled the data_transfer_sp after making comment
.Txs in advance
Reference CTE More Than Once In A SP
Sep 11, 2007
Hi All ...
WITH myCTE (x,y,z) AS (SELECT x,y,z, from myTable)
SELECT x,y,sum(z) from myCTE
SELECT y,z,sum(x) from myCTE
the second SELECT fails, and says invalid object name. does the CTE go out of scope after i reference it once?
never mind the semantics of what I am SELECTing, I just want to be able to reference the CTE more than once in my SP
am I trying to use the CTE in a way that was not intended?
Reference CTE More Than Once In A SP
Sep 11, 2007
Hi All ...
WITH myCTE (x,y,z) AS (SELECT x,y,z, from myTable)
SELECT x,y,sum(z) from myCTE
SELECT y,z,sum(x) from myCTE
the second SELECT fails, and says invalid object name. does the CTE go out of scope after i reference it once?
never mind the semantics of what I am SELECTing, I just want to be able to reference the CTW more than once in my SP
am I trying to use the CTE in a way that was not intended?
How To Get Reference Of .net Dll
Oct 15, 2007hi ,
can any body help me that how can i use my .net dll into my rdl file.
thanks
Gorla
The Reference
Feb 3, 2008in this code ,whtat is the references of
RelationalDataSourceView
and also
what are the references of these?
OleDbConnection
OleDbCommand
OleDbDataAdapter
Object Reference Not Set
Nov 16, 2006Can anyone see why I would get the 'Object Referenece not set to an instance of an object error in the following code?
It happens on this line:
MyAdapter.SelectCommand = New SqlCommand(SelectStatement, MyConnection) 'Populate the text boxes from database for alumni fields.
Dim MyAdapter As SqlDataAdapter
Dim MyCommandBuilder As SqlCommandBuilder
Dim DetailsDS As DataSet
Dim Row As DataRow
Dim SelectStatement As String = "Select ClientID,ClassYear,HouseName,CampusName,EducationMajor,GraduationDate FROM tblclient Where [ClientID]=" & _
ClientIDSent
Dim ConnectStr As String = _
ConfigurationManager.ConnectionStrings("TestConnectionString").ConnectionString
Dim MyConnection As SqlConnection = New SqlConnection(ConnectStr)
MyAdapter.SelectCommand = New SqlCommand(SelectStatement, MyConnection)
MyCommandBuilder = New SqlCommandBuilder(MyAdapter)
MyAdapter.Fill(DetailsDS, "tblClient")
Row = DetailsDS.Tables("tblClient").Rows(0)
ClassYearText.Text = Row.Item("Classyear").ToString()
HouseNameText.Text = Row.Item("HouseName").ToString()
CampusNameText.Text = Row.Item("CampusName").ToString()
EducationMajorText.Text = Row.Item("EducationMajor").ToString()
GraduationDateText.Text = Row.Item("GraduationDate").ToString()
SQL Reference Online?
Jan 21, 2004Hi,
I'm looking for a good reference guide online as I am more used to mysql (and stil quite limited vocab at that)
I create table outside of a database by accident and I'm now looking for the sql syntaxt for moving tables, but I can't find it anywhere?
most simple guides don't seem to provide the syntax to do this. :(
Why Must My SQL Object Reference With The DBO Name.
Sep 20, 2000Hi,
I am access SQL 7 via ADO in some ASP pages. My database objects were created under a user name aliased to the dbo. As a result, when I have my client logon to make a connection, I have to preface all my object references with the name of the owner, i.e., Select * from mydboname.people . Is there a way to avoid having to prefix all my transact sql statements with the owner?
thanks,
steve
Un Reference Tables
Sep 1, 2004I have two tables that are reference to each other by foreign key, now I would like to alter the table so the it doesn't reference each other any more. What is the syntax to alter a table so that the fk field doesn't reference a table anymore. Thanks in advance for the help.
View 1 Replies View RelatedMDX Reference Book
Feb 17, 2004What would you recommend for a good MDX book ?
specifically, for syntax, data structures and sample code.
thx
C
Reference Materials
Jun 21, 2008As I posted earlier, I am relatively new to TSQL. I have been given a few books:
O'Reilly SQL on SQL Server 2005
O'Reilly SQL in a Nutshell
Mastering SQL Server 2005 - Sybex
Beginning SQL Server 2005 Programming - Wrox
I have a copy of SQL2005 Developers Edition on a development server. So I think I have some decent tools at my disposal.
I was wondering if there are any other sites or forums that might be suggested for learning SQL programming? Right now, I am just making stuff up and following examples in books, etc. I would like to find a site where there are beginner level projects for no other purpose than educational. Something where I can get more hands on of the design and programming aspects. Just to practice.
Thanks,
grinch
Reference Error
Jun 14, 2006i have this code,
CREATE TABLE s
(sno VARCHAR(5) NOT NULL PRIMARY KEY,
name VARCHAR(16),
city VARCHAR(16)
)
CREATE TABLE p
(pno VARCHAR(5) NOT NULL PRIMARY KEY,
descr VARCHAR(16),
color VARCHAR(8)
)
CREATE TABLE sp
(sno VARCHAR(5) NOT NULL REFERENCES s,
pno VARCHAR(5) NOT NULL REFERENCES p,
qty INT CHECK (qty>=0),
PRIMARY KEY (sno, pno)
)
when i run this query i get an error saying:
Column 's.sno' is not the same length as referencing column 'sp.sno' in foreign key 'FK__sp__sno__5EBF139D'. Columns participating in a foreign key relationship must be defined with the same length.
can anyone assist me what to be done?
Self Reference Tables
Jul 14, 2006Hi ,
I have the following structure:
Item table
----------
ItemId
ItemName
Item Transaction Table
----------------------
TransactionId
GiverItemId
SenderItemId
the data is somewhat like this:
Item table
__________
1abc
2xyz
3pnr
4rew
5dds
6djs
7dsf
Item Transaction table
---------------------
112
224
343
437
Now i have a reauirement to build a stored proc in which all the transactions starting from one transaction like, if i want to know the chain for item no 2 it shall give the following result:
24
43
37
if i want to know the chain for item no 3 then it shall give following
37
if i want to know the chain for item no 1 then it shall give following
12
24
43
37
Please help.. Its urgent.....
Thanks
What Is The Best XML Reference / Book??
Mar 27, 2008I am teaching myself XML and was wondering if anyone knows
any good books to gently breaking me into XML.
Kind Regards
Rob
Reference SQL Parser
Jul 20, 2005I need to parse SQL statements directly and extract each segmentindividually. Is there a way reference the Microsoft SQL Parserdirectly from VB.Net?Thanks!*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 6 Replies View RelatedSample's Reference
Sep 26, 2007
Forgive me for my programming ignorance, but how to i find the microsoft.sqlserverce.samples.accesssync.editdata reference?
Thanks