Search results for query: *

we're building 2 x new sql2000 servers and were wondering your thoughts on tempdb we dont have the luxury of being its own array, storage space is probably more important than total optimum performance at this time hence: we've got 8 x 72 gb drives and need to go c: (OS and programme files)...

hi I was wondering if anyone new about how to go about this I've received a request to received a file from a client each month (I believe a flat csv file), load it into our sql 2k, do some manipulation and then export it from DTS into "Unix Format" Now thats the bit I dont get, Unix isnt...

anyone come across this or can help? Ok, I have server A with SQL2k, service pack4 The default collation on it is SQL_Latin1_General_CP1_CI_AS (SELECT SERVERPROPERTY ('Collation')) We need to move some databases to server B, which is a new install, and need to get the same server collation...

Hi I'm calling a javascript function from an asp.net page and need to test a value. I'm running this bit of code.. alert(document.getElementById("rblUKResident").Value); ..so that I can test the value of a .net radio button control. The control has the values "Yes" and "No", but whichever one...

Hi I'm calling a javascript function from an asp.net page. The function pops a confirmation box with some information: btnContinue.Attributes.Add("onClick", "score();") function score(){ //Calculate the score var points = 0; if(document.getElementById("rblFullNameGiven").Value...

Hi folks I have a spreadsheet of football data containing loads of info. The bit I am currently working on is doing some calculations based on a teams last x games (lets say x will be 6) Its ordered by calldate,hometeam and if I can it get it doing what I want then it will have a division...

Can I do this with DSUM or what other functions might I need, can someone point me in the right direction pls, perhaps I need vlookup as well? I hope my examples ok I'm just after a pointer in the right direction, so sheet1 column B should have a formula to sum sheet2 response field where...

hi folks I've got 2 x relational tables in 2 x worksheets sheet1 = a list of companys. The accountnumber field is unique to each row. sheet2 = a list of phone numbers, there are multiple phone numbers for each account number in this list so the relationship between the 2 x tables is on the...

We've just installed 3 instances of SQL2k on a Win2k server, 1 x default install and 2 x named installs as we are hosting databes for 2 clients About to service pack it with file SQL2000-KB884525-SP4-x86-ENU.EXE Will I have to install the service pack 3 times, one for each instance? If so if...

Hi, can anyone advise on this query. I have a calllist table with unique records (i3_rowid primary key) and a callhistory table with multiple records joined on the i3_rowid field. I need to do a query to retrieve the most recent finishcode for each record. The query below does the trick. The...

Hi chaps, dont know if this can be done easily have a DTS package pointing to a UNC share. A file is placed in the folder for importing into database + some other steps. Theres only ever one file loaded into the import folder at a time then the package is run. The first step uses xp_cmdshell...

hi guys, bet this is dead easy, cant suss it out, first time worked with a pivot table, would apprecitiate your expertise trying to add up some columns on a pivot table, though I want to perform the calculations within the table itself not outside. I want to total up some of the columns from...

Hi all I need to denormalise a table, the export I need to create is a flat file containing the information from the customer table, then each entry from the creditor table appended to the end. The number of export columns need to increase to however many creditors there are for the customer...

Hi, I have made a fairly basic access form with some drop downs on, its for a questionnaire. I've a combo box called Calltransferred. If the value in this box is selected as 'Yes', then they need to fill in the next combo box called Callreasonagainaftertransfer which also just has a Yes or No...

Hi Folks I am trying to sort out some data to load into our database server, I have tried a SQL solution but am struggling, wonder if anyone can help with Excel? We have an excel sheet containing multiple records per customer, one for each phone number. it looks something like this...

greetings, wonder if anyone can help with a tricky little problem! I need to denormalise a table, to get it into a format to load into our telephone system database. I think I can do this once I have achieved this step: We have an excel sheet containing multiple records per customer, one for...

Hi pls could someone tell me whats wrong with my simple formula. I want to add up all the values in column C if the date in Column B is January =SUMIF(B:B,"=Month=1",C:C) should this not work, pls let me know if I need to provide anymore info Thanks Matt Brighton, UK

Hi all I'm having problem with attachments field in xp_sendmail. I am trying to attach 3 x files from the previous day which are generated automatically from a DTS package, so the files have a ddmm appended. Error message Server: Msg 17912, Level 18, State 1, Line 0 Attachment open failure...

my requirement is to export queries to multiple excel sheets without field headers, I thought there would be an option for it though now I'm thinking it cant be done, has anyone else exported to excel without field headers? Thanks Matt Brighton, UK

We have an int field, call length in seconds. I'm sure its possible, but I cant think how to get it into hours/mins/secs or just mins/secs I'm trying to do some calculations on it, an example select convert(decimal(8,2),sum(convert(decimal,(length)))/60)/count(rowid) as 'avg call length...