|
Yes you are right, I forgot to write UNION ALL in both two places on my first response.Thanks for correcting me dude.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
No problem. You beat me to the solution anyhow 
|
|
|
|
|
if u wants to run both qries one after another
then the Solution is....
SqlQry 1
Go
Sqlqry 2
Go
.
.
.
.
Try Go Statement in SQL it will help you...
Enjoy your coding.. 
|
|
|
|
|
Hi guys,
I have the following query, example
Select a.id, b.description
from table1 a
left join (select top 1 c.id, c.description from tableb c where c.id = a.id) as b on b.id = a.id
The reason I do this is because tableb could have multiple duplicates of c.id and I want it to only do the select on one specific id from the table1.
But I get the error because a.id is not within the select statement of tableb.
Is there any way that I can do this, if I remove the where clause in the tableb select statement it returns duplicate values on the description.
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
Try this
Select a.id<br />
(select top 1 c.id from tableb c where c.id = a.id) ,<br />
(select top 1 c.description from tableb c where c.id = a.id) <br />
from table1 a
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Works, Thanks
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
No problem,I am glad that worked for you.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
I have to be able to select het highest number smaller than a certain number
for example I have in DB
1
2
5
6
7
and I want the highest number smaller than 5 (in this case 2) but can't seem to get this working (at least not in 1 sql statement)
I can get the numbers 1 and 2 (is easy) but want to get only the number 2
any help would be appriciated
|
|
|
|
|
TDDragon wrote: I have to be able to select het highest number smaller than a certain number
for example I have in DB
1
2
5
6
7
and I want the highest number smaller than 5 (in this case 2) but can't seem to get this working (at least not in 1 sql statement)
I can get the numbers 1 and 2 (is easy) but want to get only the number 2
any help would be appriciated
Select Max(ID) where ID<5
Does that work for you?
|
|
|
|
|
I tried this yesterday but it returned an empty row
tried it again today and now I do get an value (think my mind is playing tricks on me  )
or the fact that I had a second column in the select statement was cousing trouble I don't know anyway it works now
Thank you for you time
|
|
|
|
|
ChandraRam is correct, but you can use this query too:
select top 1 id from tablename where id < 5 order by id desc
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Wonder why I didn't think of that...  
|
|
|
|
|
Hi everyone,
I am developing a asp.net c# application. I am a beginner to MSMQ. I need to save the data(username, password) into msmq. In the particular period of time, I need to transfer that data(username, password) to MySQL database due to making the fast data access. How is it possible. Please help me regarding this. The best elaborated answer with some examples would be appreciated.
Thanks in Advance,
J. Mohan.
I see the God Face in Helping people
|
|
|
|
|
i do not how it is in mysql but in MS SQL you can use stored procesure..
if you want to knw abt that tellme...
|
|
|
|
|
I developing a software in which I am listing products.
On product name there is link which shows product details on the basis on product name passed to details page.
Some product contain name with % symbol shows error in details page. Other product details are coming fine.
How to resolve this problem. Please suggest.
|
|
|
|
|
Poonam Devi wrote: Some product contain name with % symbol shows error in details page
What is the error?
|
|
|
|
|
CAn you Explore it more with Code....
I can try on it.....
By
|
|
|
|
|
as far as the backward compatibility is concerned , how can i differentiate the ms access and sql server , on the basis of this feature?
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Sorry, I don't understand your question. What are you trying to find out?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Does any one know how I would get some data from a MsSQL database and upload it to MySQL hosted server
Situation
I’m running Symantec backup exec on a few severs and they email me notifications of what’s happened in the back up but there are too many to start filling away!!! The program uses MsSql to store the information I want to upload it to mysql hosted sever. I can tell backup exec to run a command after backup
any ideas guys
|
|
|
|
|
Have you tried SSIS?
“If we are all in agreement on the decision - then I propose we postpone further discussion of this matter until our next meeting to give ourselves time to develop disagreement and perhaps gain some understanding of what the decision is all about.”-Alfred P. Sloan
|
|
|
|
|
Please tell me how to add a database created in sql server database which is stored in default folder of Microsoft SQL Server to a my folder(created by me)?
|
|
|
|
|
Do you mean you want to move the data files for an existing database to a different location?
Detach the database (right-click it in Management Studio or Enterprise Manager and click Detach), make a note of the security settings on the files, move them, check that the same users have permission to read and write the files, and then re-attach the database (this option is named Attach on the server's context menu).
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi,
How can i configure my Sql Server2005 to communicate with MSAccess which is locating on some other place(Other city). I want to update the Sql server with the updated information of MSAccess tables as they both come online. Please guide me to setup this confuguration.
Thanks in advance
|
|
|
|
|
I have found a potential problem which may get some people stuck when they have customised their Regional Settings. Too short to submit as an Article. Moderators please do with it what is best.
I live in South Africa. PC set up for English (South Africa).
The problem is, Microsoft says that in South Africa we write our dates as MM/dd/yyyy, when in fact we (ordinary people) use dd/MM/yyyy.
So in Reqional Settings we use Customise and change our Short Date format to dd/MM/yyyy.
Everything works fine if you use datasets to update a table, as the data is already a DateTime. But when you use an INSERT INTO command a problem comes up because the DateTime needs to be placed between single-quotes:
"INSERT INTO (column) VALUES('" + myDate + "')"
In our case, this converts to:
"INSERT INTO (column) VALUES('dd/MM/yyyy')"
But the server is expecting:
"INSERT INTO (column) VALUES('MM/dd/yyyy')" because this is the default short-date format for South Africa.
So the following must be used:
"INSERT INTO (column) VALUES('" + myDate.ToString("MM/dd/yyyy") + "')"
This converts to:
"INSERT INTO (column) VALUES('MM/dd/yyyy')" which is what the server is expecting.
This problem will arise with any Customisations made, including separators. myDate.ToString() must specify the exact format the server is expecting.
Nigel
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
