Case Sensitivity...Sellect * From Table1 Or Table1... Which One?

Feb 1, 2008

Hi everybody
I'm a newbie to SQL-Server 2005 so please excuse me for my silly questions
Recently i wrote a simple web-Page in which i select data from a table and then bind them to a GridView on the form
every thing was simple as follows:

        SqlConnection Con = new SqlConnection("Data Source=.;Initial Catalog=Test;Integrated Security=True");
        Con.Open();

        SqlDataAdapter da = new SqlDataAdapter("SELECT [ID], [Name], [Date] FROM [Table1] ORDER BY [Date]", Con);
        DataSet ds = new DataSet();
        da.Fill(ds,"MyTable");

        GridView1.DataSource = ds.Tables["MyTable"];
        GridView1.DataBind();

But I have a question , when i change the [Table1] to [table1] (With lowercase T) , i receive the following error
message:

 Invalid object name 'table1'.

why is that? could anyone help me? even i tried to test this issue in [Microsoft Management Studio] and i got the
same result . realy what's the reason? before and with sql server 2000 i didn't have these issue.

Thanks in advance.
Regards.

 

View 5 Replies


ADVERTISEMENT

Table1(col1) Clustred , Table1(col1,col2,col3) Nonclustered Index , Which One To Keep ?

Jun 27, 2007

For a table 'table1' in sqlserver 2000,

table1(col1) is clustred index 'Ix1' and table1(col1,col2,col3) is nonclustered index 'ix2'



is not tabel1(col1) 'ix1' a duplicate/redundant index ?



which index should be retained ?



or should both indexes remain on the OLTP table ?





Thanks a lot in advance.



View 1 Replies View Related

Case Sensitivity When A User Enters Data Into The Database. How To Deal With Case Sensitivity.

Sep 6, 2007

I am working on a C#/asp.net web application. The application has a text box that allows a user to enter a name. The name is then saved to the database.
Before the name is saved to the database, I need to be able to check if the name already exists in the database. The problem  here is that what if the name is in the database as "JoE ScMedLap" and somoene enters the name as "Joe Schmedlap" which already exists in the database,but just differs in case.
In other words how do deal with case sensitiviy issues.

View 2 Replies View Related

Neither In Table1 Nor In Table2

May 5, 2008

Hi,

How do you express neither no in TSQL. I am trying to create a view that gathers work orders that are neither in one table nor in another
I tried the following few appraoches but feel there must be something better. thanks!

1.
Select *
FROM xyz
WHERE Status = Open
AND (Number
NOT IN (SELECT WONumber
FROM dbo.Table1)
OR Number
NOT IN (SELECT WONumber
FROM dbo.Table2))
2.
Select *
FROM xyz
WHERE Status = Open
AND Number
NOT IN (SELECT WONumber
FROM dbo.Table1)
UNION
Select *
FROM xyz
WHERE Status = Open
AND Number
NOT IN (SELECT WONumber
FROM dbo.Table2)

View 1 Replies View Related

SELECT * FROM TABLE1 WHERE NOT IN TABLE2

May 20, 2005

Is there anyway or a sql statement that can do something like, Select * from table1 where table1 not in table2.which means i get all the rows in table1, as long as they r not in table2

View 2 Replies View Related

Getting Results From Table1 That Are Not In Table2

Sep 23, 2005

Hi,
I have a problem I have two tables, table1 my main table and table2 my secondary table.
Table1 has lots of records with a field for a unique transaction number, table2 also has a field for a transaction number.
Table 2 only has a 10 entries in with the same transaction number of
10 of the entries in table1.
My question is how do I get all the records from table1 that DONT have a corrisponding transaction number in table2.

Thanks
Paul

View 2 Replies View Related

How To Update Table1 From Table2

Nov 22, 2007

Hi

I have table1 with tow columns ( col1 and col2)
table2 colums (col1 and col2)

Table1 -- col1--- col2
-----------A ---- dfg
-----------B ---- ght

Table2-- Col1--- col2
-----------A ----- jjk
-----------B ----- lkl


How do I update col2 of Table1 with the data from col2 of Table2 in a Single Query

View 3 Replies View Related

UPDATE Column In Table1 From 2 Columns...

Jan 22, 2007

Hey ya'll...
I need to create a query that I can run that will allow me to essentially take the first initial and last name and combine them from two columns in one table and update one column with that new data in another table. Example of need:
UPDATE tblLogin.UserName with (first character(tblEmployee.FName)+(tblEmployee.LName)) WHERE tblLogin.EmployeeID = tblEmployee.EmployeeID.
That was TOTALLY pseudo code and I know I'll need a join statement in there somewhere. Both tables reside on the same database, such as this:
dbEMPLOYEE (Database)--> tblLogin (Table)----> UserName (Column)--> tblEmployee (Table)----> FName (Column)----> LName (Column)
Any help would be GREATLY appreciated! Hopefully something soon - this was handed to me a few minutes ago and I have a few minutes to get it done.iSheahan

View 5 Replies View Related

Copy Data From Table1 To Table2

Mar 9, 2004

i have tow table same structure
how i can copy the data in table1 to table2
in T-SQL statment


thanx

View 1 Replies View Related

Insert Data From Table1 To Table2

Oct 1, 2004

Hi,

I'm using MSSQL and I have 2 tables with same structure. Can any one tell me the easiest way on how to select a row from table1 and insert it into table2.


Many thanks.

View 1 Replies View Related

Filter On Table 2 And Get All Records Of Table1

Jan 13, 2006

Dear all,
My question about SQL statement:
Table1 - Fields: T1PK, T1Field
Records:
1, ABC
2, DEF
3, GHI
 
Table2 - Fields: T2PK, FK (join T1PK), T2Field
Records:
101, 1, XXX
102, 1, YYY
103, 1, XXX
104, 2, XXX
 
I want to write a SQL statement that join Table1 and Table2 together, T2Field equal to XXX, and list all records from Table1.
That's the result columns: T1PK, T1Field, T2PK, T2Field
Result records:
1, ABC, 101, XXX
1, ABC, 103, XXX
2, DEF, 104, XXX
3, GHI, NULL, NULL
 
Is it possible? Please help!!
Joey

View 2 Replies View Related

Match Two Columns Of Table1 With Table2?

Feb 1, 2014

I have two tables with similar two columns as shown below

table1
code | organisation
256 | abc
832 | xyz
893 | tax
921 | abc
951 | abc

table2
code | organisation
951 | abc
832 | xyz
256 | abc
893 | tax
921 | tax

Now, I want to check whether all the codes in table1 existing in table2 and list them, and if both columns from table1 is matching with the both columns in table2. For e.g. 256|abc in table1 is matching with 256|abc in table2

The output should be :

921 | tax

For e.g. 256abc is there or not in table2,

View 5 Replies View Related

Transferring Only New Records From Table1 To Table2

Jun 26, 2014

I have a table table1

ID Date In Out

22 01/01/201410:00 11:00
22 02/01/201410:00 11:00
22 03/01/201410:00 11:00
23 01/01/201410:00 11:00
23 02/01/201410:00 11:00
23 03/01/201410:00 11:00
24 01/01/201410:00 11:00
24 02/01/201410:00 11:00
24 03/01/201410:00 11:00
25 01/01/201410:00 11:00
25 02/01/201410:00 11:00
25 03/01/201410:00 11:00

Table 2

ID Date In Out

22 01/01/201410:00 11:00
22 02/01/201410:00 11:00
22 03/01/201410:00 11:00
23 01/01/201410:00 11:00
23 02/01/201410:00 11:00
23 03/01/201410:00 11:00
24 01/01/201410:00 11:00
24 02/01/201410:00 11:00
24 03/01/201410:00 11:00

I want to insert only those record from table 1 to table 2 which is not there in table 2

View 3 Replies View Related

How To Join Last Record Of Table1 With Table2

Oct 17, 2014

HOW TO SELECT LAST ROW IN GROUP BY CLAUSE AND JOIN LAST ROW WITH ANOTHER TABLE IN ONE QUERY?

INPUT:
custidlivingstatusdate
1single2014-01-01 00:00:00.000
1married2014-01-02 00:00:00.000
1married_kids2014-01-03 00:00:00.000
2married_kids2014-01-04 00:00:00.000
2married2014-01-05 00:00:00.000
2single2014-01-06 00:00:00.000

Query 1 -- select last record
SELECT *
FROM
(SELECT ROW_NUMBER() OVER(PARTITION BY Custid ORDER BY Date DESC) AS Seq,*
FROM Living_Situation
)t
WHERE Seq=1

Output:
Seqcustidlivingstatusdate
11married_kids2014-01-03 00:00:00.000
12single2014-01-06 00:00:00.000

Table Customer:

custidsexesurname
1mjansen
2mpietersen

How to link Query 1 with table Customer in one query?:

Desired output in ONE query:

custidsexesurnamelivingstatus
1mjansen married_kids
2mpietersen single

View 3 Replies View Related

How To Read The Value Of Textbox In Table1 Of Subreport

Feb 2, 2007

I have a report which has subreport in it. the textbox5 has a countrows() function hooked and i want to

=sum(Subreport1.table1.textbox5.value), is it possible.

subreport control is pointing to childreport.rdl
childreport.rdl has - Table1 and textbox5

Thank you very much for the info.

View 1 Replies View Related

Can Table1 In Example Below Get Updated By Another Process While The Transaction Is In Progress?

Feb 15, 2006

I am afraid that just after @statusOfEmployee is retrieved from table1, but before table2 is updated, someone else (a second user) calls this same stored procedure and changes the @statusOfEmployee value. This would create an inconsistent update of table2 by first user, since the update of table2 'might' not have gone ahead if the latest value of @statusOF Employee was used. CAN SOMEONE PLEASE HELP ME WITH THIS SITUATION AND HOW I CAN BE SURE THAT ABOVE DOES NOT HAPPEN SINCE MULTIPLE USERS WILL BE HITTING THIS STORED PROCEDURE?
 
declare @status intbegin transet @status = (select statusOfEmployee from table1)if @@ERROR = 0   begin    update table2        set destination = @destination /* @destination is an input parameter passed to the sp*/        where @currentStatus = @status   if @ERROR = 0      commit tran   else      rollback tran   endelse     rollback tran
return

View 7 Replies View Related

Sum Up Values In Table2 Where IDs Are Equal To Table1 And Then Update Value

Dec 17, 2013

I'm trying to update a value into a table a sum. The two tables have ID values. These ID values appear once in Table1 and multiple times in Table2. I'm currently trying to sum up the values in Table2 where the IDs are equal to Table1 and then update the value:

UPDATE [Table1] SET
[Total] =
(SELECT SUM([Table2].[QTY]) FROM [Table2],
[Table1] WHERE [Table1].[ID] = [Table2].[ID]
GROUP BY [Table1].[ID])
FROM [Table1], [Table2] WHERE [Table1].[ID] = [Table2].[ID]

View 2 Replies View Related

Insert Records From Table1 That Do No Exist In Table2

Jul 23, 2005

Hi guys,i have a little problem here.im attempting to write a stored procedure that compares two tables ofthe same data structure and adds (inserts) extra records that exist intable1 to table2.My problem is that i dont have a unique identifier between the tables.i think someone said that i needed to build up a keyany ideas greatly appreciated ??C

View 1 Replies View Related

Compare Record Count In Table1 To Qty In Table2?

Oct 10, 2006

We have an inventory table (Items) that contains item_no and qty_on_handfields.Another table (Item_Serial) contains serial numbers for any item that hasserial numbers.If an item has 10 qty_on_hand, it should have 10 records in Item_Serial, oneunique serial number for each item.I am trying to find items where the number of serial numbers does not equalthe qty_on_hand.Here is a query I'm trying to use and, of course, it does not work:select Items.item_no, Items.qty_on_handfrom Items inner join Item_Serial on Item_Serial.item_no = Items.item_nowhere Items.qty_on_hand <count(Item_Serial.item_no)Anybody know how to do this?Thanks.

View 4 Replies View Related

MS SQL Copy New And Modified Rows From TABLE1 To TABLE2

Aug 16, 2007

Hello,I have 2 tables, Table1 and Table2. I have copied all data from Table1to Table2.However Table1 is dynamic it has new rows added and some old rowsmodified everyday or every other day...How can I continue to keep Table2 up to date without always having tocopy everything from Table1?Basically from now on I would only like to copy new rows or modifiedrows in Table1 to Table2 and skip rows that are already present andhave not been modified in Table1. I would like to not do anything forany rows that were removed in Table1 and continue to keep a copy ofthem in Table2.Is using a DTS package the best way to automate this update of Table2to make sure Table2 is always up-to-date with Table1?Thanks for any help or advise :-)Yas

View 14 Replies View Related

JOIN ON CONTAINS(Table1.Field1, Table2.Field2)

Jul 20, 2005

Hi,I am getting errors in the following... Is it even possible to join onCONTAINS?SELECT ListA.ContentFROM ListA LEFT OUTER JOIN ListBON CONTAINS(ListB.Content, ListA.Content)WHERE ListB.Content IS NULLThanks!

View 4 Replies View Related

Item Not Linked To Dataset, And Table1 Issue

Sep 20, 2006

Hi--

I have a report project in VS (2003). I have a report in that project that was working properly. I copied objects from that report to a new one and created a new dataset for the new report (under it's Data tab). Though both datasets (for each of the reports) seem healthy, i.e., they produce data when run, I am now experiencing the following problems:

1. In both reports, the datasets seem to be unlinked, somehow. I know this by right clicking on a field of the report, going to expressions, then selecting the Fields node. Instead of listing fields, as used to be the case, it now says "Report item not linked to a dataset."


2. If I attempt to preview either of the reports, I get an error that reads, "The table 'table1' refers to an invalid dataset name 'MedMgmt.' MedMgmt is the dataset name of the first report. I changed it to another name, but I still get the same message.

I have clicked and right-clicked everywhere and have not found a way to re-link the dataset to the report. Why Reporting Services can't figure out that the dataset in the report's Data tab is the dataset to link to is a point of deep annoyance, but whatever... If anyone can please help me solve these problems, I would be very grateful! Thank you!

View 5 Replies View Related

Delete From Table1 Data That Appears In Table2

Mar 21, 2008

Hi,

I have 2 tables. Table1 and Table2.
In Table1 i have 10 rows of data and in Table 2 i have 1 row of data (which also appears in Table1).

How do i delete from Table1 the data that appears in Table2 (without using an ID key)?



Example:
I want it to be like when i use "insert into".

Insert into Table1
select * from Table2


I want it to be something like that:

Delete from Table1
select * from Table2


View 11 Replies View Related

Is It Possible To Move Rows From Table1 In Database1 To Table2 In Database2?

Aug 29, 2000

Is it possible to move rows from Table1 in Database1 to Table2 in Database2?

Say, I have Database1 containg Table1:

ID ¦ Cars
---------------
1 BMW
2 Mercedes
3 Toyota
1 Opel
etc....

And Database2 containg Table2 (that is empty just at the moment):
ID ¦ Cars
---------------
no data added yet...

How can I copy say everything from Table1 that has ID=1 (the parameter I send in with the stored procedure at execution), and insert this in Table 2?
This would be, I insert the row with the BMW thingy and the row with the Opel thingy as 2 new rows in table 2.
Note that the two tables are located in 2 different databases.

I am using SQL Server 7 and am trying to implement this in a stored procedure.

Thanks for all help!!

Mark Nelson

View 1 Replies View Related

Export Data From One Catalog1 Table1 To Catalog2 Table2

Jul 9, 2013

I have two user tables, one is in a catalog1 another is in catalog2. How would I copy catalog1.users into catalog2.users (not duplicate, but copy some fields over...).

I've tried variations of thi sample code below, with #temptable and with @temptable, inside the "use master" and outside of....

Code:
USE master
DECLARE @temptable TABLE (name nvarchar(5))
USE [Users]

[Code]....

View 1 Replies View Related

SQL Server 2012 :: Updating Table2 By Checking Table1

Apr 23, 2014

I want to update table2 by checking table1.

if trauma has atleast 1 then clm2 in table2 would be 1
if infec has atleast 1 then clm2 in table2 would be 2

table1

Clm1 Clm2
Trauma 1
Trauma 1
Trauma 1
Infec 2
Infec 2
Trauma Null

table2

clm1 clm2
Trauma 1
infec 2

I have to update table2 based on table one ny checking multiple columns.

View 2 Replies View Related

Get Records In Table1 Not In Table2 - Not Exists Get Null Result

Jun 9, 2015

I'm trying to get the records in table1 not in table2 the query is

Select * from table1 where not exists (select * from table2)
--table1 and table2 ,structure are same

It will get a null result

Strange thing , while I add a where condition in the subquery, it worked.

Select * from table1 where not exists (select * from table2 where table1.ID =table2.ID)

It will get the result as expected.

I just thought it would compare all the fileds for the outer query and inner query, but seems not. Why, I add a condition, it worked ?

View 4 Replies View Related

Get The Id Of Inserted Rows --&&> Insert Into Table1 Select * From Table 2 ?

Apr 17, 2008



hi

I want to do a "bulk" insert and then get the id (primary key) of the inseret rows:

insert into table1 select * from table2

If I get the value of the @@identity, I always get the last inserted record.

Any idea how to get the ids of all inserted values?

Thx

Olivier

View 13 Replies View Related

How Can Gridview1 Be Displayed Table1 And Table2 And Table3 :) Without Join Code

Jun 17, 2008

hello friend
i have table1 and table2 and table3..
i have category and product number and name of colums for per table
i want to do this.. select category from table1 where category= textbox1.text   and category from table2 where category= textbox1.text   and category from table 3 where category= textbox1.text 
and if there are category for per category colums of  per table, gridview should displayed  table1 and table2 and table2 in category and name and product number of colums:)
if there is category of coulums for table1, gridview should displayed just table1  in category and name and product number of colums:)
i want to 3 bind for gridview1 :) it should be without join because i dont need join..  columns name is same for tables but value of category is different but it can be same :)
cheers

View 6 Replies View Related

Update Table2 With Last Visited Date Based On Table1 Entry

Oct 30, 2013

I have two tables T1 and T2

T1 is having User : Visiting Date
T2 IS having User : Last Visited Date

Now I have to update T2 with last visited date based on T1 Entry.

View 1 Replies View Related

Create Delete Trigger On Table1 To Update A Filed On Table2

Jan 11, 2008

Hi everyoneI am trying to create a DELETE Trigger. I have 2 tables. Table1 andTable2. Table 2 has all the same fields and records as Table1 + 1extra column "date_removed"I would like that when a record is deleted from Table 1, the triggerfinds that record in Table2 and updates the date_removed filed withcurrent time stamp.The primary key on both is combination of domain,admin_group and cn.CREATE TRIGGER [tr_updateTable2] ON [dbo].tbl_Table1FOR DELETEASUpdate Table2SET date_removed = getDate()I'm stuck here, how do I manipulate on Table2 only the records thatwere deleted on Table1, so to only update date_removed filed for themin Table2?I guess i need to compare domain, cn and admin_group, but I don't knowhow.Any help would be greatly appreciatedThanks! :-)

View 3 Replies View Related

Querying Table2 With Results From Table1 And Displaying Data From Both Tables

Nov 8, 2006

I need help in writing a query.

The query should get top 10 items and their values from current year and the values for the same items from previous year table.

I was able to write the code for 1st part that gets values from 1st table but I don't know how to get the values from 2nd table.

The 2 tables does not have any primary/foreign key relations. Both tables have same structure and same columns.

I am attaching some images below to give more information.

Image of results from my query.

Image of how the final output should look like.

The Store Procedure code is:

ALTER Procedure [dbo].[free_customsHS4](
@TblName1 varchar(20),
@TblType varchar(20),
@District varchar(6),
@Month varchar(3)
)


AS
Begin
SET NOCOUNT ON;

Declare @SQuery nvarchar(3000)
set @TblName1 = '[' + @TblName1 + ']'
set @TblType = '[' + @TblType + ']'


SELECT @SQuery = 'select top 10 a.commodity1 as HS4, b.descrip_1 as Description,
sum(a.all_val_mo) as [Amount],

(sum(a.all_val_mo)/(select Sum(a.all_val_mo) FROM ' + @TblName1 + 'a
where a.stat_month <=' + @Month + ' and a.district=' + @District +'))*100 as [% Share]

FROM ' + @TblName1 + ' a left outer join ' + @TblType + ' b on a.commodity1=b.commodity1
where a.stat_month <=' + @Month + ' and a.district=' + @District +'
Group by a.commodity1, b.descrip_1
order by [Amount] desc'

EXEC sp_executesql @SQuery
END

View 2 Replies View Related

SQL Server 2012 :: Return Descriptions From Table2 In Same Format As Codes From Table1?

Apr 22, 2015

Table1 contains a CODES column which may store multiple codes separated by commas.

The descriptions for these codes are stored individually in a column in in Table2.

I would like to return the descriptions from Table2 in the same format as the codes from Table1.

Table1 Stores multiple codes per ID in a single column.

ID CODES
-- --------------
01 Code1,Code2,Code3

Table2 Stores the definitions for the codes in Table1

CODE DESCRIPTION
----- ---------------
Code1 Description1
Code2 Description2
Code3 Description3

The tables are what the tables are. Here is what I am trying to accomplish:

ID CODES DESCRIPTIONS
-- ----------------- --------------------------------------
01 Code1,etc Description1,Description2,Description3

I've found two different queries which return each code and associated description by ID in separate rows. Perhaps the next step is to aggregate from this?

View 7 Replies View Related







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