I have one table in database in which millions or records exest already. I can't change the structure of table. And i have to create 4 store procedure each of them will fetch 100 records from this table. And they will keep going on. But condition is that they should not fetch same row. how can all store procedure fetch uniqe data from table.
I have this table structure, and I can pull ot all I want like product details, color, size and so on. Now I want it to work like this. When I select a color only sizes avalible in that color should be returned from the database, and same thing when I select a size only colors avalible for that size should be returned. NOw it works like price and quantity sets to zero, but it should have been better if it was impossible to choose a combination that don't exists.
Then I have one more. SizeId and ColorId can be null in db. That is not good when I try to receive those rows.
I have inherited a piece of code that is a bit of a pig. It uses a cursor to loop through a list of stores and count customers. I would like to change this to use a CTE, but am not sure how to configure it.The basic functionality of the SP is:Declare variablesSet up start and end datesDeclare CursorGet a list of stores to checkOpen the CursorWhile... Loops through the stores Insert a new record into the Destination Table Count up the new customers for this store Count up the returning customers to the store Update the new record with the totalsLoopThe code:
I have a series of SQL database tables but would like to be able to have a table entry that can support a list of primary key's for another table - how I can do this?
I want to know what the easiest way is to copy one database structure to another blank database. I want tables, stored procedures and functions copied over but none of the data within the tables. I can export it...but then all the data also gets carried over, which I don't know. What would be the best way to carry this out?
i have a table with parent-child relationship wherein each child in turn can have multiple associated children. i want to display data in an hierarchical way with collapse and expand features.i dont want to use 'listview inside a listview inside a listview' approach. and yes i have googled it but cudnot find anything useful for my scenario. has someone successfully tried implementing this ?
I want to pass the Array ( object[]) or Structure data type value to the store procedure through ibatis .net. I can do same by commandtext using SQLDBType.Structure. I am using Table value function in sql server 2008 and .Net 2010.
suppose i have few fileds in table and one filed is xml type. how to search this.
the xml which is stored in my xml filed like
<OpenShipments xmlns="x-schema:C:UPSLabelOpenShipments.xdr"> <OpenShipment ShipmentOption="RS" ProcessStatus=""> <ShipTo> [code]... we can query sql server data very easily but i dont know how to query the xml data which stored in xml filed.how to query address field in my xml or how to query Options field,how query CompanyOrName. please help me to construct the sql. guide me in detail with few sample for querying xml datatype.
my stored procedure is always extract some data into temp table such as"select name,address,content into #TEMP1 from table1,table2,table3" finally, select another table together with #TEMP1 to extract all desire data from one queryselect T.name,T.address,T.content,C.other from #TEMP1 T, otherTable C where T.ID=C.IDI would like to ask if i want to join one more table T2 into final query with "otherTable left C outer join on C.ID=T2.ID"
I have an ASPNET application written in VB.NET which resides on the company's intranet. I am trying to do a bulkcopy from an excel file which is located in a secure folder on the web server to an existing table in Sql Server. The problem is that the folder requires a user name and password which is not the current logged in user or the ASPNET user. My question is how do I logon to the folder so that I can access the Excel file.
I would like to know which one is better, table-valued function or View, in terms of perfomance.Earlier I have created view which is performing cross join (which takes time) and 2/3 Left outer join and it's taking time. To reduce execution time I have created table-valued function with parameter to reduce cross join execution time and it returns the same result as view.Just give me an idea about table-valued function and View, in terms of perfomance. Which one is better?
I want to transfer temporary table from one server to another linked server. I want to transfer it like how Bulk insert does. Right now I'm transferring row by row. It should do bulk transfer.
I m getting following error in my eventvwr . I couldnt find reasons of the following error.
"Transaction (Process ID 110) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
The only thing my page is doing is inserting/updating data into a table in sql and the thing I can think of is because multiple users are using the same page to insert/update data? Will that cause deadlock?
I want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?
I'm a beginner with ASP.NET. I'm using SQL Server2005 Management Studio. The problem I facing is arises when I tries to run any query,even the simplest, it doesn't identifies the table. as below:
using VWDExpress2010, is there a way to print the table definition for an SQL table that has been created within the designer? I would like to begin using SQL databases for more of my projects but find the difficulty in working with the tables (compared to other options) to be such a pain that I usually choose some of the other formats. Typical problems are simply documenting the structure, moving data in and out with some form of command line feature, etc.
i have an aspx page which has a fileuploader and a button
initially i have to browse the file and after browsing the file i have to check the extension if the extension is xsl or xslx then only i have to enable the submit button
once the submit button is enabled i have to insert this data into the table
and i have to display the number of succesfully inserted rows and no of unsuccessfull insertions .
success and failure is dependent on the mismatch of the datatype between the excel sheet and the database column
