Search results for query: *

Dear sql user, We do have to tables: TblX tBLy Fld_x fLD_Y A A B C We are trying to get a join with the next result: Fld B C Can someone give us a solution? Nice regards, Michelle.

Dear readers, is there someone who can give a solution of our problem? We have one table with two fields: an articlenumber and a date field. We try to get the articlenumbers with the oldest date. articlenumber datefld a 2004-01-20 a 2004-04-12 a...

Dear sql user, We are trying to make a join of two tables: tblX tbly nr nr 1 3 2 3 4 The result of the join is: 1 2 4 We want to see the result what tbly is missing! Can someone give us the join? Nice regards, Michelle.

Dear MSserver users, Is there any posibility to generate a .sql file as backup voor a database. We are using SQLserver 2000. With the help of "generate SQL script" we can only create a header (fields) of the database. After create database and tables we want to see also the information what...

Dear readers, We are working the first time on MFC. We want to fill a textbox with an integer. Only number keys are correct, if an other key is pressed, the textbox must not be filled with that key. Can Someone give information. Nice regards, Michelle.

Dear sqlserver users, We have made a stored procedure to get a table from an other server database. Syntax: Select * into tblX from [sourceServer].sourcedb.dbo.tblX As we do this sentence in the query analyzer, everything goes well. When we place this sentence in a SP a warning goes up about...

Dear SQL users, We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000).Inside the same server it is very easy to copy a table to an other database with the next syntax: Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a Is it...

Dear SQL users, We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000). Inside the same server it is very easy to copy a table to an other database with the next syntax: Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a Is it...

Dear sql server users, Is the any sql syntax for making a backup to a file. For example: backup tbl_backup to "c:\mybackup" If yes, can someone give the syntax? Michelle.

Dear users, It is for us a crime to debug a SP. Is there any posibillity to check step by step a SP. We are using sqlserver 2000. Can someone give an indication how the best/easiest way is to debug a SP? Maybe a url? Nice regards, Michelle.

Dear sqlserver users, We are using sqlserver 2000. Is it possible to trigger on a field in a table to start a stored procedure? For example all records have a field X with the value "0". We want to start a SP if a record is inserted with field X = 1 or an updating of field X to 1 If yes how...

Dear sql-server users, We are trying to make a sql file with structure and records of our tables with the help of “tools / generate sql script”. If we do so the only result is that the structure is put in a sql file. Is it possible to get the row information? If yes, how do we do that. We don’t...

Dear sql-server users, We got an error: Warning: Null value is eliminated by an aggregate or other SET operation. Can someone explain what kind of error this is? Nice regards, Michelle.

Dear sql users, We do have two tables with a field year and we want to make a join with a where statement year. Our tables: zcities: id_city city_name year 1 NY 2003 2 LA 2004 3 CAL 2004 znames name...

Dear sql kids, We am trying to create a table with an autonumbering field, knows someone the syntax? Good start of 2005! Michelle.

Dear sqlserver users, In the enterprise manager we are looking to the stored procedures / tables etc, we always see a column with the creating date. This date can be very interesting but more important is the modify date. Is there any possibility to get this date and if yes how do we do that...

Dear sqlserver users, In the enterprise manager we are looking to the stored procedures / tables etc, we always see a column with the creating date. This date can be very interesting but more important is the modify date. Is there any possibility to get this date and if yes how do we do that...

Dear sqlserver users,, The enterprise manager of sqlserver 2000 shows allways the creating date of databases, sp etc. This date can be usefull but not every time. The date when, for example, a sp the last time is modified can be more important. Can someone tell us how to get a kollom with the...

Dear sql server users, We are trying to copy a selecting into a existing table (both have the same structure) For making a new table we are using: select * into newtable from existingtable This goes well if newtable doesn´t exist, if the newtable already exist an error will occur. Is there...

Dear sqlserver users, We are trying to get the count of the percentages per shopid For example: shopid discount_percentage 1 50 1 10 1 10 1 10 1 50 2 10 3 50 4 30 Result: shopid 10_perc 50_perc 1...