Hi all, I am having table which is starting with integer like '2table'.truncat table not working on this table. can anyone tell me reson behind this? thanks in advance. ...more >>

I'm interested in learning SQL Am I correct that it is pretty easy and therefore would be something that I could pick up on my own? What I've seen of it is certainly easy. Secondly, are there online sources for learning everything that I need for free? Are there any database emulators or...more >>

I have an Access .ADP connected to my S2K Enterprise server with SP3. The following code runs successfully on my system but not on my client's: SELECT * INTO ExcelTVData FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\NetLease\XL_Data\7347469.xls', [Sheet1$]) My S2K serve...more >>

Hello, I'm having trouble figuring out how to add the Business Intelligence Report Designer to my VS 2003 installation on a client machine. Any ideas how to do it or where to look? Thanks! Rick ...more >>

I have been writing programs in ASP, VB and C# for a number of years and I've used SQL Server quite a bit in my work. However, for the most part I've always done the database design myself so I never really had to deal with writing complex SQL queries. These past few months I've been taske...more >>

If I have a string of dynamically procedure SQL which will return zero or more rows in one table when executed, is there any way to get at those rows? Can I read the results into a temp table or a table variable in any way? All I'm looking for is whether any rows are returned, but @@rowcount w...more >>

I would like to SELECT a given row and then UPDATE a column in that row. I guess I'd need something like a SCOPE_IDENTITY() function, but one that works with SELECT statements. The following Stored Proc doesn't work, but illustrates what I'm looking for: SELECT @ID = SELECT TOP 1 * FRO...more >>

I have a table with Task, Cost, Start Date and End Date fields. I would like to calculate the average monthly cost for each cost and create a chart showing the total monthly costs for all of the tasks. The number of months between Start and End change for each task. Current table is something ...more >>

Hi, I am using SQL Server 2005 Standard & Expression. I have a stored procedure that extract image datatype data into MS Word file to a directory using BCP (appro. 100 files). Is it possible to modify these Word documents' Header (3 lines) of these 100 files from Stored procedure? Any ...more >>

Does anyone know of a good way to insert a row in a high transaction multi-user environment, but only when it (a certain column value) doesn't already exists? ...more >>

Is there a way to ignore a trigger (for delete) on a table when running a script that deletes from this table? Thanks in advance...more >>

does anyone have a handy function for sql server 2005 that will dynamically determine whether or not daylight savings is in effect, based on the current date? tia jt ...more >>

Is there anyway that I can program SQL Server Profiler Trace Template? For example, I can use the template in my C# to create the trace? TIA, Jeff ...more >>

hi, have an update statement from ms access, UPDATE TableB INNER JOIN TableA ON TableA.A = TableB.A SET TableA.Status = TableB..Status, TableA.S = TableB.S, This statement won't run in sql query??? ...more >>

On SQL 2005, there is an option under indexes called "Store Intermediate Sort Results in tempdb". Could this affect performance of a query? ...more >>

This is a general question about the best practices. My app sometimes needs to return a wide recordset over 300 records long. Most of the time, the user would find the result in the first 30 records. I'm trying to implement some sort of a paging solution in order not to transmit the entire rec...more >>

I'm still trying to finish a sproc that returns a table with ip addresses and computer names sorted by variables. CODE 2 DDL below correctly sorts by ip, but the ORDER BY part uses a sorting method that I don't believe can be used in an ORDER BY structure like I currently have in CODE 1 beliow...more >>

Hello! I'm developing a CLR Trigger to process some complicated logic. To easy understand, I want that for each inserted row in a table I need to process some fields reading data from other tables depending de values of that fields and process the complicated logic to insert in other table s...more >>

If I try to add a constraint that already exists, I get the following error: Msg 2714, Level 16, State 4, Line 1 There is already an object named 'XYZ' in the database. Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See previous errors. At this point the ERROR_NUMBER() fu...more >>

Hi, I have a situation to copy a set of rows of a Table 'A' into the same table base on some where cluase. Not all of the rows but just the rows that satisfy the condition. Could some one please help me with a small code snippet on how do I do it. Thanks in advance, -L ...more >>

I am looking for some help with specifying a TSQL statement to select some rows from a table. I'm not sure of the right vocabulary to use, so I'll describe by example. I have a table that (simplifying a bit) records when things that I will call 'documents' are transferred between 'users' of ...more >>

Here are some task to automate a restore process thru script, if any one of you done this process please help me. 1) Find out which box the restore is going to. 2) Find out which DB are being restored 3) Find out free drive space on all drives except c,d,s 4) Verify...more >>

Hi Folks, I'm trying to pull data from multiple tables into one report, where case_id is the only constant. only I've run into a few problems, I need to use a variable to create a CSV string and call the results of the variable with other columns form other tables. Here is the syntax. ---...more >>

Hi, I have backed up a sql server database from 2005 express database. Now I need to restore it to sql server 2000. Is this possible to do? Thanks in advance...more >>

Hi Everyone, Does anyone know how to get in touch with Russel Fields and/or Gert-Jan Strik? Thanks in advance, Alejandro Mesa P.S. Sorry if this is not the appropriate place or way to find out about this. ...more >>

I have been asked to embark on a project of moving excel data to a SQL database to then be put in to multiple word documents via VBA programming. I am not familiar with SQL programming. Could anyone recommend a true "idiots" guide to SQL? Thank you, -- Josh...more >>

Hi, I recently learned how to debug sql 2005 stored procedures with VS2005. Studio lets you run the code line-by-line, see the values of the variable, etc... The problem is I couldn't find a way to check the rows in a temp table in the middle of a debug. I think this is a "Must Have" fe...more >>

I assume I can use CASE in a WHERE clause but I'm not sure of the syntax. Below is SQL I have tried in a stored proc but it is not working. Can anyone help with this? Thanks. David SELECT CompanyID, LinkID, Company, Address1, Address2, City, State, PostalCode, CountryID, MainPhone, ...more >>

Hello , We are using SQL Server 2000 and soon to upgrade to 2005, we have 5 years of data , total 5 GB , 1 GB per year increase Sometimes management request year to year comparison for sales for example, the question is what is the best possible method from your experience to handle this s...more >>

Why is SQL Server evaluating all AND expressions? When I have "EXPRESSION1 AND EXPRESSION2 AND ...." if EXPRESSION1 evaluates to false, shouldn't SQL stop processing ??? (as all programming languages do). The following statements raises the exception "Null or empty full-text predicate.", m...more >>

Hello there On sql server 2005 when i create index i have two ways to set it as unique: in the type i choose unique key or in the type i choose index and in the unique box i set yes. what is the diffrence between them? ...more >>