Yes, found a solution, had to go with IN and a few tweaks to the way a where clause in the inner query worked. Thank you John Warner ... simply...
3569
charlies_house2000
charlies_hou...
May 12, 2008 9:07 am
I am using a SQL database provided by an ISP. Unfortunately with the account name and host name I ve been given I don t have any priveliges, i.e I cannot add...
3570
John Warner
john@...
May 12, 2008 10:18 am
Contact ISP on how to interact with his server. John Warner...
3571
Dennis West
westdh@...
May 12, 2008 11:03 pm
I need to create a query that would create a mailing list of 500 mailing address. That would list the top 40 addresses of each Denomination and mark them as ...
3572
John Warner
john@...
May 13, 2008 2:45 pm
DBMS? Do you know how to code in any procedural languages? John Warner...
3573
Arnie Rowland
arnie1568
May 13, 2008 3:18 pm
If you check this resource, it will provide you an indication of how to create such a query. ...
3574
John Warner
john@...
May 13, 2008 3:24 pm
Back again, you seem to have been gone so much lately I'm wondering if your family recognizes you <grin/> John Warner...
3575
Arnie Rowland
arnie1568
May 13, 2008 3:28 pm
Hi John, Yep been quite busy lately. Lots of work up at MS working on internal SQL 2008 training materials, exams, etc. Check this link to see some of what...
3576
O S
artificial_net
May 15, 2008 10:21 am
Hi i have something like Select fAge, strName, dtmDateSigned, isActive from mytable Returns something like 20 test1 12/01/2008 1 22 test2 12/01/2008...
3577
Noman Aftab
noman17pk
May 15, 2008 11:31 am
you can do something like: if exists (select * from yourtable where date is null and isActive=1) begin <Your 1st query here> end else begin <Your else query...
3578
Dennis West
westdh@...
May 16, 2008 3:55 am
System.Data.SqlClient.SqlException: Invalid column name 'RowNumber'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean ...
3579
shandy hidayat
shandyhidayat32
May 16, 2008 3:57 am
If Exists(Select '' From MyTable Where dtmDateSigned Is Null And IsActive = 1) Begin Select fAge, strName, dtmDateSigned, isActive From MyTable Where...
3580
peternilsson42
May 16, 2008 4:41 am
... select fAge, strName, dtmDateSigned, isActive from mytable where ( -- what you want if the row exists fAge = 26 and dtmDateSigned is null and isActive = 1 ...
3581
John Warner
john@...
May 16, 2008 8:43 am
Show us the string value (from the immediate window NOT what you think the value is) for string SQL. This error is coming from your .net code not from SQL...
3582
Cesar ROUILLON SIXTO
cesar_rouillon
May 21, 2008 9:51 pm
Hi, friends Someone can I help me, I have the next query: Select L.* from LotexManzana L where L.LxM_Codigo = ( Select Cli_CodLxM from Cliente where " & estado...
3583
John Warner
john@...
May 22, 2008 12:04 am
The language bearer is getting us, I'm not sure I understand the problem. Is the query failing to produce a result set? Is this code you are building as say a...
3584
Cesar ROUILLON SIXTO
cesar_rouillon
May 22, 2008 3:32 pm
yes, my question is why, my query don't produce a result? Saludos ROUILLON SIXTO César E.Ing. en Informática y SistemasPerú To:...
3585
John Warner
john@...
May 22, 2008 3:42 pm
Ok understood. Does Select Cli_CodLxM from Cliente where " & estado & "='1' Produce results? this is why I was aksing if you are building an SQL string in...
3586
Cesar ROUILLON SIXTO
cesar_rouillon
May 22, 2008 4:12 pm
Thanks , for your response, but I need show information of table "LotexManzana" of the clients with estado='1', and the information de theses Clients of the...
3587
John Warner
john@...
May 22, 2008 4:23 pm
OK, so now we are to the bottom of the problem. In the Immediate Window in VS what exactly is the value of the string variable that you are building the SQL...
3588
Cesar ROUILLON SIXTO
cesar_rouillon
May 22, 2008 4:30 pm
I tried in Query Analyzer and show me an error, is the reason of my question, what is bad in my query?, What Can I do?, I'm working with SQL 2000. Thanks and...
3589
John Warner
john@...
May 22, 2008 4:32 pm
What is the error? John Warner ... &form=QBRE [Non-text portions of this message have been removed] ... Yahoo! Groups Links...
3590
John Warner
john@...
May 22, 2008 4:38 pm
Also I forgot to ask what is the query as typed into QA? Not the VB string John Warner...
3591
John Warner
john@...
May 22, 2008 5:42 pm
Ah at last we finally arrive at the full story of what is happening here. Just as a note this information on the first day of your questions would have gotten...
3592
Cesar ROUILLON SIXTO
cesar_rouillon
May 22, 2008 5:57 pm
Thanks for your time John, Thanks too for the sugestions, I think in all these the next time. Regards ROUILLON SIXTO César E.Ing. en Informática y...
3593
lovela80
May 23, 2008 6:47 pm
Hello, I am new to SQL. I would like to make the following into one field. I am not sure how to do that. right('0' + convert(varchar(2),...
Hi a everybody Can some body help me please: I have a function in sql server 2000, is the next: CREATE FUNCTION dbo.fhcpDorado ( @codclub char(2), @codJugador...
3596
Cesar ROUILLON SIXTO
cesar_rouillon
May 27, 2008 10:35 pm
Thanks, but I get the solution: An example:SELECT au_fname, au_lname, CASE state WHEN 'CA' THEN 'California' WHEN 'KS' THEN 'Kansas' WHEN 'TN' THEN 'Tennessee'...
3597
Anca, Paul
paul_anca
May 27, 2008 10:48 pm
Here is what you need: CREATE FUNCTION dbo.fhcpDorado ( @codclub char(2), @codJugador char(4), @ahora datetime ) RETURNS varchar(3) AS BEGIN declare @sexo char...
