2,935 Topics
 | |
 | Hey guys so for a class of mine we have to build a program for a client that is going to require a Database. The database is going to be purely for demo purposes so an actual server is not necessary. Now I have never done this before and I … |
 | CREATE TABLE Contain ( Disk_ID int NOT NULL, Artist_ID int NOT NULL, CONSTRAINT Fk_Disk_id FOREIGN KEY(Disk_ID) REFERENCES Disks(Disk_ID) ON DELETE CASCADE, CONSTRAINT Fk_Artist_id FOREIGN KEY(Artist_ID) REFERENCES Artists(Artist_ID) ON DELETE CASCADE, ) I have a Home Music Managment Database and software to work with it. I have 4 relational Tables i …  |
| | Hi guys... I am developing an windows application in c# with sql server as back end with windows authentication i want username and password for sequrity purpose can i set username and password without changing it to server authentication. Thanks in advance. |
| | Hi Guys, My project is in Java and i am using sql server 2005 database and my requirement is as follows for database ----- sql sever is in windows authentication mode ---- suppose my database name is db1 then **can I create password for my databse db1 in windows authentication …  |
| | Hi, Needs to construct the tables with the meta info retrived by another stored procedure I wrote, given the table id or name. There could be some flaws in the logic, not sure. The flow is - - iterate through one table which stores tbl name, id info - pass … |
| | Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting …  |
| | hi, SELECT Sum(acpt_qty),mat_code1 FROM view_mrir_esd GROUP BY mat_code1 SELECT Sum(net_qty),mat_code1 FROM view_bom_total GROUP BY mat_code1 these 2 queries are giving the actual report, but when combining these queries like SELECT DISTINCT view_bom_total.mat_code1,Sum(net_qty),Sum(view_mrir_esd.acpt_qty) FROM view_bom_total inner join view_mrir_esd ON view_bom_total.mat_id=view_mrir_esd.mat_id GROUP BY view_bom_total.mat_code1 giving the wrong acpt_qty and net_qty. Please advise … |
| | Hi Guys, My requirements: How do I get the overall average for the transaction given for every month. My Query: This is the last part of my CTE Query ) Select Partno ,SUM(Case When TransMOnth='January' Then Usage2 else 0 End) As Jan ,SUM(Case When TransMOnth='February' Then Usage2 else 0 End) … |
| | Hi, I am building a database for an institution. However, I will love the database to intimate the operator of birthdays of those in the database using vb 2008 and sql server. My query for the sql server goes thus: select Surname, Other_Names, Mobile_Phone from Parishioner_Adults where WHERE day(Date_of_Birth) =day((GETDATE()+15)) …  |
| | G'day folks, My sql server 2012 database is plodding along happily with its custom online store. Yesterday it's primary key incremental column jumped from 60681 to 61678 then resumed incrementing by 1. It is now up to 61686 and chugging along again. No apparent harm done but very strange behaviour. …  |
| | I have table of three column like Identifier Description Value P1 x 20 P2 y 20 P3 x 20 P4 y 20 P5 x 20 P6 y 20 P7 x 20 P8 y 20 P9 x 20 y 20 x 20 y 20 x 20 y 20 x 20 y …  |
 | HI All, I have three tables tbl_category, tbl_subcategory, tbl_product . where categoryid is foreign key in subcategory table and subcategoryid is foreign key in prduct table. I want to show category and subcategory on home page menubar. I just reach upto display category on menubar but not able to get … |
| | The query below performs fairly quickly, however when hit by several visitors at once causes the SQL Server CPU to spike greatly. How would you rewrite this query to reduce the impact? SELECT * FROM (SELECT TOP 1 a.adID, a.type, a.position, a.image, a.altText, a.caption, a.link, isNull(v.viewCount, 0) AS viewCount FROM … |
| | I am trying to write a query to update multiple tables. Here it is: DECLARE @old_team_id AS int; DECLARE @new_team_id AS int; UPDATE Players SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE managers SET team_id = @ new_team_id WHERE team_id = old_team_id UPDATE draft SET owner_id = @newteam_id … |
| | Hello Friends, I need help to get the time value from MSSQL database to VB.Net Datetimepicker I have a datetimepicker but the custom format is set to HH:mm tt so that I can get eg 11:20 AM this value I have stored in database with the help of ` Label4.Text … |
| | Hi I have a real conumdrum here - I just can't expalin this behaviour!! A colleague has designed a view that contains the following : `CONVERT (nvarchar(4),YEAR(dbo.SYSFinancialYear.FinancialYearStartDate)) + N'/' + RIGHT ('00' + RTRIM(CONVERT (nvarchar(2), dbo.SYSAccountingPeriod.PeriodNumber)), 2) As YearPeriod` When you are in the design view, of the view and … |
| | REATE TABLE [dbo].[BiddingTable]( [cAuctionId] [int] NULL, [idUserId] [int] NULL, [cItemId] [int] NULL, [vcBidamount] [nvarchar](50) NULL, [vcBidcount] [int] NULL, [bidQty] [varchar](5) NULL, [vcBidtime] [datetime] NULL, [status] [varchar](50) NULL ) ON [PRIMARY] INSERT [dbo].[BiddingTable] ([cAuctionId], [idUserId], [cItemId], [vcBidamount], [vcBidcount], [bidQty], [vcBidtime], [status]) VALUES (10, 36, 21, N'93.6', 1, N'0', CAST(0x0000A05500F83B44 AS DateTime), … |
| | Hello Friends, I need to create a report for my project I am using Miscrosoft Visual Studio 2010 and the SAP crystal Report I am not able to set up the connection The SQL server that I am using is not coming in the drop down of the server part … |
| | Too weird but still I have a doubt.... I have two table.... -> OutpatientDetails -> InpatientDetails But the fieldnames are same except for the ID....i.e. OutPatientID and InPatientID respectively..... I want to combine both the tables and produce one output.....I dont know whether it is possible or no.... I want … |
 | I have been searching for the answer for 2 months, but still no success. Below the setup and connection string and all checked already. Firstly my errorlog file error = 18456 Severity 14 State 11 (Login failed for user OLDPC/GUEST. Token based server access validation failed with an infrastructure error. … |
 | hello ! i am working on a simple grid , i create 3 columns name , A B C , manually , now i have a table having three fields A B C , i want to show Rec A in A col , B in B Col and C …  |
| | I have been working all day on sql developer but now i am trying to work again and when i try to connect it is giving me the following error what shall i do? oracle.javatools.db.DBException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdevimpl.db.adapter.CADatabaseFactory.createConnectionImpl(CADatabaseFactory.java:66) at oracle.javatools.db.DatabaseFactory.createConnection(DatabaseFactory.java:534) … |
| | **I have been automatically collecting machine breakdown info to a database for 12 months, so I have thousands of entries in a 'Machine Downtime' table. However, I have found that the time_down column is offset by one row. The 'time_down' in the top row needs to be moved to the … |
| | Trying to do Parameters for Report in Reporting Services from a database that's in mysql . My Where clause looks like this: Where HD_TICKET.HD_QUEUE_ID="6" WHERE HD_TICKET.CREATED BETWEEN [Start Date] AND [End Date] GROUP BY (HD_PRIORITY.NAME) I get this error: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.54-log]You have an error in your SQL … |
| | Hello everyone, im doing a small program where i have a stock table with my Items and the current stock status. How do i substract from that stock status when i insert a new order in my ordertable. My tables are: STOCK: Item_ID Stock status ORDER Item_FK: Qty So i …  |
| | Greetings everyone, I'm having a problem on displaying my picture on the image box. Instead it displays the picture on the image box, it opens a web page and displays it there. Here's the code conn = New SqlConnection("Server=Jeiku-shin-pc;Database=EnrollmentDB;Trusted_Connection=True") Dim cmd As SqlCommand = New SqlCommand( _ "SELECT * FROM …  |
| | Good evening guys, I'm having a problem on my web page. I'm trying to store a data on my mssql but it's not saving anymore. but it was working perfectly this morning. it doesn't display any error so i don't know what happened. Thanks in advance. |
| | BIDS 2005 DEV Ed I am working on a simple SSIS Package that parsers through a folder and uploads certains flat files data to certains databases. TextFile syntax example: CustomerData1213.txt;CustomerData1513.txt;CustomerData3313.txt;CustomerData1323.txt I am using a sql task that pushes file names from a table to the foreach loop (ADO Enumerator). However … |
| | For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized … |
| | I have an ssis package the loops through an entire folder importing records into a sql 2005 database. I pull these records from a table in my database through an "execute sql task" then that gets pushed into the foreach loop container. However when one of the filenames is missing … |
The End.