3,481 Topics
 | |
| | One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and … |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … |
| | The reason is that : 1. I wish to run multiple databases on a single server. To do this securely each login must be granted db_owner on the database so we can use "deny view any database" to hide the other databases from view. (login can see all databases they … |
| | hello i m using a library management software for which i need sql server while installing ms sql 2005 at one point installer gives me this message and throw me out. the message is " To continue, you must provide a strong sa password. To review strong password requirements, click …  |
| | I created 2 tables 1 st table as csat csat_code csat_ou_cod csat_csaeid cus name CSA00001 ADM00001 6825 CUS08349 CSA00002 ADM00001 6826 CUS08347 CSA00003 ADM00001 6832 CUS08351 CSA02547 ADM00001 6824 CUS04150 table2 as csat_survey surveycode csat_code qns id ans id SUR00001 CSA02547 1 3 SUR00002 CSA02547 4 7 now i want … |
| | I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say if the DOCID is not available I … |
| | Hi, I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries; The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps … |
| | i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line. dataset: a b c … |
 | Good Day all i have created a Global Variable as depicted in the following Pic [URL="http://www.tiyaneproperties.co.za/SSIS/pic1.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic1.JPG[/URL] The Following Screen-shot shows how i created my Variable and its Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic2.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic2.JPG [/URL] and the Following Screen-shot shows the Script Editor Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic3.JPG"] http://www.tiyaneproperties.co.za/SSIS/pic3.JPG[/URL] and the Last pic is the code that write … |
| | Hello all, my first post. I have identical tables in my db. Is there a way to create a view with dynamic query to combine/union all the identical tables into one view? dbo.table.x-1 dbo.table.x-2 dbo.table.x-3 dbo.table.x-{n} |
| | how to insert system current date by using sql query in SQL SERVER 2005 |
| | danni web has been a great help to me i want just one more help i am able to connect to MSSQL present in my localhost using wamp but i am unable to connect to my MSSQL running in a pc with ip 123.xxx.xxx.xxx can u guide me on how … |
| | Good Day All I have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = … |
| | Hello everyone, I searched extensively but was unable to find a solution to this problem. I'm attempting to generate the CREATE STATISTICS statement that was used to create an already existing statistics in an MSSQL db from its name or the table's name. I'm able to obtain the columns and … |
| | Hi, I hope someone can help me creating a sql for the purpose i have. I have a table named case_score_t with these columns: id, case_id, user_id, score, created_date I am interested in picking the rows with the greatest created_date, for a certain user_id. I now this SQL with give … |
| | hi, how the way backup database in sql server 2000 with syntax sql for one month, i mean query. Thank's |
| | Hi, I am doing a student progression system where the application is able to keep track of student marks. I have a problem currently and I've been spending nights on this. Let me briefly explain. Marks are calculated based on their hurdles. So for instance, H1 = xx%, H2 = … |
| | In the view below, I need the line "[COLOR="Red"]isnull(wwr.packed_qty, isnull((select sum(qty_on_hand) from lot_loc where item = coi.item and loc like 'P%'), 0)) packed_qty,[/COLOR] " to include a "[COLOR="red"]or 'S%[/COLOR]'", so that both P and S are found, but I get a syntax error when I add it. What is the … |
| | how can i find the table names from Sql server. what r the statement. |
| | it seem my connection string doesnt work? [code]$connect = mssql_connect("192.170.10.798","sa","gasd") or die(mssql_error()); $test = mssql_select_db("banex", $connect) or die (mssql_error()); [/code] whats wrong with my connection string? |
| | Good Day All I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First … |
| | Hello, Ihope to find some help in here, i have the following diagram [URL=http://img143.imageshack.us/i/13503390.jpg/][IMG]http://img143.imageshack.us/img143/6704/13503390.th.jpg[/IMG][/URL] and i want a query which return Emp_ID, Pro_ID note; i can get these values but by 2 queries as the following; [code=sql]select Pro_ID from Projects where Dep_ID in (select Dep_ID from Departments where name = … |
| | What is the best way to generate a set of dates based on today's date? Essentially, what I wanna do is: 1. Get Current Date 2. Populate a table with future dates 6 months apart and go up until I reach, let's say, 12/31/2020 I have looked at some of … |
| | hi guys, I have 2 tables, one called neworders which stores the part_id and num or parts and a 2nd table called parts which has all the part details including cost. tables are as follows [code] neworder part_id(primary key) number_of_parts parts part_id(primary key) 7-8 more columns, eg size, desc, sup … |
| | I have the next query, but it doesn't update when I have but of a product with the same code in the table detallefacturas UPDATE dbo.Kardex SET dbo.Kardex.SaldoDocumental = dbo.Kardex.SaldoDocumental + dbo.DetalleFacturas.Cantidad FROM dbo.Kardex INNER JOIN dbo.DetalleFacturas ON (dbo.Kardex.CodigoZofriID = dbo.DetalleFacturas.CodigoZofriID) WHERE dbo.DetalleFacturas.FacturaID = @FacturaID for example. DetalleFacturas Item CodigoZofriID …  |
| | |
| | Hello All, I'm very new to the world of php, js and ajax however I've been working on creating two combo boxes built from values in a table. The table is such - LeagueCode, TeamCode, TeamName. The first combo displays all distinct LeagueCode values. The second combo then needs to … |
| | Hi... I want to write a IF Condition as follow: [CODE]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[abc] AS SET NOCOUNT ON; BEGIN Declare @add = 0 as int Declare @change = 0 as int Declare @remove = 0 as int Select abc.value as 'Name' if (History.OLDSTR == … |
| | I have to connect remotely to my MSSQL database. However, I am a little unsure as to the best way to do this. Can I connect directly to the database from my client machine, or would it be best to create some kind of local script that does the connection … |
| | Hi Guys My hosting company confirmed that recently it appeared that somebody was trying to hack into my website. I was able to confirm the page used but not whether they actually got through - no data in the database was changed. I have never come across this before and … |
| | Hello, I would like to know if there is an easy way to transform the following table CarId | PropertyName | PropertyValue 1 | Size | XL 1 | Name | Porsche 1 | Color | Red 2 | Size | XS 2 | Name | Smart 3 | Name …  |
 | Hi I developed report using sql server reporting service.I used parameter to assign value for sql query.I want to use "LIKE" keyword in using parameter,How i do that?i wrote coding below what u wrote before.I used @con as parameter. [COde=sql]Select FriutID from Friut where friutName like'@con'%.[/COde] Once I write above … |
| | Hi, i have created a sp, that is taking too much time (more than 35 sec, is it more?). [Code] SELECT top 11 ROW_NUMBER() OVER (ORDER BY hjs_job_details.date_posted desc, KEY_TBL.RANK desc) AS Row, job_id, (case when len(job_title)>59 then (substring(job_title,0,59)+'...') else job_title end ) as title, company_name as Source_Org, source_company_name as … |
| | I need to know how and what steps to automate to backup a database on my production SQL server and restore that database in my test SQL server. The database exists in both servers currently. I want to set this up so it will run every day at a certain … |
| | I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this … |
| | I have a table for example: tb1 with data: [CODE]cse-12m cse-343k cse-mka cse-ptu cse-jpy[/CODE] How can I write a SELECT statement to retrieve data in one of these formats: 1) cse-three digits number 2) cse-p% and exclude other format data, any idea? |
| | I want to display the columns in to rows format as below: eg: [U] col 1 [/U] [U]clo 2 [/U] yes No I want this to display as: [U]Column name[/U] yes no The Code which i used as below: [code=sql]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create PROCEDURE [dbo].[Vista_Capable] AS … |
| | Hi,,.. Need hlpe on this. I have 2 columns Oldvalue and newvalue. I want to create a store procedure where the query will be as if oldvalue and new value have record, but both the records are not same then 'change' variable should increment by 1 for each computername, again … |
| | I'm using this piece of code to get the number of search results. However it says- Incorrect syntax near ')' (the very last ')' ) [CODE] SELECT COUNT(*) FROM (SELECT ID, ProductDescription FROM Products WHERE ProductDescription LIKE '%tech%') [/CODE] The inner select works fine and gives correct results, so I … |
| | Good Day all it is Probably a long day, i cant think Straight now. i have a table that looks like this [CODE] Nodeid Parent Description Type Curr ========================================================================================== 89 NULL Compulsory 1 10 90 89 B1052 3 10 2820 89 One of 2 10 [COLOR="red"] 4113 89 B1061 3 … |
| | hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks … |
| | Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will … |
| | Hi, First of all, I'm no database expert. See me as managing a project where this problem occurs. We are building a system that will enable us to roll out Windows Patches automatically to all Windows systems we manage. We use WSUS on SQL Server 2005/SQL Express. The application will … |
| | Hi, I have 2 tables that I have made using sql create table which seem to work ok until I try to insert data into the 2nd table then it throws a: didn't add 1 record due to key violations. When I use the design wizard and do exactly the … |
| | Hi to all , I am developing website in asp.net2.0 using VB. I wrote sored procedure, [code] ALTER PROCEDURE SELECTSC ( @cid INT ) AS BEGIN SELECT sc FROM collage_detail WHERE c_id=@cid END /* SET NOCOUNT ON */ RETURN [/code] and in vb I wrote on button click, [code=VB] cmd.CommandType … |
| | Hi, having a problem with Firefox automatically unwanted windows with advertising - often with unsuitable content for my son, so very annoying. I ran HiKackThis and here is the logfile - can anyone help. Thanks Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 8:04:31 AM, on 10/8/2009 Platform: Windows …  |
| | I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how … |
| | I have a table in which I have an auto-increment int ID column. Can I set this column to pad the zeroes at the beginning so as to store them as, say, 0001 instead of 1, 0002 instead of 2, and so on? Subsequently, when the table reaches 10 entries, … |
| | Hi, i have created a window service with multithreading, but getting many deadlocks on sql in one Stored procedure when i start this service,and after that service does not do anything but in idle mode. the details of exception is below. Error :Wednesday, September 23, 2009 2:22:58 AM Method:UPD_CrawlerLastUrl 1. … |
| | Guys, I need your help as I really can't seem to start on this query.I seem to not be able to come up with any logic. I have to create a query for a table. I have two tables in my DB . First one is a book table which … |
The End.