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

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

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

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

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

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

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

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

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

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

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

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

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