Search:

Maybe I didnt explain something right
if I execute:

SELECT CG FROM CODE
WHERE sitio='AAA'

the result is: '26022','26023','26024'

I have a Mysql database with 2 tables:
clientes and code
clientes have a field called celda (index called CG)
and code have a field called CG (index called CG)

they have the same data type

I...

Don't answer this, im an idiot. After a long day making complex querys I couldnt resolve a simple:
Select name,max(date)
from table
where number<>0
group by name;

I didnt know how to title this thread...
I have a table with name,a number and a date.
I need to get the date in wich, that number changed from zero from end to start.

For example:
I have ...

Hi, im not sure if this is the best place to post this, if its wrong please move it.
I've been doing some things in VB6 and veeeery little in VB.NET (using 95% VB6 stuff, and only changing things...

Today they give me admin access for 5 minutes...they created the user and set "spanish" for language...it should be "English", corrected that. All working as it should.
Obviously they have to pay...

Before the re-installation and in all my projects it works with "/", I can edit all the SQLs statements, but Im trying to know what have change in the SQL server, and need to show that they triggered...

I'm using yyyy/mm/dd:

fechaInicio.Value = Format(DTPInicio.Value, "yyyy/MM/dd")

Thanks viperbyte, I'll try that tomorrow.
I Just look and see that they have change the collation too...I'll try resetting that to the previous value.
I can change anything of my DB but not a lot...

The problem seems to be that it needs now the dates in other format:
dd/mm/yyyy instead of YYYY/mm/dd...for the type of application I have dates everywhere, SPs, lots of queries, etc. I figured that...

Yes

I have one project running on a DB on MSSQL 2k, with other *big* 3rd party software.
2 days ago they have a problem with MSSQL, and for some reason instead of looking for the problem they installed...

If I dont use the view the query is something like this, I know the view works and this query is VERY hard to follow =/


SELECT Leg.leg_numero as legajo,month(liq.liq_fecha) as...

The query is:
Create view NAME(field1,field2)
AS select field1, field2 from table where condition

I dont think im having an error there. The database is user locked because is from a software...

Im trying to use a system I developed for MSSQL in access doing the minimun amount of changes, in that SQL I have a view where I execute all queries, I'll try with other methods then...or just skip...

I have a access file, and need to create a view from VB6.
This isnt working:
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\SJA068.mdb;Persist Security Info=False"

...

Sorry for the bump, first and last time...I'm stuck with this =/
thanks!

I have a Datagridview, It will have pairs of lines:
first line: requested customer
second line: assigned quantity for that item for that customer

Something like:...

I have this now:


<connectionStrings>
<add name="DataProject.My.MySettings.CobrosConnectionString"
connectionString="Data Source=***.**.***.**;Initial Catalog=test;User...

Sorry, That is what I have now :S sorry about not telling that before
I have the 2 connection strings, have the first query.
But dont know what to do with the result of the first query (sorry Im...

I have to query one table and insert the result in a table on another database in another server
The query is "select ID, name from Table"
The other table exists and have the same fields.
How can...

I like the temp table because this process is done 1 time each month, I think it will be better than go thought a datareader looking for elements from another datareader to do the inserts.
I'll try...

Databases are on different servers
And I need to be sure that the table with more records (its always the same DB) is Read Only.
So I need to copy the new items from that table to the other table....

That's works when the tables are from the same DB, this are from different DBs, so I have 2 connection strings and I cant do that in only one query (I think).
The tables fields are: IDClient,...

I have 2 databases.
Table in database 1 has 5 fields
Table in database 2 has 15 fields

I made 2 querys that retrieve the 5 fields from the first and 5 fields from the second that are the same...