I need to subtract two values in a table. One of these values contains a NULL entry. Each time I use the (Pledge - Credit) as 'Difference' I get the value of NULL. How do I get T-SQL to replace the NULL with zero? I encountered this a long time ago while concatenating data. I was able t...more >>

I have to build a text file that has 80 character records. I have a number of fixed length fields in the file but need to add a 'filler' at the end of the fields to get to 80. Do I have to create a dummy variable to do that and if so, how? Thanks -- Stan Gosselin...more >>

HI i am having 2 tables pur_hd and pur_det, Pur_hd is having invoice_date and pur_det is having cost column, and common column purno is in both table for linking.How can i take the cost of max(invoice_date)from pur_det table using select stmt. thanks...more >>

Heres an example of a query with the display SELECT * FROM STOCKks WHERE Price < Cost; Both price and cost are smallmoney datatypes. They display with 4 digits to the left of decimal pt. How do I set it to display only 2 digits for both colums? THanks, Kim...more >>

I have to build a text file with a dollar amount that must be right justified, left zero filled and no decimal. The field I am extracting data from is 'amount' and defined as decimal 9(15,2). -- Stan Gosselin...more >>

I have a table that has the significant date set up as a CHAR datatype with length of 8, i.e 20051027. I want to select all transactions where this date equals the system date. -- Stan Gosselin...more >>

I have lost my password for my mssqlserver can someone help me retrieve it or should I delete this server and download another....more >>

I have to join two table based on the matching of two fields. The bad part is one field is numeric but defined as Character and the other field is decmial. This is my SQL. FROM SLTEST1.STST1 STST1 LEFT OUTER JOIN SLTEST1.STST2 STST2 ON STST1.AUTH1 = STST2.AUTH2 AND STST1.SLIP1...more >>

Hi , If I create a view consist of this query "Select Sum(Amt) From Table1". Is it increase the performance rather then pass the "Select Sum(Amt) From Table1" SQL statement to the reporting tools ? -- Travis Tan...more >>

I working with SQL Server 2000 table called dbo.test. I need to separate value "User Name:xxx" that are in one column named "log" that are space limited. For example I have a column called log and the value = 'domain: User Name:user1 User Name:user2 User Name: User Name:user3'. I want to writ...more >>

English Query still available in SQLServer 2005, or something that implements natural query? -- Miguel Brito Santos...more >>

I have imported a table into msSQL (2000) One of the fields which was stored originally as a simple date field (05/05/05) was created as nvarchar(8). How to I alter this column to become a DateTime field type? I want to do this before I add any more records. The application will be sending...more >>

I hope I can explain this a little better. I have two tables that I need information from. The first table has all but two fields that I need. I am having two problems. First all I want to do is read the first table take the part number and check the second table. If it is not there I wan...more >>

I have the following view in my db: SELECT dbo.vw_rptShortagesFG.SalesOrder, dbo.vw_rptShortagesFG.ReqShipDate, dbo.vw_rptShortagesFG.MStockCode, dbo.vw_rptShortagesFG.Style, dbo.vw_rptShortagesFG.ColourCode, dbo.vw_rptShortagesFG.Colour, dbo.vw_rptShortagesFG.[S...more >>

First thing I am new to write a query. I have two tables that I need information from. The first table has the user, date and time. The second table has the user, date, time and a record that contains 132 characters. What I need to do is match the user, Date and time along with 7 character...more >>

Hi all, I have one table that contains, among other fields, a NAME and 14 SERVICE fields. The ID number is obvious and the SERVICE fields contain a "Y" if that particular person (NAME) carries out the service. A person can carry out 1 or more services or the person can carry no service. ...more >>

I have a table that has: sku, vendor_number, vendor_item_number. Right now there are multiple vendor_item_numbers to 1 sku. I need to find just 1 vendor_item_number per sku (doesn't matter which one.) So if I knew how to find the TOP 1 in each group (sku, vendor_number) that would do the...more >>

I just could not figure out what is wrong or missing - here my sample code: Dim horse_recordset As New ADODB.Recordset Dim SQLstmt As String Dim xyz As Integer xyz = 13 SQLstmt = "SELECT [Horse-ID], [Horse Name], [Registration Nummer], [Breed] FROM Horses WHE...more >>

Question: If I have created a select statement that returns all possible values, can I step through this list using SQL to get a random selection of 10% of the rows? If so, what commands should I be looking at? The closest I've came was to get the top 10%. However, I do not want just the t...more >>

I'm am new to using SQL Server. In Oracle, when I create scripts to manipulate data, I have a log file automatically created from within the script by issuing the SPOOL command. Is there a similar functionality in SQL server? Besides the log file which records each transaction. Thanks...more >>

I have 2 tables Table 1 looks something like this: ID Page1 Page2 Page3 A Trim Scrap Wiring B Plastic Loose Missing Table 2: GroupID Page PageOffset Description A 1 1 Back A 1...more >>

Hi , I like to build a query to generate a virtual running number from the table. Something like "Select @X , fieldA from TableA" . The result should look like , @x FieldA -- ------- 1 AAA 2 BBB 3 CCC Please help -- Travis Tan...more >>

Hello all - I am trying to create a view that will calculate a category field value based on several conditions regarding another field. i.e. having a table PayCodes (employeeID, paycode) employeeID paycode ---------------------------- 1 01 1 02 ...more >>