Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ashab02

    deduping a table

    Hello I have a table with loads of records. What I am trying to do is dedpue the table. I have details in this table but the records can sometimes be slighly different from the previous record. An example would be: ID Field1 Field2 1 Joe Bloggs 2 Joe...
  2. ashab02

    Trying to select a specific record

    Hello Thanks for your reply but the max date of change would give me 04/01/2009 but I want 03/01/2009 Can you think of a away of doing that?
  3. ashab02

    Trying to select a specific record

    Hello I have table which has address changes recorded within it. It has aunique identifying field 'Key' and also has a foreign key 'FKEY'. The table currently looks like this: Key FKEY DateOfChange Add1 Add2 1 100 01/01/2009 1 Test Street TestTown 2...
  4. ashab02

    How do I get all the records from table b to display

    you ould use a union query where by you take your firt query then followed by Union all and then right a second query with the left outer join where the param is null Does this make any sense?
  5. ashab02

    How to call a step within a Job

    Hello Yes I'm aware of this but the problem is that i'm doing a check from something that is populated from another source so it will netiher be a failure or success. It will just be some code that needs to be executed at the start and from the result do one of two things. What I have is a job...
  6. ashab02

    How to call a step within a Job

    Hello I am writing my own Job within SQL server agent and would like to execute a certain step based on a previous statement. So far I have DECLARE @FLAG varchar(50) SET @FLAG = (select status from test) if @flag = 'Successful' begin 'Want to call a step2 here' end if @flag = 'Fail' begin...
  7. ashab02

    Extracting certain characters from a string

    i'm not sure how the replcae will help me for the following example 'Flat 4 Hope Lane'
  8. ashab02

    Extracting certain characters from a string

    Hello I have a set of data which contains address details. What I would like to do is get the first letter of the street name but the problem I have is that some of data contains records like 'Flat 4, Hope Lane' 'Flat 4 Hope Lane' The code I have is as follows and it only handles the first...
  9. ashab02

    Problem searching with date criteria

    Hello I have a set of data and when I convert the column with no where clause it works fine, the whole set converts successfully. However when i use a cluase, i.e >= '20080701' then it fails 'Syntax error converting datetime from character string.' I have the following query: select...
  10. ashab02

    Transfer my DTS Packages from one server to another

    Forgot to mention. The server I am using are both SQL Server 2000.
  11. ashab02

    Transfer my DTS Packages from one server to another

    Hello I have recently built a new more powerful server and I would like now to migrate my DTS Packages and JOBS from the old server to the newly created server. My new server will contain the same data as the old server. What I would like is to move the packages and also once the packages have...
  12. ashab02

    Getting the date range for the whole month

    Hello I have a problem in the sense that I have a query which currently is reliant on me entering the dates for it to run manually. There are two fields I enter in a table 'CurrentStart' and 'CurrentEnd' and I then link to this table in my main query. What I want to do is automate this process...
  13. ashab02

    Identifying Duplicate entries with different ID'S

    ...the ID. I want to now attach the ID to these records, can someone give me some guidance on this. So far I have used (simplified): SELECT COUNT(*) FORENAME,SURNAME,ADD1, ADD2 FROM CUSTOMER GROUP BY FORENAME,SURNAME,ADD1, ADD2 HAVING COUNT(*) > 1 The above returns the duplicate cases. I now...
  14. ashab02

    Last working day of the previous month

    thanks mate, looks like what I need but will only be able to test fully next month but looking at it all seems ok with this code you truly are a coding king Tnaks for your help Shab
  15. ashab02

    Last working day of the previous month

    so this table, would it need an entry for everyday of the year?
  16. ashab02

    Last working day of the previous month

    Hello Yes I only consider working days from Monday to Friday. No I dont have a table with public holidays. Do you have a solution?
  17. ashab02

    Last working day of the previous month

    Hello I have a query which relies on a criteria, this criteria is the last working day of the previous month, so for example throughout this month I want to pickup the value 30/11/2007 as it is the last working day of the previous month. I currently use a dateadd function but its reliant on me...
  18. ashab02

    Date format

    thats perfect, thanks for your help
  19. ashab02

    Date format

    Hello Having trouble exporting some data into the format I want. I have a datetime column and need to change that so it appears in the following format dd/mm/yyyy. I have tried converting it to a type of 103 but for some reason when I view my exported text document it has the date stamp as...
  20. ashab02

    Building a string from previous dates

    Hello I have a set of data and one case reference may have 10 dates. What i want to do is take the record with the latest date but then also want a column which will list my previous dates with a ',' seperating them. So something like: 12/01/2006, 15/01/2006, 12/05/2007. Can anyone help? Shab

Part and Inventory Search

Back
Top