3,481 Topics
 | |
| | I would like to start off with hello everyone.I recently found a Downloader.Tibs warninig from SpyBot and nothing from the McAfee Antivirus I am running presently on my laptop. I hope someone would take the time to scan over my report and give me some input on my log.Thank you … |
| | Hi all I have a table in which I save a record each time when a user checks in and checks out the office through a time in/ time out device(this device takes thumb impression of user, thus inserts record) table definition is as follows: checkInOutID (PK,int,not null) employeeID (FK, … |
| | Hi Folks, Just a quickie - can wildcards be used in CASE statements? I have inherited some code and wondered if this: [code] (case substring(anownedby,0,charindex('/',anownedby)) when '2361' then 'GOD' when '2361c' then 'GOD' when '2361d' then 'GOD' when '6206252' then 'BIL' when 'bil' then 'BIL' else 'XXX' end) as branch … |
| | HI I am software tester and want some small project which made in MS-sql server 2000 for the testing even if you have some corrupted file (not virus infected)please provide me . THANK YOU  |
| | I have installed a VS 2005 that has a MSSQL Server. When i was about to try running the SQL Server i can't find anything except Configuration tools. I don't know if its express edition or not. Is SQL Server 2005 like this? how would i know that the SQL … |
| | Right well i thought that seeing as i am creating a complete application i thought i would write my own db class just done a little bit of it and i am getting a nice error of [QUOTE]Fatal error: Call to undefined function mysql_connect() in *:\****************\database.engine.php on line 61[/QUOTE] it … |
| | Hi gurus, I got a pre-formated excel sheet as destination. The header is formatted with color. The requirement is to populate the excel sheet with different data type (name(string), no (int), sal(int), age(int)) from second row onwards. The source data is a SQL table and I am using SSIS to … |
| | I have below query inside sp. select groupno,a from table1 where groupno <> 'Test' It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help thank you  |
| | Hi there, I am a new member of this site and I am not very much aware of T-sql's working. My question is what if I need to get one column's data to be the heading of another column. To be very exact I have a school's database. The table … |
| | Hi All I would like some opionion from my IT colleagues around the world including in INdia for myself. To help you give better opinion let me first give you my background: - 26 yrs in IT - 11+ yrs in infrastructure - servers, networking.... - recent 15+ yrs in …  |
| | hi I am getting error for above mention exe in Title. here is log using Hijack. Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 6:04:29 PM, on 2/23/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16608) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe … |
| | I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports . I wrote a sp like this:[code] ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails] ( @paramdate datetime ='02/01/2007' ) as -- select EmpID,EmpName,month(DateOfBirth) bmon,day(DateOFBirth) bday … |
| | Hi I have 3 tables in my database. 1) [B]photo[/B] 2) [B]category[/B] 3) [B]subcategory[/B] in my photo table i save my subcategoryid which is tied to the category table. What i need to do is get the all the subcategoryname from subcategory table where photo.subcategoryid='1' and photoid='2'. I can actually … |
| | Hi to all, I am new to Daniweb and I'm already impressed with the wealth of information available. With that in mind I did a search through the forum but did not see a solution to my problem. I have a couple of machines on the same network. ONe of … |
| | This is my first thread posting. I have searched and viewed a lot of previous threads to see if I could fix the following, but after trying a number of things, either they do not work or I am not doing all that is necessary. I have run Spyhunter scan … |
| | I have Used following code to Insert Values in the table: <%@ Import Namespace ="System.Data" %> <%@ Import Namespace ="System.Data.SqlClient" %> <script runat ="server" > Sub Create(ByVal obj As Object, ByVal e As EventArgs) Dim ConnString As String Dim SQLstr As String ConnString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ERL.mdf;Integrated Security=True;Connect … |
| | Hi friends, I'm creating a website for my college project. on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database. I don't know how to do it. Can you please help me? I'm … |
| | we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005. But we have some permission issues for … |
| | I'm stuck here. Please Help me! I've created a feedback form which takes name, Email Id & Comments from users. On submit button, i want to save the entered details along with the current date to the UserDetails table, so that, when admin logs in and wants to see the …  |
| | I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use dbms_lob.writeappend, I am getting the following error..Command text was not set for … |
 | My name is Richard Walker from Australia and my username for this forum is richie513. I am a self taught web engineer and married with three beautiful children and a loving wife. I was born and raised in the harsh outback of Australia, and now reside on the beautiful sunny … |
| | Hey folks, I have this problem, lets take this text from from 24ways.org just for example-> [QUOTE]Elbow room Paying attention to your typography is important, but it’s not just about making it look nice. Careful use of the line-height property can make your text more readable, which helps everyone, but … |
| | what is the required t-sql for getting all the child categories in a parent category? my table is like this : id | name | parentid |
| | Hi, When i change my function, change the return itens (when it returns a table), i lose grants that i had on it... Exemple: [code]alter function dbo.up_xxx (@cod_instc int) returns @teste table (cod_instc_usr int, COD_INSTC_prod int) AS BEGIN return END[/code] Is there a way not to lose it? Thanks |
| | I have question about TRIGGERS. I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_TABLE and TRUCK_TABLE also. I need TRIGGER for INSERT/UPDATE/DELETE who well read value of VEHICLE_TYPE column in VEHICLE_TABLE and if value of VEHICLE_TYPE is CAR he will execute INSERT/UPDATE/DELETE on CAR_TABLE and if value of VEHICLE_TYPE … |
 | sorry if this a very newbie question but what wrong with my code : [CODE=MSSQL]select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier where TBIn.SupCode=Supplier.SupCode and TBIn.IdBrg=Barang.IdBrg and TBIn.IdBrg = B002[/CODE] Please Help, Best regards...  |
| | Logfile of HijackThis v1.99.1 Scan saved at 10:28:44 PM, on 1/26/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Intel\Wireless\Bin\EvtEng.exe C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe C:\WINDOWS\system32\spoolsv.exe C:\Program Files\Apoint\Apoint.exe C:\WINDOWS\RTHDCPL.EXE C:\WINDOWS\System32\svchost.exe C:\Program Files\Java\jre1.6.0_03\bin\jusched.exe C:\Program Files\Sony\VAIO Power Management\SPMgr.exe C:\Program Files\Common Files\Microsoft …  |
| | I have been running SPybot and Adaware, but have some spyware that keeps returning. Spybot was unable to remove Clever IE Hooker. Here is my hijack this log: Logfile of HijackThis v1.98.1 Scan saved at 2:31:26 PM, on 9/24/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 … |
| | I don't know why my explorer.exe is restarting every 3-5 seconds.... i'm so frustating... i dont know how to stop it..... i used Hi Jack and Here is a log Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 2:06:17 AM, on 2/3/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: …  |
| | Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr fax_nr ---------------------------------------------------------------- 1 5 info@test.com 2 … |
| | Hi, Not sure whats happening, my desktop background turned white (wallpaper disappeared). When I go to the desktop property --> under Desktop tab, the "Background" option is gray/inaccessible. --> when go to Customize Desktop --> there should be 2 tabs: General & Web, however right now the Web tab is … |
| | Hi, this is my first post. I have a website [URL=http://www.psychopanic.com]www.psychopanic.com[/URL] and theres an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL. … |
| | both my dvd drives are not working...device manager says devices working properly but nothing happens..dvd's or cd's dont play.. below is the log.. Logfile of HijackThis v1.99.1 Scan saved at 9:31:45 AM, on 1/31/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe …  |
| | Hi All ! I want to use the returned value of user defined function of source code(VB.NET) in Databases( MSSQL) is it possible to throw the returned value of user defined function of source code into databases? Kindly Help me in this regrads plzzzz ... its really very urgent ! … |
 | hi All i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this [CODE] Lis_key ===========Attrib_code========================= Func_key====== ===================================================================== 01424545 1212033993 PV000000 01424545 Null GEOSS001 01424545 Null GEOSS002 01424545 Null GEOSS003 [/CODE] Figuire:1 Now … |
| | I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with … |
| | this is the questions i faced in an interview i am new in .net and sql so anyone knows this ans please inform me thanks *Can we have an updateable view in SQL? *What is the difference between stroed procedure and stored function in SQL? *What is connection pooling? how … |
| | Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that … |
| | How do you write a store procedure to meet the following conditions: PROXIMITY SERACH PROCEDURE COMPANY table PK company_id int company_name varchar(100) premise varchar(10) street varchar(30) town varchar(100) postcode char(7) x_loc int y_loc int COMPANY_KEYWORD table PK, FK1 company_id int PK keyword varchar(100) The data above shows an extract of … |
| | I am trying to dig data from a table that has a field named begdate and another one named enddate. They hold obvious values, but I need to have the query find the record that has a begdate that matches whatever the previous Sunday was to the day the request … |
| | Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …  |
| | How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, … |
| | I've been infected by a file (C:\windows\system32\adsldpw.dll) that I can't exterminate. I run all the usual suspects, but this guy seems particularly resistant to the tools I'm used to using. This one is more obnoxious than usual, primarily because it keeps respawning a new background version of Internet Explorer every … |
| | Hey I've set up a maintenance plan to backup databases daily and noticed the following error in last night's backup - Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan. Has anyone seen this error before or have any idea what it could mean? Thanks in advance. … |
| | |
 | Hey guys, Thanks for all your help on my last issue with my own laptop. Now I am helping my friend with an old junker he has that has been running slowly and strangely. It has Norton 2004 and Adaware installed. Neither have been updated for over a year, but … |
 | I am using SQL Server 2005 to run a stored procedure to update, delete, or insert depending on some conditions. The problem is that it gives the following error: Msg 4104, Level 16, State 1, Line 49 The multi-part identifier "PART.ID" could not be bound. I have it inserting some … |
 | Can anyone please tell me how can i copy a table. thank you. and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company. Thanks a lot. |
| | Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select … |
| | I'm working with SQL Server 2005 on a stored procedure, but it appears to be going through both parts of the following statement, and not skipping the second half if it is supposed to. Basically it should update the row if there is data there, and remove the row if … |
The End.