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: *

  • Users: mossbs
  • Content: Threads
  • Order by date
  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, 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. mossbs

    Replace Help

    Hi guys, Trying to update a column in my db by prefixing the values in there with values from another column in another table.... code i have so far is... update p set p.Password = replace(p.Password,p.Password,d.Code+p.Password) from Password p join DealerEmployee de on de.Id_User =...
  14. mossbs

    Insert Help

    Hi guys, Been tasked with bulk adding a load of users for 466 different companies into the database. there are 3 tables that need to be added into... User - contains certain details about the User account DealerEmployee - simple table that ties the User back to a company Password - contains...
  15. mossbs

    Only send email report if data in it

    Hi guys, Trying to create a SSIS package to produce then email a report, if the data in the tables is correct then the report should contain no rows and as such i just want to send an email saying 'no rows... (or words to that effect).. but if the report does have data in then i want to send a...
  16. mossbs

    @table vs #table in SSIS

    Hi guys, I have a query/stored procedure.... declare @t table ([ref] [int] IDENTITY(1,1) NOT NULL, code varchar(100),logtime datetime,activity varchar(50)) declare @tt table (ref int, code varchar(100),logtime datetime,activity varchar(50)) insert into @t (code,logtime,activity) select...
  17. mossbs

    Syntax help for sp_MSforeachdb

    Hi guys, This is possibly along similar lines to one i raised on here a couple of months ago - but with a twist... Am trying to produce a table for all users accross all databases on a server using the sp_MSforeachdb stored procedure. Solution was to use the following code... CREATE TABLE...
  18. mossbs

    REPLACE help

    Hi guys, Need to do an UPDATE and REPLACE on a column in one of my tables. The data concerned will be along the lines of this... DE0012.00 DE0013.00 DE0017.00 DE0017.01 DE0017.02 DE0017.03 DE0017.04 DE0017.05 There are 2 things i need to do... If the data ends in '.00' i need it to remove...
  19. mossbs

    Count Query Help

    Hi guys, Trying to do a query to produce a count by dealer code of when certain things are true about a quote raised by that dealer. the main tables i am using are the Quote table and the QuoteItem table (quote has details on when the quote was raised and by who, QuoteItem contains details of...
  20. mossbs

    error: 40 - Could not open a connection to SQL Server

    Hi guys, Have tried searching online for this - but found no where that coul fix what has happened. Basically as of today i cannot login/connect to SQL SVR instance that is installed on my local machine for dev work. I use Windows Authentication to connect. Worked fine yesterday but, as of...

Part and Inventory Search

Back
Top