Hi, I've searched high and low for a solution to a annoying problem we have when printing database diagrams. This is SQL 2005 SP1, and the problem is that printouts have a large gray box in the left hand corner of every table in the diagram. When this gray box is in the lower left hand corner...more >>

Hello all, My T-SQL is pretty average so can anybody help me with this please: I have 3 tables, TableA: BatchID int, PK TotalRequests int XMLCreated datetime (or bit, I forget) TableB: BatchID int (FK) RequestID int (FK) TableC: RequestID int, PK CompletedDate datetime I nee...more >>

A client had retained us to build an inventory into a custom application we've built for them. We've had a good look at what's involved and what they are asking for is a fairly standard inventory. Rather than reinvent the wheel we'd like to use an existing schema and adapt it to our specific ...more >>

Hi, I am looking for a rich client for my Analysis Service Cube. What kind of options do I have within Microsoft Products? A link to an online article would be a great help. Thank you, Max ...more >>

Expert, I have a same piece of code which will be executed by multiple thread, e.g. begin transaction insert .... delete..... update.... ..... commit or rollback currently I have a lock in the application level, so every thread will hold a lock before execute the above code and release l...more >>

Hi, I'm running a correlated query on a joined table to return only the highest value of each group of projects. One project can have many revisions & I'm trying to return only the highest revision for each project. Both the project & task tables include ProjectCode & RevisionNum. I can d...more >>

I have a stored procedure that needs to be executed with ansi_null set to off. Problem is that whenever I go to modify the stored procedure using SQL Server management studio, the following batch is automatically added set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go alter procedure etc, et...more >>

Hi, I am running into an extremely frustrating problem and after hours of troubleshooting have not made any progress. When I try to use the ADO Command object to update a table, I receive the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80040e10' No value giv...more >>

Hi all, I have an website vb.net 2005 app using sql express in my laptop. How can I deploy this app so it can work anywhere? Any link or help please. Thanks in advance Rgds JFB ...more >>

I want to store a .pdf document directly in the database as part of a record. What column 'type' should be used for this? varbinary ?? I am doing this using vb.net 2005 - which I am very new to. Can anyone point me to some documentation that outlines how to go about storing this type of a ...more >>

Hi! Is there a system SP to refresh all views and functions after their source tables has been modified? To include new columns etc. /Johan ...more >>

I'm using Access 2003 SP2 with MSDE 2000. I copied a function from an internet site that changes text to proper case. Using an update query with the function works for only the first 10,000 records (out of 42,000+). The last 32,000+ records remain unchanged. Is this a limitation of the MSDE ...more >>

Hi! I have two similar questions regarding sending/fetching a textfile to/from an FTP site using SQL Server 2000. I need to read a csv file that exists on an FTP site. Can I read the data there, or do I need to first save a local copy of the file? I will also be creating a csv file in a st...more >>

Hi, I was wondering how to achieve to update only updated columns. For example: If i need to change someone's personal information like address and location, everything else remains the samee, then would not write a update statement which includes all column names in the SET-part. Is th...more >>

Hi, SQL 2000 comes with a Personal Edition, in SQL 2005 is there any desktop SQL equivalent to SQL 2000 Personal edition? SF ...more >>

All, I have never seen this syntax before, and can't fathom what it is doing. Can someone translate to english or "standard" SQL syntax? SELECT * FROM d LEFT OUTER JOIN l INNER JOIN p ON l.Product_ID = p.Product_ID ON d.field1 = l.field1 Thanks for any insight. Phil ...more >>

1) If you are looking for the truth to soothe and please your self, just click on this link. 2) If you are looking for the secrt of the family happiness, just click on this link. 3) If you are looking for solving any social problem you face, just click on this link. http://www.sultan...more >>

I would like to modify my view below to create a running balance of IncomeAmt - ExpenseAmt and wasn't sure if this could be done in a view. I am only getting records for 1 account so I don't think performance will be an issue. Thanks. SELECT dbo.EmployerRepTrans.TransAmount, CASE...more >>

Hi, I get a "Timeout expired." exception after 30 sec. from my C# application when I try to do a "BACKUP ..." or "DELETE ..." query on a big table with lots of rows. All are working fine if I make the table smaller or I execute the query from SQL Management studio. I can't figure out wh...more >>

Is it possible to retrieve data from a cursor by the column names (like MyCursor.MyColumn) without fetching into the variables? Thanks. ...more >>

Is it possible to bulk insert values from an excel file into a table in SQL-SERVER 2005? i saw all the examples and the queries posted here using a .txt file. this is what i'm trying to do: USE PPump GO DELETE dbo.Drivhcompany GO BULK INSERT dbo.DrivhCompany FROM 'T:\DC_Unique_ID.x...more >>

Is it possible to bulk insert values from an excel file into a table in SQL-SERVER 2005? i saw all the examples and the queries posted here using a .txt file. this is what i'm trying to do: USE PPump GO DELETE dbo.Drivhcompany GO BULK INSERT dbo.DrivhCompany FROM 'T:\DC_Unique_ID.x...more >>

Hello there I have sql server 2000 standard edition. I've installed SP4 on my server. and on the enterprise manager i see on the version SP4 but if i run on the same server the: SELECT @@version i see Service Pack 1 how it can be possible? ...more >>

I'd like suggestions on how I can setup the followng tables (for a web application). I have (to start) three applications. Each application has a feature set. Each feature has specific properties. The number of properties can vary from feature to feature. For Example: app_table ---------...more >>

Is there a way to set the type of a stored procedure parameter to reference the type of a table column? e.g. Have table - CREATE TABLE ExTable ( TableId INT NOT NULL PRIMARY KEY, FieldName VARCHAR(500) NOT NULL ) Want procedure parameter to be @FName SAME AS ExTable.FieldName ...more >>

Hi, Is there a wahy to get AD user info in a SP? I need a list of AD users with name, login name and email. Thanks. George. ...more >>

Where am i wrong? My simple query doesn't work. Please help. select * from tblNews_View where StartDate>='16/Jan/2007' and EndDate<='16/Jan/2007' order by ID desc My data in the Table is and it is for sure falls in the range of 16/JAN/2007 to 16/JAN/2007 ID StartDate E...more >>

Why is this allowed when there isn't a NULL in the main table? USE tempdb GO -- Create main table DROP TABLE dbo.child GO DROP TABLE dbo.parent GO CREATE TABLE dbo.parent ( parent_id INT PRIMARY KEY ) -- Create table with foreign key CREATE TABLE dbo.child ( child_id INT PRIMARY KEY,...more >>

I have two fields namely STARTDATE and ENDDATE. How do i query these fields with two input parameters. Lets say The STARTDATE field must be from 16/JAN/2007 and ENDDATE field meets up to 16/JUL/2009. I'm trying the below statement and it doesn't work properly. select * from tblNews_View...more >>

I'm executing a stored procedure on sql srv 2000. The procedure contains a update command, which updates a table based on two other tables with millions of datas. During the execution of the update command the sql server process sometimes vanish without a hint, no log entry no dump. I have no id...more >>

I am trying to create an SELECT statement to show which records are not created in this month. Existing Records 1-1-2007, 100 1-2-2007, 200 1-5-2007, 500 1-7-2007, 700 The SELECT statements needs to show rows with Dates not created yet for this month Show Missing Records 1-3-2007 1-...more >>

Hi I am building an, NSIS based, install CD ROM for my company's application. This includes the creation of a database. Until now that we had only sql server 2000 customers and I was using isqlw to run the sqls from command line Now our boss decided to support SQL Express 2005 as well. A col...more >>