I'm a MSDN subscriber and recently installed SQL 2005 developer edition and noticed it installed a version of visual studio. I'd prefer to install VS pro edition seperate from SQL 2005. Should I install SQL 2005 Standard version instead of developer edition and then install Visual Studio Pro ...more >>

Hi all, I have a table with several rows, each has a datetime field. I want to query this table, ideally with my stored procedure and return just a set of month names/numbers if possible, but I keep going around in circles either getting ALL of my dates back with the names in a new column,...more >>

Please suggest links, docs as to how should I transfer data, user information from SQL server on Winnt to SQL on Windows 2000 server. Thanks Pradeep ...more >>

I need to create a "Select" statement for the "TOP" x to y number of the records in the query. I know I can put in like "TOP 10" and it will return the top 10 number of the record. However I want to be able to return a range say Top 20-30 number of the records or Top 30-50 number of the record...more >>

We have a business Logic component which imports into multiple tables from a variety of flat files. To reduce the length of a lock being held on the tables we were considering that each dependancy tree be first attempted in a single transaction and rolled back. Once all have been through the ...more >>

Please suggest links, docs as to how should I transfer data, user information from SQL server on Winnt to SQL on Windows 2000 server. Thanks Pradeep ...more >>

Hi, I've included the necessary scripts to generate tables and insert sample data at the bottom of this post. Here are basic descriptions of 4 tables I included in my scripts: tblCompany contains all necessary information about our clients i.e. company name, phone #, etc. tblDeals co...more >>

Hi all, SQL Server 2000 and T-sql, uk date formats I have a table, thetable. One of the fields in the table is tran_date which has type of datetime. I have to run a select on the table twice a year. Once after 31st Dec and once after 30 June. The select after 30th June must select ...more >>

Hi All, i have a case in which i want to match records in table which should be start with a word, which i'm storing in a varchar varaible. How could i do this?...more >>

Hi All, Problem statement: Group 2 tables. B(B_ID,B_DES) C(C_ID,B_ID,C_BY) select B.*,C.* from b bx inner join cx on bx.b_id=cx.b_id group by B column,,C column Output: B_ID column | C_BY 1 we 1 xy 2 DF Above result ...more >>

We have to design a database for UserInfo. We already have a user table, and contains userid. There are three user type(ex. student, teacher,admin), they have their own tables. i don't know how to add the personal infomation field. One way is putting some common field into the user table, th...more >>

I would like to change the data type from date time to timestamp and nvarchar(14) to nvarchar(20). Are there any impact to change a live database? Thanks millions in advance,...more >>

hello check this sp CREATE PROCEDURE dbo.sp_Inserta_bf_PlanOpcionSeleccionBR ( @IdPlan int, @IdPlanOpcion int, @IdGrupoParentesco int, @IdEmpleado as int, @IdAsegurado as int ) AS DECLARE @SqlText varChar(2000), @Result int SET @SqlText=ISNULL((SELECT RTRIM(SqlText) FROM bf_...more >>

I am using SMO to create a database. I use the datafile and logfile objects to define the data and log files. If I use the sqlserverobject.Information.MasterDBPath as the file location it is able to create the database. But if an attempt is made to locate the datafiles in another folder, ...more >>

I have a database running with Full Logging. Now I would like to have that database copied to another one, together with the full log. Roll back the log (in the copied database) for 6 days and then copy a table to the original database. How do I best do this? In steps? -- Thanks in adv...more >>

how can i parse NameSurname field with t-sql ??? NameSurname --------------------------- John SMITH Eric Smith PHILIPS Name Surname ----------------------- ------------------------ John SMITH Eric Smith PHILIP...more >>

I've noticed that some search queries on e-commerce sites return "item price range hyperlinks" as filters for matched items. So you would have something like: Under $50 $75-$100 $150-$250 in a row with only the applicable price ranges to the queried products showing. So, with the abo...more >>

hi there, please help me !!! what is wrong ??? SELECT CARI.* , IF(CARI.CH_UNVANI = '', 'EMPTY' ,CARI.CH_UNVANI) , TBLSYSCHTURU.TUR AS CH_TURU FROM TBLCARI AS CARI LEFT JOIN TBLSYSCHTURU ON TBLSYSCHTURU.CH_TURU_ID = CARI.CH_TURU_ID ORDER BY CAR...more >>

Hello there On the execution plan i see sometimes Bookmark lookup, who takes a lot of presantage of the query execution What that meens and how can i reduce it? ...more >>

Hi. There are two webpages in my website. one displays 10 articles last updated and another one displays 6 articles last updated. So I want to use only one procedure to do this, and wrote the following code: CREATE PROCEDURE [dbo].[articleLastUpdated] ( @nNumber smallint ) AS SELECT T...more >>

When I delete rows from a table that contains an NTEXT column, I get a delete capacity of 100 rows per second. I think this is slow. How can I make it delete faster? The average size of my ntextcolumn is 22.000 bytes. Max size is 132.246 bytes When I populate the same table with BULK INSE...more >>

Hello there I got sql database to optimize it. On one of the table has identity column which is the primary key There are also 6 main fields that most of the actions on the server are using them to locate data. and this table has 500000 records and more On the beginning the primary key w...more >>

Hello, I'm using bcp insertion with ODBC from memory variables, but my code is for customer databases that can add his own columns to every table. When people add extra columns to the tables where I do the insertions by bcp, the bcp_sendrow call fails. I've tried the control option BCPKEEPNULL...more >>

Hello Guys, I am completely familiar with DTS and database programming and I'd like to start learning about Yokun version .Which books do you suggest for Analysis services and SSIS and Sql server 2005? Thanks ...more >>

If I have table with data: ID STATUS 1 1 2 1 3 2 4 3 Can I do this: SELECT COUNT(STATUS = 1), COUNT(STATUS = 2), COUNT(STATUS = 3) FROM MyTable or I have to execute select for each status: SELECT COUNT(ID) FROM MyTable WHERE STATUS = 1 SELECT COUNT(ID) FR...more >>

Hi, I have three tables child, room & toys (crude example) - A room has many toys - A child has one room - A child has one toy. I want to ensure that a child can only have a foreign key value for a toy that is assigned to the foreign key value of room they select. I was thinking of us...more >>

This query returns 2 mediaIDs: SELECT TOP 1 WITH TIES mediaID,count(mediaID)as sumMedia FROM tblMedia GROUP BY mediaID ORDER BY sumMedia DESC This query returns 0 mediaID's: SELECT TOP 1 WITH TIES mediaID,count(mediaID)as sumMedia FROM tblOrders GROUP BY mediaID ORDER BY sumMedia DESC ...more >>

Hi, I have a table that contains a simple collection of rows, the rows have the following fields... URN, Year, Period, Cost, Value As an example, the data is as follows... 2005|08|089.32|123.45 2005|10|056.68|045.68 2004|10|156.32|068.23 2005|11|123.56|548.12 2005|11|078.23|569.12 ...more >>

Hi all, I've created a stored procedure with parameters to create 40 tables with the same structure.From VB6 i pass the name of the table to be created from a cmd command. ===================================================== CREATE PROC dbo.CreaTabelleFondi @tablename VARCHAR(6) AS DECL...more >>

Hallo! I wondered if anyone can help me with why there is a N' in front of so many of the expressions in create statements? Like this one. CREATE XML SCHEMA COLLECTION DeliverySchemas AS N'<?xml version="1.0" ?> Thanks! H ...more >>

Hi. I have to replace substrings which are between two characters. For example: I have to replace or remove all the characters that are between ' \': So, i have the string abcde\fgh\ikl and i want to get: abcdeikl. I use the following select statement: REPLACE(ColumnName, SUBSTRING([Colu...more >>

It is possible to import or export data to Excel using OpenRowset. I want to delete Excel data before inserting data to it using OpenRowSet, I get this error Server: Msg 7345, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' could not delete from table 'SELECT * FROM [t$]'....more >>

I have an SP that produces some summary figures, including count() and sum() values: Select (Select Count(*) from OrderDetail D inner join Orders O on O.OrderID = D.OrderID inner join Invoices I on I.InvoiceID = D.CleanInvoiceID Where I.InvoiceDate >= @DateFrom and I.InvoiceDate <= @...more >>

Hello, How could I get a result with the following code? BEGIN DECLARE @raws int SET @raws = 10 SELECT TOP @raws * from Table1 END Thanks, GB ...more >>

Hello, I have a table with stock values, they are grouped by a stock id. now I want to get the trend of each stock. I only need this for one value per week for one month. for example: stockid price 1 20 2 10 3 5 1 21 2 9 3 5 1 ...more >>

How can I force some data maintenance statements whether the transactions success or failure? The case is as: When the insert statement to do, the insert trigger will execute, when the triggers has errors, then the triggers should write the custom messages to the another tables and then ...more >>

Hi! How can I do to debug a Stored Procedured? Thsnks. ...more >>

Hi, Can any please shed some light on the following problem or direct me to an information source ? DELETE remoteserver.database.schema.table returns the following error message. iServer: Msg 7345, Level 16, State 1, Line 2 OLE DB provider 'MSDASQL' could not delete from table '"S1031...more >>

Hello, I'm using SQL 2000 with the latest updates. I have a large table Call_Record (5 million rows) that has three indexes: 1. A clustered index on account_no ASC, date_start DESC 2. A non-clustered index on date_end DESC 3. A non-clustered index on call_record_id ASC I'm querying it for...more >>

I'm running a job from a schedule which runs a .vbs script In this script I have the following script to include another file Function GetFileContents(sFileName) Dim FSO, ScriptFile Set FSO = CreateObject("Scripting.FileSystemObject") Set ScriptFile = FSO.OpenTextFile(sFilename...more >>

Hello there On the execution plan i see some times Table Spool What that meens, and is there a way to reduce its action? -- øåòé âåìãäîø òúéã äðãñú úåëðä èì' 03-5611606 ôìà' 050-7709399 àéîééì: roy@atidsm.co.il ...more >>

Is it best way put all the validation rules on insert/update/delete stored procedure? When the failure happen from the validation rules, it will return all errors to client. ...more >>