2,935 Topics
 | |
| | Hi gurus, I got a pre-formated excel sheet as destination. The header is formatted with color. The requirement is to populate the excel sheet with different data type (name(string), no (int), sal(int), age(int)) from second row onwards. The source data is a SQL table and I am using SSIS to … |
| | I have below query inside sp. select groupno,a from table1 where groupno <> 'Test' It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help thank you  |
| | Hi there, I am a new member of this site and I am not very much aware of T-sql's working. My question is what if I need to get one column's data to be the heading of another column. To be very exact I have a school's database. The table … |
| | I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports . I wrote a sp like this:[code] ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails] ( @paramdate datetime ='02/01/2007' ) as -- select EmpID,EmpName,month(DateOfBirth) bmon,day(DateOFBirth) bday … |
| | Hi I have 3 tables in my database. 1) [B]photo[/B] 2) [B]category[/B] 3) [B]subcategory[/B] in my photo table i save my subcategoryid which is tied to the category table. What i need to do is get the all the subcategoryname from subcategory table where photo.subcategoryid='1' and photoid='2'. I can actually … |
| | Hi to all, I am new to Daniweb and I'm already impressed with the wealth of information available. With that in mind I did a search through the forum but did not see a solution to my problem. I have a couple of machines on the same network. ONe of … |
| | Hi friends, I'm creating a website for my college project. on clicking submit button on the feedback form, i want to retrieve current date and then store it along with entered details in the MS SQL database. I don't know how to do it. Can you please help me? I'm …  |
| | we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005. But we have some permission issues for … |
| | I'm stuck here. Please Help me! I've created a feedback form which takes name, Email Id & Comments from users. On submit button, i want to save the entered details along with the current date to the UserDetails table, so that, when admin logs in and wants to see the …  |
| | I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use dbms_lob.writeappend, I am getting the following error..Command text was not set for … |
| | what is the required t-sql for getting all the child categories in a parent category? my table is like this : id | name | parentid |
| | Hi, When i change my function, change the return itens (when it returns a table), i lose grants that i had on it... Exemple: [code]alter function dbo.up_xxx (@cod_instc int) returns @teste table (cod_instc_usr int, COD_INSTC_prod int) AS BEGIN return END[/code] Is there a way not to lose it? Thanks |
| | I have question about TRIGGERS. I have (4 example) VEHICLE_TABLE with VEHICLE_TYPE column and CAR_TABLE and TRUCK_TABLE also. I need TRIGGER for INSERT/UPDATE/DELETE who well read value of VEHICLE_TYPE column in VEHICLE_TABLE and if value of VEHICLE_TYPE is CAR he will execute INSERT/UPDATE/DELETE on CAR_TABLE and if value of VEHICLE_TYPE … |
 | sorry if this a very newbie question but what wrong with my code : [CODE=MSSQL]select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier where TBIn.SupCode=Supplier.SupCode and TBIn.IdBrg=Barang.IdBrg and TBIn.IdBrg = B002[/CODE] Please Help, Best regards...  |
| | Hi, I'm a bit stuck here. I have a table called STM_COMM and it contains following fields: id, member_id, email_addr, tel_nr, fax_nr A member can have multiple email addresses, telephone numbers and faxnumbers. so we could have something like this: id member_id email_addr tel_nr fax_nr ---------------------------------------------------------------- 1 5 info@test.com 2 … |
| | Hi, this is my first post. I have a website [URL=http://www.psychopanic.com]www.psychopanic.com[/URL] and theres an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL. … |
| | Hi All ! I want to use the returned value of user defined function of source code(VB.NET) in Databases( MSSQL) is it possible to throw the returned value of user defined function of source code into databases? Kindly Help me in this regrads plzzzz ... its really very urgent ! … |
 | hi All i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this [CODE] Lis_key ===========Attrib_code========================= Func_key====== ===================================================================== 01424545 1212033993 PV000000 01424545 Null GEOSS001 01424545 Null GEOSS002 01424545 Null GEOSS003 [/CODE] Figuire:1 Now … |
| | I am not a developer or especially knowledgeable in MS SQL, but I am the person responsible for creating special queries for my companies SQL Database. I have a query that is selecting customer names, addresses, product ordered and e-mail addresses. I am want to select only those customers with … |
| | this is the questions i faced in an interview i am new in .net and sql so anyone knows this ans please inform me thanks *Can we have an updateable view in SQL? *What is the difference between stroed procedure and stored function in SQL? *What is connection pooling? how … |
| | Hi all, This is my first time... and i'm not an sql guy by any means, but i can insert, update, blah blah... I have a question to ask, i have a table that has UniqueInt | Date1 | int1 | Date2 | varchar 1 I have duplicate records that … |
| | How do you write a store procedure to meet the following conditions: PROXIMITY SERACH PROCEDURE COMPANY table PK company_id int company_name varchar(100) premise varchar(10) street varchar(30) town varchar(100) postcode char(7) x_loc int y_loc int COMPANY_KEYWORD table PK, FK1 company_id int PK keyword varchar(100) The data above shows an extract of … |
| | I am trying to dig data from a table that has a field named begdate and another one named enddate. They hold obvious values, but I need to have the query find the record that has a begdate that matches whatever the previous Sunday was to the day the request … |
| | Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …  |
| | How do I create a single sql statement that will insert a row into a data table and return the row number back for processing? I tried to use the scope_identity method and find out it works well within a stored procedure environment. If anybody out there have another method, … |
| | Hey I've set up a maintenance plan to backup databases daily and noticed the following error in last night's backup - Database 'BizTalkEDIDb' is not valid to be included in the maintenance plan. Has anyone seen this error before or have any idea what it could mean? Thanks in advance. … |
| | |
 | I am using SQL Server 2005 to run a stored procedure to update, delete, or insert depending on some conditions. The problem is that it gives the following error: Msg 4104, Level 16, State 1, Line 49 The multi-part identifier "PART.ID" could not be bound. I have it inserting some … |
 | Can anyone please tell me how can i copy a table. thank you. and also how to fin out the second highest value of a field in a table. eg. select the employee cashing in the second highest salary in the company. Thanks a lot. |
| | Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select … |
The End.