Hello, I've tinkered with this problem but have not found a solution. (There is setup SQL below and my problem query) *** Structure: Nodes transferring units. One nodes table. It is related to itself, so that a nodes can supply another node. This relation (xfers) also has a volume, how m...more >>

Hi, I'm having trouble with an after insert trigger. The trigger handles an integrity check on a second id column. I have a scheduled stored procedure which can return a recordset. If the id in that recordset does not exist in the table with the trigger it may insert the new id's. The pr...more >>

I have a table that contains a column that collects discreet data (1 for on and 0 for off, just those two values) and a date column which is a timestamp containing a date and time. There are other columns in this table but they are unimportant in this discussion. A process inserts rows int...more >>

ColumnX holds values between 1001 and 5999. How can i make a query to get that result set: Group Quantity 1000s xxx 2000s xxx 3000s xxx 4000s xxx 5000s xxx ...more >>

Hello, The problem accured with the database that contains critical data, so it is very important to me to solve it as quickly as possible. So the problem is that I cannot attach my database to the SQL server. How all this began? At first I decided to back up my database. But by mistake in ...more >>

I want to save a marker of a database and periodically I want to check if my database is modifying ...more >>

I have 2 tables: invoice and invoice item. Invoice has column invoiceno; Invoice Item has column invoiceno, itemno, price. How can I retrieve records which are the 2 lowest item price for EACH invoice? Thanks....more >>

Hi, Does the command-line utility osql.exe has any external dependencies? I'm building a java installer that needs to interact with MSSQL with osql.exe. Now the temporary solution is to ensure the machine on which the installer is run has either MSDE or MSSQL client installed, but that is...more >>

Dear Friends, When deploying the application I send a back up of the data base to be restored on clients place. there is a table in the database which a has FullText Index associated with it. However since it is in a different machince the client server cannot recognise the Full-Text catelog....more >>

Hi, I have following tables, I need to query all transaction for accounts. So I created a view "txn_account" to simple union both tables and if a table doesn't have a field I made it NULL in the view: accounts (account_id, address, lastName, firstName, email, zipcode....) credit_account(accou...more >>

Let's suppose that I'm running a DELETE statement and in the middle of it, there is a network problem, and the connection to the db is lost. Will the records be deleted partially? For example. We have 100.000 records where MyField='test' if I do: DELETE FROM Table where MyField='test' and 3...more >>

Hi, I am able to display data and "page it" using the data grid. I don't want the overhead and I need to format the data in a easy way. How can you do paging in ASP.NET (using VB) without the datagrid (so the data is displayed in HTML tables with hyperlinks to the next "page" of data and th...more >>

I have tempTable with join to data table: .....from #tempTable T1 LEFT JOIN cpoProdNivo n ON T1.izd_nivo=n.[ID] I get an error: Cannot resolve collation conflict for equal to operation. Why? They are both on the same server and table on the server has default collation. Should I de...more >>

I have a database where all the tables are owned by user 'prd'. When I write a query I have to pre-pend prd to the table name. ie. "SELECT * FROM prd.test". Is there any way to allow me to write queries without having to specify the owner. thanks Gav ...more >>

I've got this query I need to write dynamically in ASP. This is not correct, this is just what I have. ============================= select distinct hd_sku as SKU, hd_desc as SKUdesc, sum(hd_trn_qty) as SKUqty FROM rainvhdt GROUP BY hd_sku,hd_desc,hd_invoice HAV...more >>

Hi all, is it possible to have foreign keys and indexes that reference tables in another database on the same server in SQL 2000? We are working on designing an application and was thinking about setting up different databases for logical segments of the application. TIA! ...more >>

Hi, I know the xp_cmdshell is default to sysadmin role to run. WHen i read the BOL, it said it can be configured to be run by any users after granting the permissions. but it did not mention how.... can anyone explain to me how since i have a xp_cmdshell stored procedure needs to be r...more >>

Hello, I wish to execute a simple dynamic sql script using sp_executesql, in which I am trying to input the name of the database dynamically. Here is the script - ------------------ DECLARE @databaseName NVARCHAR(100) set @databaseName='testdb' DECLARE @strSQL NVARCHAR(400) SET @strSQL ...more >>

Hi I have a query like this SELECT DateHour FROM Tickets The field DateHour is a DateTime.. when this field is NULL I want to return in my select an empty string (" ") I have tried using ISNULL and COALESCE but the select always returns 1/1/1900 What should I use? thkns for ...more >>

Hi Im currently developing a large WinForm application that is coded with C# ..Net. There are app. 500 users using this application and most of them are always running the same procedure. They keep getting timout error when I run ExecuteReader? I have checked out all the indexes but my p...more >>

We have a number of employees who have experience using Access. We are now converting to ADPs and need the programmers to learn SQL. Does anyone know where we can find courses within the NY City area? Jonathan Blitz CNCG Limited NY NY ...more >>

Hello! I was trying to troubleshoot a query. Very last step show estimated rowcount=142386. When query is executed, it returns only 7234 rows. I executed UPDATE STATISTICS ... WITH FULLSCAN against all tables involved in this query but this didn't make a difference. I am not sure what else ...more >>

To all, I have a binary data type in my database. It is an array of doubles. I would like to create a DTS package that can change this binary data type into an array so I can retrieve one of the double values at a specific index. Is there any way to do this? How can I cast the binary da...more >>

I have one table in one of its column it stored column name of another table. i want select statement to select that column name. i will explain this with example Table1 has columns with name ID,col1 and having data in that column as (1,tb_col1),(2,tb_col2),(3,tb_col3) etc and another table has...more >>

Can anyone come up with a way to set an AD password from within a SQL stored proc? Why? a) we create AD accounts for young kids (age 5 up) b) We use a SQL stored proc to give them easy to remember passwords c) We store these passwords in our SQL database - cos they are young kids and they ...more >>

I'm using sp_execute SQL procedure: SET @sql=3D'SELECT .....' SELECT @paramlist =3D '@xdatZ datetime,@xdatK datetime,@xkorak = int,@xmediji nVarchar(4000),@xTipM nVarchar(4000),@xVir nvarchar(4000)' EXEC sp_executesql @sql, = @paramlist,@datumZ,@datumK,@korak,@mediji,@tipMedija,@vir The ...more >>

I'm thinking this can't be done, but wanted to try it anyways... Is there any way a user can grant permission for another user to drop one of his/her tables? Something like this: GRANT DROP TABLE ON MYTABLE TO ALL; We have a table which can be created by a user then left alone for a while...more >>

Hi I want to create a new login "L1" in SQL 2000 and let him to be as L1's owner and can backup and restore it too,I selected the "public" and "db_owner" in Enterprise manager as I defined the login name ,but what should I choose to let him to do "backup & restore db" too? Any help wolud be ...more >>

A quick question on MSDB and database backups: We're moving one database to another. This database has a ton of jobs associated with it. W're going ot be moving this database to a fresh install of SQL Server. My question is: if I wanted to maintain the jobs that I've created, would just ...more >>

I have a DTS package which imports data from an Excel spreadsheet into an SQL Server database. The package works fine, but I would like to take the package to the next step in automation. How could I call the package(from VB ..Net or QA) to be executed with only one change in the package: th...more >>

Hello, I want to load following XML into one sql table . Pls let me know, how can i load it..My XML file will be 60 MB so i want to do BULK insert. It is a two level of hierarchy. Project can have multiple Activities.. so one project will have multiple Activities rows. so in table i want ...more >>