3,481 Topics
 | |
| | I created an instance and did some fault while moving the files from one location to other and now the server doesnt start and i need to execute a query in SQL SERVER Management studio in order to open a new query feature it again ask to start the server..the … |
| | Guys, Using this query, i got an error. any idea guys. what method should i used for this report. Im using text queries instead of SP. thanks. The variable name '@FromDate' has already been declared. Variable names must be unique within a query batch or stored procedure. Fromdate:'2012/06/01' FromTime:12:00AM Todate:'2012/06/29' …  |
 | Hello, I want to make a connection to MSSQL 2008 database, using Visual Studio 2010, ASP.NET C# web site I wrote this connection string in web.config file: <connectionStrings> <add name="konekcija" connectionString="data source=.\SQLEXPRESS;Initial Catalog=Movies;Integrated Security=True;" providerName="System.Data.SqlClient" /> </connectionStrings> Now I need to call that connection on a code behind the page... … |
| | I have two tables. One with orders and one with lines items for the orders. The line items have a unique code that relates to the line item number. When sorting on this unique code, you are able to see the order in which the item was added to the … |
| | Ohayo I Hav a Doubt regarding the storage of database.. Suppose i have a college database...among Master Model Tempdb MSdb were do i store this college database??in master?? even if i create a new database how to add the new data into the existing database??  |
 | 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 … |
 | hello ! i am using mssql server 2008 , i have a table with three fields , 1- ProdID 2-ProdName 3-ProdPic , now i want to show the all records of the table in the datagridview by using vb.net , how can i show my image field in datagridview , … |
 | 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. …  |
| | hello ! i am new in c# , i have images in my mssql table and i want to show those images in the datagridview , i add a column type image , but i am not able to show images in it , please help me in this . …  |
| | 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 … |
| | Hi all I've been struggling with this one for some time now and I would realy appreciate some help. I have a string which gets data from mssql server, reader collects data (among others also "person) SQLStr = "select * from tablename order by id desc command = New System.Data.SqlClient.SqlCommand(SQLStr, … |
| | 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 … |
 | yow! I have a question. the case is have and email notifacation in my php code in the database(MSSQL) i put an email add these are the two email address Rex.Cam@email.com and rex.cam@email.com the email notication is intended for the email who has a capital letter on the start the … |
| | 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 … |
| | Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the … |
| | hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking … |
 | hello.... i create setup using vb.net 2008 with mssql database...... it is run on my machine without any error but when i install it on client-machin i got this error See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception … |
| | |
| | I have a table called Product. In the Product table we have something called ProductCode and NewProductCode. When we first built the tool we were anticipating the NewProductCodes to be coming down the pipe at a later date. So we added this column with NULL. So right now the DB … |
| | I have an sql table that stores English words and second table that stores meanings of those words in related maner. Here are some informations about table structures: Table1 name: Words WordID int IDENTITY(1,1) NOT NULL, //This is primaryKey Word varchar(50) NOT NULL, Table2 name: Meanings MeaningID int IDENTITY(1,1) NOT … |
| | hello every one , ! i have same prob as the user had in this thread [Click Here](http://www.daniweb.com/web-development/databases/ms-sql/threads/421214/remote-server-access) first i thought to post my question in that thread but then i thought it is better to open new thread . in above mentioned thread a user have prob to connect … |
| | I am trying to insert values from a table to another table. The thing is I want it such that only a row in the source table that does not exist in the destination table should be inserted. I have set each table to have a column that automatically increments … |
| | Good evening guys, i just want to ask if the dbname.ssmssln something is sendable and usable on other computer or not. because i created a database and my other friend wants to see it and i send the ssmssln file i just want to know if he can access it. … |
| | I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB … |
| | Two parted question really... First off, I've been trying to enable my SQL Server 2008 R2 to allow remote access so my friend can view it from his RDBMS (also SQL Server 2008). I've enabled TCP/IP, I've allowed Remote Access/Connection, I've opened TCP and UDP Ports and also added the … |
The End.