Hi, I'm having a problem with sorting data according to date. I've got a flag in the database called published. If published is true then the date should be sorted desc, else asc. I used the union all to try and get a combined result set but get an error if I run the following query SELECT ...more >>

Hello, how can I list all indexs from a table? sp_indexes myTable does not work. Error message: Could not find server 'myTable' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. Thanks for any help in advance! Regards Andreas Klemt ...more >>

Hi, Is there anyway to get data from a specific row to row, suppose I have this select query: select * from Items order by ItemsPosition which returns 100 items, now I only want items 1-10, and then later 11-20, the values will be inserted through a program into the query, is there a way...more >>

Hi I encountered a problem when I'm trying to import data from a flat table to several tables of the same databases. There are about 1 mln records inside the flat table called XX_ZRODLO. The stored procedure for import seems to work and import data but after about 15000 it stops and it seems ...more >>

Hi! I have some problems with ms sql server database connection. When I wrote the following function (in VB): sub Remplir_Theme() Dim connectionString As String =3D "Data Source=3D.\SQLExpress; AttachDbFileName=3D|DataDirectory|\BasedeDonnees_babySQL.mdf ;Integrated Security=3Dtrue; User In...more >>

Hi, I need some help with writing the SQL definition necessary to do the following: (Cut and paste into Notepad to see correct layout) Temp table name: #Report1 PERMIT_ID PERMIT_NR PERMIT_TYPE_CD PERMIT_EVENT_DT DATE_TYPE_DS DATE_TYPE_CD ---------------------------...more >>

I am trying to set up a trigger where when the last or first name field changes, it will posts the persons EmployeeUID to another table. I have it working except that it sends all of the records to the destination table, not just the single record that changed. Any ideas? CREATE TRIGGER I...more >>

Guys, I was asked to look into why the SQL server run very slowly sometimes. I was told, say, from 9/1/06 6am -6:45 am the server ran particularly slow, is there anyway I can know what jobs were running during that time from Enterprise Manager or other tols? We don't have SQL profiler trac...more >>

I have a web application, .NET, that uploads an Excel file with thousands of records, creates a DataReader, steps through the records and updates an SQL table with each record. There has to be a better way, I just don't know what it is. Can someone point me in the right direction? John Mori...more >>

We have made a couple of extended procedure on SQL 2000 32 bit version. Now the database is decided to reside on SQL 2000 64 bit version. Since extended procedures will not work, can anyone give me any links or help how to convert and build those procedures to work with 64 bit version? Than...more >>

Hi, Can anyone help me with this query. I have a table GassBottleSize with colums Gas, Bottlesize, id and values ID Gas BottleSize ------------------------------------ 1 Trimix1845 50 2 Trimix1845 100 3 Trimix1170 ...more >>

I have those Tables: CREATE TABLE GameYellows( id INT NOT NULL AUTO_INCREMENT, AddedDate DATETIME NOT NULL, Player_ID INT NOT NULL, ) CREATE TABLE GameReds( id INT NOT NULL AUTO_INCREMENT, AddedDate DATETIME NOT NULL, Player_ID INT NOT NULL, ) CREATE TABLE GameSubs...more >>

Hi all, what would I include in my select statement to have numeric type data to be retrieved in a certain format. So if I have data that looks like 123456789, I would like it to be retrieved as $123,456,789.00 Thanks Robert ...more >>