SQL Inner Join? - Database Discussion Boards

Re: MySQL - C# - problem with charset encoding

yarns27-Jun-07 23:19

27-Jun-07 23:19

Changed charset in connection string and in table and column options. Its funny cause until i do not drop table and create new one its not work Smile | :)

Re: MySQL - C# - problem with charset encoding

Giorgi Dalakishvili27-Jun-07 23:24

Giorgi Dalakishvili

27-Jun-07 23:24

In order to display unicode chars and manage them you need to have
1.a table in mysql database which can store unicode chars.
2.connection string which supports unicode so that you retrieve and/or insert unicode chars in the database

#region signature
my articles
#endregion

Saving Sybase Data to Excel

meeram39527-Jun-07 20:26

meeram395

27-Jun-07 20:26

Hi,

I have some bulk data on Sybase. Is there anyway that I can export the data to Excel? If anybody knows, please help me.

Thanks

Meeram395

SQL Server 2005 Reporting Services

Pratik Vasant Shah27-Jun-07 19:38

Pratik Vasant Shah

27-Jun-07 19:38

Hi,
I am a novice to SQL 2005 Reporting Services.
I want to integrate the SQL 2005 Reporting Services wtih MSVS.net 2005.
I would be very thankful if someone can please help as to which what version can I find the project type "Business Intelligence Project" in .net 2005.
Currently I have already installed MSSQL 2005 Developer Edition alongwith SQL Server Management Studio Express. However, I am not able to open Report Wizard in .Net 2005

Am I going somewhere wrong??
Am I missing something??

Please help me with any guidelines / link which instructs the installation / configuration procedure of MSSQL2005 Reporting Services and also its integration with .Net 2005 (Framework 2.0 / 3.0)

Thanking you in Advance

Regards
Pratik Shah

Re: SQL Server 2005 Reporting Services

martin_hughes28-Jun-07 8:20

martin_hughes

28-Jun-07 8:20

You need to install Business Intelligence Studio. It should be on your SQL Server 2005 dev disc.

Cheers,

Martin.

Re: SQL Server 2005 Reporting Services

Pratik Vasant Shah28-Jun-07 20:21

Pratik Vasant Shah

28-Jun-07 20:21

Hi,
All done perfectly.

Also, Can I have SQL 2000 and SQL2005RS together?????

Thanks

Thanking you in Advance

Kind Regards
Pratik Shah

Re: SQL Server 2005 Reporting Services

martin_hughes29-Jun-07 1:35

martin_hughes

29-Jun-07 1:35

I've never tried it, but in theory you should be able to.

SQL Inner Join?

Expert Coming27-Jun-07 14:56

Expert Coming

27-Jun-07 14:56

I have two tables. With the following setup.

Name: Call Log
Columns: ID, Sales Rep, Date, Comments

Name: Static SalesReps
Columns: ID, Value

The Call Log table with have Sales Rep being the ID of the Sales Rep for the Static SalesRep table. What Select statement do I need to return all the data from the Call Log table, but have the Static Sales Rep Value column data substituted for the Sales Rep ID from the Call Log table.

If that doesn't make sense I can try to explain it better for anyone willing to help.

Thanks for any and all assitance!

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: SQL Inner Join?

Chinnakasu27-Jun-07 16:31

Chinnakasu

27-Jun-07 16:31

Select b.Value, a.SalesRep, a.Date,a.Comments from call_log as a, Satic_SalesReps as b where a.id = b.id

This statements checks the condition a.id = b.id, if both ids match then the row in table a will be returned.Since we have selected b.value, it will return the value from table b.

Hope this helps u

Regards,
Priya Smile | :)

Re: SQL Inner Join?

Guffa27-Jun-07 20:51

Guffa

27-Jun-07 20:51

select c.ID, s.Value, c.Date, c.Comments<br />
from [Call Log] c<br />
inner join [Static SalesReps] s on s.ID = c.[Sales Rep]

---
single minded; short sighted; long gone;

VB.Net 64 bit long to SQL [modified]

Polymorpher27-Jun-07 12:18

Polymorpher

27-Jun-07 12:18

Anyone know what data type I should use to store a long in sql 2005? The number will average being set at long max about 25% of the time, but will never go over.

Thanks for any help Smile | :)

Pablo

-- modified at 19:01 Wednesday 27th June, 2007
Never mind guys I guess a bigint would work fine. Thanks anyways.

Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so

Re: VB.Net 64 bit long to SQL

Mike Dimmick27-Jun-07 23:13

Mike Dimmick

27-Jun-07 23:13

bigint.

Stability. What an interesting concept. -- Chris Maunder

Re: VB.Net 64 bit long to SQL

Polymorpher28-Jun-07 9:44

Polymorpher

28-Jun-07 9:44

Thanks

Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so

SQL Statement for searching in ADO.NET

kinsella_john27-Jun-07 5:00

kinsella_john

27-Jun-07 5:00

I am trying to create a search for a sql database i have been writing. i have managed to get the search to search "firstName". if i replace this with any of my other column names it also works fine, but i am trying to get it to search multiple columns at once.

i have tried searching on google but dont really know what to search for.

i thought it might have been an AND or an OR statement but couldnt get these working either.

this is my code;

Sub BindDataGrid1()
Dim CS As String
CS = _
"data source=(local)\SQLEXPRESS;" & _
"initial catalog=mus_search_test;"

Dim objCN As SqlConnection
objCN = New SqlConnection(CS)

Dim objDA As SqlDataAdapter
objDA = New SqlDataAdapter("Select * from Musician_Search", objCN)

Dim DS_SearchMusician_Search As DataSet
DS_SearchMusician_Search = New DataSet

objDA.Fill(DS_MS11, "Musician_Search")

Dim objDV As DataView
objDV = DS_MS11.Tables("Musician_Search").DefaultView
' sql statement for row filter
MySearch = "firstName LIKE '*" & txtSearch.Text & "*'"
objDV.RowFilter = MySearch
RecNum = objDV.Count.ToString

John Michael Kinsella
kinsellajohn@hotmail.com

Re: SQL Statement for searching in ADO.NET

DanB198329-Jun-07 0:59

DanB1983

29-Jun-07 0:59

Hey

Can the SQL not be something like this

SELECT * FROM T_TABLE
WHERE FIRST_NAME LIKE @PARAM1 AND DESC LIKE @PARAM2

You could then have the user select the filters and call the correct prodedure/pass the correct dynamic SQL.

In the case of the latter row filter would be :

"firstName LIKE '*" & txtSearch.Text & "*' AND lastname LIKE '*" & txtSearch.Text & "*'"

(The syntax of quotation marks may be incorrect as i just copied and pasted yours)

Hope this helps.

PS you may want to use stored procedures instead of dynamic sql as they help with security

Dan

Edit* There are many ways to search on more than one field such as making temporary tables etc this is just a simple example.

Re: SQL Statement for searching in ADO.NET

kinsella_john29-Jun-07 1:34

kinsella_john

29-Jun-07 1:34

many thanks for your reply, i will give it a shot..

it sounds perfectly plausible but i am not too familiar with SQL yet..

John

John Michael Kinsella
kinsellajohn@hotmail.com

Re: SQL Statement for searching in ADO.NET

DanB198329-Jun-07 2:48

DanB1983

29-Jun-07 2:48

Glad to be of assistance.

If it doesnt work as expected just give us a shout.

Dan

Re: SQL Statement for searching in ADO.NET

kinsella_john3-Jul-07 3:45

kinsella_john

3-Jul-07 3:45

Hi, Dan..

i am having troubles with the same thing.

am i supposed to be using both the statements you suggested?

the syntax for the second part was functional the way i sent it to you and it doesnt seem to work with your additions..

i brainstormed all the obvious problems, like i have secondName insted of lastName.. and extra/missing quotation marks... but i cant work it out.. i just get error messages when i try to search.

see the issue im finding really challenging is that i havent handled much SQL. my course deals with one part at a time.. ie. asp.. then ado.. then sql...
but i am having trouble understanding one and not the other.. its a home study course and so help from tutors is limited..

so, any other suggestions would be much appreciated

John Michael Kinsella
kinsellajohn@hotmail.com

Re: SQL Statement for searching in ADO.NET [modified]

DanB19833-Jul-07 4:08

DanB1983

3-Jul-07 4:08

Hi
What you need to do is allow the user to have a search filter - for example we will use firstname and age.

If we wanted to know all the people whose firstname began with an Dan and were older than 18 we would have a quesry like:

SELECT * FROM T_EMPLOYEES
WHERE FIRSTNAME LIKE 'Dan%' AND AGE > 18

If you can post your errors i will be able to help more

Dan

Edit** Try using a stored procedure instead of dynamic SQL too.

Try this URL http://www.w3schools.com/sql/default.asp

-- modified at 10:16 Tuesday 3rd July, 2007

Urgent need in procedure...........

Member 387988127-Jun-07 3:23

Member 3879881

27-Jun-07 3:23

This is the actual result from my procedure

18-Mar-03 AUD -7.4505805969238281E-9
07-Apr-03 AUD -7.9162418842315674E-9
09-Apr-03 AUD 5.2386894822120667E-10
17-Apr-03 AUD -7.9162418842315674E-9

but My expected result is

18-Mar-03 AUD -7.45058
07-Apr-03 AUD -7.91624
09-Apr-03 AUD 5.23868
17-Apr-03 AUD -7.91624

Please help the do this process how to perform this?

Regards,
Magi

Re: Urgent need in procedure...........

Tarakeshwar Reddy27-Jun-07 6:08

Tarakeshwar Reddy

27-Jun-07 6:08

You just have to round the value using ROUND(Value,5)

Partial update via OleDBDataAdaptor

Dan Neely27-Jun-07 3:12

Dan Neely

27-Jun-07 3:12

Is there a setting that can change the default behavior of an oledbadaptor updating a dataset to access so that if one of the rows in the dataset errors it will still push the remainder of the changes through? If not I can loop through updating one datarow at a time, but was wondering about a more graceful implementation.

--
You have to explain to them [VB coders] what you mean by "typed". their first response is likely to be something like, "Of course my code is typed. Do you think i magically project it onto the screen with the power of my mind?" --- John Simmons / outlaw programmer

Re: Partial update via OleDBDataAdaptor

Dave Kreskowiak27-Jun-07 5:19