2,935 Topics
 | |
 | File under FAIL: social network widget maker RockYou has fallen victim to a SQL injection flaw and as a result some 32.6 million users are being urged to change their passwords as a matter of urgency. Security specialists Imperva discovered the problem at social networking development site Rockyou.com and issued …  |
| | Hey guys! I seem to be posting here a lot the past few days but as I am new to SQL Server I am finding to quite a pain to get used to! I am having a problem referencing foreign keys. I did post another thread about this but this … |
| | Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record …  |
 | my project needs an implementation of supertype-subtype, however, we haven't tackled that topic yet at school. i know the concept of supertype-subtype, but i don't know how to write it out on mssql. i even don't know how to insert data using supertype-subtype. here's the reqs's: * there is a … |
| | Dear members I have a challange. I want to update my CRM database (MSSQL) with turnover numbers from our ERP database. I can retreive the data in different file types from my ERP database so they can be importet as a flat file. But does anybody have a good idea … |
| | I have two databases with the same table name and identical schemas and no duplicate entries. How would I merge the information? SQL 2008 |
| | |
| | Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the … |
| | Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead … |
| | What I need is the SQL code to display the last business day - usually will be one day prior, but I want that if I run this code on Monday that, instead of Sunday's date, I get Friday's date. This is what I started with [CODE] - Automatically generate … |
 | Hello, I need to make a cursor, which would call a stored procedure to do something for me... but the procedure needs dynamic parameters. first one, it has to retrieve existing ID number from a table and the second parameter will be new value updated... so, for every row, I … |
| | Please see and find out what was the problem. It's seem OK on me but it doesn't work on vb code using SQL Server 2000 [code=sql]"SELECT qry_close_month.Item_code, T_ITEM.item_name, " & _ "Sum(IIf(qry_close_month.Bulan='January',qry_close_month.Stock,0)) AS Jan, " & _ "Sum(IIf(qry_close_month.Bulan='February',qry_close_month.Stock,0)) AS Feb, " & _ "Sum(IIf(qry_close_month.Bulan='March',qry_close_month.Stock,0)) AS Mar, " & _ "Sum(IIf(qry_close_month.Bulan='April',qry_close_month.Stock,0)) … |
| | Hello, I have a big web-site(ASP.NET) with a huge data-base(MS-SQL) and i searched for a good way to use paging in my web-site. I found two good way's to do it but i have a little problem to decide which paging way to use, [U]The first way to is to … |
| | Hello, I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), … |
| | Hi everyone, I am currently trying to retrieve data from 3 Access related tables that have been imported into VB2008 DataSet designer. I am not sure whether or not I still need to join the tables. [Code] SELECT R.CustomerID, C.FirstName, C.LastName, R.ExpiryRenewalDate, R.StartDate, R.MailboxID, R.RentalID, M.BoxSize, RT.Personal, RT.Business FROM Receipt … |
| | When I try to use MS SQL Server Enterprise Manager to create table, I typed column name, data type as "int", however the length of "int" is 4, that is fixed I cannot change, now the problem is I need to use this column as record ID, my database is … |
| | I would like to update 2 fields values from one record to a set of records in the same table: I tryed this: [CODE]UPDATE dd SET dd.comment = y.comment, dd.author = y. author FROM Table1 dd LEFT OUTER JOIN (SELECT * FROM Table1 WHERE Idx=1234) y ON dd.vin = y.vin … |
| | Hi I have a problem where dot is used in a table's column name. Say that there is a column called 101.name in a table t1. How do i reference this column in the following: select ... from table t1, table t2 where t1.101.name='test' This doesn't work because of the … |
| | I have the following query in MS Access 2007 [CODE=sql]SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9 FROM Projects GROUP BY Projects.BIMinspector HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));[/CODE] How do I get it to return a result of zero if no records are found?? Any suggestions would be great. Thanks,  |
| | I am trying to deploy a report to the Reporting Services Server but keep running up against this error: [QUOTE]An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection) Could not obtain information about Windows NT group/user … |
| | Hello, I've got some weird database issue, and I can't figure it out myself, so I'd like to ask for your help. My problem is the following: I've a working ASP.NET solution which relies on a MSSQL 2008 database, Express Edition. Now, I'm working on a WPF version of the … |
| | Hello, We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this? Thanks a lot for your help. |
 | Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER … |
| | last semester, i did an airline reservation system. we need to create another system for this semester. any suggestions? [except inventory and enrollment systems] thanks  |
| | Hi I have this data [code] CustBid idProduct bidAmount bidDate 1 272 165.00 2009-11-20 09:05:31.640 1 272 155.00 2009-11-20 09:05:25.480 4 272 95.00 2009-11-19 12:40:44.973 4 272 85.00 2009-11-19 12:40:40.377 1 272 85.00 2009-11-12 11:20:52.400 1 272 85.00 2009-11-12 11:20:52.400 4 272 75.00 2009-11-12 11:11:02.080 1 272 65.00 2009-11-12 11:20:20.170 … |
 | I use SQL Server 2005 and I create function.Below I mention the Function that I created. [CODE] CREATE FUNCTION dbo.udf_GetCountryID(@Name varchar(50)) RETURNS VARCHAR(1000) AS BEGIN Declare @Description varchar(4000) select @Description = coalesce(@Description + ',' , '' ) + countryCode FROM dbo.Test_Table where CommonName='Japan' Return @Description END[/CODE] After creating function I … |
| | I am trying to write a query in my .net app and I'm having trouble pivoting the table since the columns are generated dynamically (based on a month range selected by the user) [CODE]SELECT SUM(HEALTH_MTTR) AS MTTR, SUM(HEALTH_OTR) AS OTR, SUM(HEALTH_REPEAT) AS REPEAT, SUM(HEALTH_CHRONIC) AS CHRONIC, SUM(HEALTH_TOTAL) AS TOTAL, (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) … |
| | hai all i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table its returning wrong results. my table contains, dable datas table_1 is table name number1 text1 1 notify us the day you roll check over. 2 notify us theday you roll check . 3 notify … |
| | Hi I have a column named 'ExtRefNo' which of varchar datatype. The values can be numbers alone(eg; 101) & values comprising characters & numbers(eg:101A3) My requirement is if the user search for ExtRefNo between 100 & 105, it shud retrieve all ExtRefNos ranging from 100,101,102,103,104 & 105. Need not include … |
| | DRIEND FRIENDS, I am given a project "hospital administration database" Could you please guide me how to start and proceed. Thanks and Regards. Shariq |
The End.