2,736 Topics
 | |
 | 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 …  |
| | |
| | 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 == … |
| | 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 … |
| | 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 … |
| | hi guys, done heaps of googling and everything leads me to two outcomes. 1. You can't do it 2. You can do it this way [code] INSERT INTO User(userEmailAddress, userFirstName,userLastName,userStatus,userNickName,userMifrenzPassword,userEmailPassword,userDOB) SELECT 'overthehill@gmail.com','Ben','Hill','U','benny','milk','soccer','20-10-2000' UNION ALL SELECT 'smithy@gmail.com','Tony','Smith','A','smithy','bread','rugby','20-11-1976' UNION ALL SELECT 'hotpants@gmail.com','Sarah','Jane','U','hotty','toast','netball','15-1-2000' UNION ALL SELECT 'traci@gmail.com','Traci','Hill','U','raisins','coffee','hockey','20-10-2000' UNION ALL SELECT 'lol@gmail.com','Ben','Johns','U','stubby','jam','rowing','10-2-2001' UNION ALL … |
| | Hey Everyone, So after weeks of torture, this things is near completion. We're using SSRS to display the report on the .NET side. However, I'm piecing together the last bits of the SQL query. So, I have three tables. One has names of all these buildings, one has contains reason_codes, … |
| | i am constantly receiving a 'failure audit' error 18456 state 14...login failed for user 'sa' on my sql 2005 server. this is occurring every 5 minutes. Can someone give me a direction on where to start? I have checked several forums on the web, but none seem to lead me … |
| | Was just wondering if anyone here is an Access master have this code that I want too add a CHECK too but keeps on throwing a syntax error [code] CREATE TABLE Email ( userEmailAddress memo not null, timeDate datetime not null, contactEmailAddress memo not null, emailBoxType text(6) not null, readStatus … |
The End.