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. mossbs

    SQL 2012 Clusters - attaching DBs

    Hi guys, I've never worked with a clustered environment until recently so excuse the possible lack of knowledge on this one... Basically we have a 4 DB application and each month we do a data publication that happens offline and then means that 2 of the DBs have to be detached and the new...
  2. mossbs

    Finding Hierarchy - Single table

    Hi guys, apologies for slow reply... (been on A/L for week... so just come back to it... ) Have managed to get the recursive CTE working... with PartReplacements ([Old_Part_Number], [New_Part_Number], [Country_Code], [PartList]) as ( select [Old_Service_Part_Number]...
  3. mossbs

    Finding Hierarchy - Single table

    Cheers dudes, having a play with Drlex's example at the minute... made a couple of edits as there wont be a NULL value in the table... if part hasn't been replaced then it just doesn't appear in the Old_Part_Number column. Looks like its doing the trick though! Muchos thanks man!
  4. mossbs

    Finding Hierarchy - Single table

    cheers Simi... small amount of test data here... insert into PartReplacement select '0102124','0102299','UK',1 union select '0102299','0102254','UK',1 union select '0102254','0101940','UK',1 union select '0102124','0102299','DE',1 union select '0102299','0102254','DE',1 union select...
  5. mossbs

    Finding Hierarchy - Single table

    Hi Guys, Got an issue I cant seem to figure out... I have one table that contains what part numbers are currently assigned in each country (table CurrentPart - columns Part_Number nvarchar(50), Country_Code nvarchar(2)) then another table that contains data about part replacements...
  6. mossbs

    Comma Seperated List as a Column - Function help

    Cheers guys - I've tried the STUFF method - but still takes ages... Will try the REPLACE method see how this fairs. Got a feeling the slow run time may just be the sheer amount of data...
  7. mossbs

    Comma Seperated List as a Column - Function help

    Hi guys, I need to produce a report that in one columns has all the market codes as a comma seperated list - for this I have edited a UDF (function) I already had which uses COALESCE to produce the comma seperated list... ALTER function [dbo].[udf_List_Markets] (@Id int) returns...
  8. mossbs

    CSV destination UTF8 encoding

    (this is a repost from the SSIS forum as this area seems to get more hits... apologies for duplication!) Hi guys - having massive issue trying to get SSIS package to export data to a csv file with UTF8 encoding. I've tried a number of things... and lateset package consists of the following...
  9. mossbs

    CSV destination UTF8 encoding

    Hi guys - having massive issue trying to get SSIS package to export data to a csv file with UTF8 encoding. I've tried a number of things... and lateset package consists of the following.. - File system task - this has a source of a csv template (in UTF8) and a destination created from an...
  10. mossbs

    DB Encryption

    Hi guys, Although I've been working with SQL for a while, encryption is not something I've worked with before - I've done a bit of reading up on BOL etc but have some specific questions I'm still not sure of the answer to... - Is it possible to encrypt data so that it is encrypted only on...
  11. mossbs

    SSIS deployed on different server to creation

    Cheers for the replies guys, turns out I had everything checked - someone had been in and changed the credential i had assigned against the user account running the SQL Job (Grrrrr!) meaning the SQL Proxy account didnt actually have access to the required places. All sorted though! Cheers again.
  12. mossbs

    Hi guys, (sorry to repost from

    Hi guys, (sorry to repost from another area - just this one seems to get more attention!) I have an SSIS package that imports data, runs some SPs to create a report, then exports this data to excel, then emails the excel file off. Problem I'm getting i think is to do with the fact i am...
  13. mossbs

    SSIS deployed on different server to creation

    Hi guys, Pulling my hair out on this one. I have an SSIS package that imports data, runs some SPs to create a report, then exports this data to excel, then emails the excel file off. Problem I'm getting i think is to do with the fact i am creating and building the package locally - then...
  14. mossbs

    Cannot uninstall SQL SVR 2005

    **UPDATE** I managed to uninstall the SQL 2005 components manually from the CMD line using "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove" Just thought i'd post this incase anyone else had this problem. Cheers.
  15. mossbs

    Cannot uninstall SQL SVR 2005

    Hi guys, Background info - Had a machine with SQL SVR 2008 STD installed on. Then installed SQL SVR 2005 STD on it. The 2005 install, altohugh worked, didnt have complete functionality (Visual Studio 2005 wasn't installed?!...) Looked online and answer seemed to be that it was because of the...
  16. mossbs

    Splitting a column into multiple columns

    Brilliant Cheers Boris - did exactly what I needed. Could you possibly break down how that works... just so I fully understand it...
  17. mossbs

    Splitting a column into multiple columns

    Cool cheers Simi, I'll have a look about see what i can come up with.
  18. mossbs

    Splitting a column into multiple columns

    Hi guys, I have a table with 1 column in that essentially holds 4 bits of information in it... e.g. COLUMN1 547011 23 MUA 0.2 547011 24 MUA 0.2 547011 25 MUA 0.2 547011 39 MUA 0.2 ....what I need to do is to split this out into 4 columns using the spaces as the delimiter... any...
  19. mossbs

    SSIS package - create, use then drop table

    Hi guys, Have built this SSIS package that imports data from a csv into the database and then runs a load of sql commands based on the data in there to insert new users, roles etc etc into the relevant tables in the database. however i wanted to do this without having to create a table in the...
  20. mossbs

    Count distinct help - date related

    Hi guys, have this procedure set up that produces a count, by customer of requests made. What i need to do is now factor in another table and make sure that the product_id is only being counted once per day, so if the same dealer makes a requst for info on the same product more than once in...

Part and Inventory Search

Back
Top