Hi Everyone, I have 3 tables: Telbook(Id:int,Name:char,address:char,comment:ntext,owneruserid:int), PK:id TelNumbers(telbookid:int,telno:char,telNotype:int,syscode:int),PK:syscode,FK:telNumbers.telbookid=telbook.id Teltypes(teltypes:char,fk:int),FK:telnumbers.telnotype=teltypes.fk The ques...more >>

In adventureWorks, this query is producing almost what I want to do in my real DB. select top 10 e.employeeId, vacationHours, max(eph.rateChangeDate) as rateChangeDate, rate from humanResources.employee e inner join humanResources.employeePayHistory eph on e.employeeId = ...more >>

i am trying to figure out why the following gives me an index scan instead of an instead seek. this was tested under sql server 2005 service pack 1. i am trying to find all records in the database that have a group_id = null. is there a problem with having a null column being an index? i w...more >>

I am playing with the security on SQL Server 2005 to get a firmer understanding of how it works. One thing would be nice to be able to switch logins to see the effect of my changes, I can set up different connections from within Visial Studio 2005, but I was wondering if I could do this from ...more >>

select top 1000 * from SomeTable order by NEWID() This gives me the random part but I can reproduce the results if I execute this same query twice. What I want is something like: select top 1000 * from SomeTable order by NEWID(INITIALSEED) This would have the feature that if I suppl...more >>

Hello, Is there a sql server limit to how many rows one can have in a #temp table in tempDB? Thanks, Rich...more >>

Dear all, I need some help from all my Transact SQL Guru friends out there.. Here is the scenario in its most simplified form.. .. I have two tables.. A(Lookup table) and B(Transaction Table) TableA Fields EmployeeLocationID EmployeeLocation (This could have values say "B","BO",...more >>

I have a table that contians two fields a GUID and and IMAGE. The images average 10-50 MB and there can be millions of rows and will have hundreds of rows inserted daily. Is there any value to using a clustered index on the GUID column? When rebuilding the clustered Index, does the image dat...more >>

I am using two tables to manage employee evaluations for a company. The two tables are 'dashboard' and 'employees' The dashboard table contains an 'employee' and 'lead' field, which refer to the employee ID number for both the employee and their supervisor, which are in the employees table. ...more >>

Hi, Right now we have some views to fetch some custom data from the combination of columns, but the performance of the query is quite bad. Is it possible to have the view as sql server code block, like in the stored procedure... these views are used at several places in the existing stored ...more >>

Hi i have a problem with de 306 error i want to grup by but this error apear the code is CREATE VIEW dbo.USA_GENERAL AS SELECT dbo.USA_VISTAS.Fecha_Proceso, dbo.USA_VISTAS.Mes_Vuelo, dbo.USA_VISTAS.Pais_Org_rt, dbo.USA_VISTAS.Pais_Dst_rt, dbo.USA_VISTAS.Ciudad_Org_rt, ...more >>

Hi I have SQL 2000 client tools installed, is it possible to install SS2005 aswell, as a side-by-side install, such as SSIS and SSRS? Kind Regards Ricky ...more >>

If you create a user with the Must_Change set ( as seems to be default from the GUI ) , how can you reverse this using the ALTER LOGIN command, because I cant seem to find a way to do this. Cheers - JM ...more >>

in short, the question is "How do i do custom paging in my asp.net grids" in SQL 2000. if i use default paging and if my db has ~200000 records, then i have to select all the 2 lac records then bind to the grid. whereas i've to show only 50 rows... so if i do custom paging i can implement t...more >>

Hi, I can run this: update quoteitems set avgcost=(select avgcost from e_icitems ii where quoteitems.item=ii.item) But, not this: update quoteitems qi set avgcost=(select avgcost from e_icitems ii where qi.item=ii.item) It seems the update command doesn't support a table alias--is t...more >>

Hi! In Excel there are many of the statiscal functions, but I need them in SQL Server 2005! I'm specially interested in the functions giving the area for the 'standard normal curve' (thats the complicate part, because of the integral). Can I wrap some c#-code as an UDF? Other ideas? ...more >>

I would really apprecaite some help with this. I have 2 databases. They both have a table called rptcontrol and I wanted to check the differences within the 2 tables as well as coloums within rows in the 2 tables. That is I have system50 and system60 databases and I have a table rptcontrol i...more >>

table : transaction I have a table like this, i need to take the last transaction of the particular day Trans_date Rcpt_Date Rcpt_Qty Sply_Qty Trans_Blnce_Qty 4/1/2006 4/1/2006 200 0 200 4/1/2006 1/4/2006 0 120 180 4/1/2006 1/4/2006 500 0 680 4/1/2006 1/4/2006 0 120 560 ...more >>

table : transaction I have a table like this, i need to take the last transaction of the particular day Trans_date Rcpt_Date Rcpt_Qty Sply_Qty Trans_Blnce_Qty 4/1/2006 4/1/2006 200 0 200 4/1/2006 1/4/2006 0 120 180 4/1/2006 1/4/2006 500 0 680 4/1/2006 1/4/2006 0 120 560 ...more >>

The release of the SP2 19th Dec is it just for testing or is this the offical SP2. If its not the official SP2 does nayone know when it will be released thanks for any advice Sammy...more >>

Hi, I have a programming problem: I have a table like this: create table objs (objname varchar(500), size int) sample data: 'a', 518 'b', 1928 'c', 418 .. .. .. I have a few hundred rows in this table. What I want to do is to divide the rows into groups that contain rows such ...more >>

Hi, I need to know if there is a way to create a trigger that is more specific than detecting an update on just a column in a table. I need to know when a specific row within a column changes. For example, lets say I have a table "dbo.table1", that contains two columns, "col_ID" & "col_Nam...more >>