Search results for query: *

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

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

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!

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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