Hi, i am trying to get a pivot/crosstab query working but i am having a hard time working out what im doing wrong. I have googled for a number of samples for use with my database but i cant apply to my scenario so i would appreciate some guidance. I have an employee's table, and an AsencesTabl...more >>

I am running on SQL Server 2000 SP4. I am attempting to generate SQL Script and include extended properties. When doing so, the extended properties for one table (i.e. Column Description) are not generated. Extended properties for all other tables script just fine. I've even gone so far a...more >>

Can SSIS moving data from one SQL 2000 db to another SQL 2000 db? If so, can anyone tell me what i need to do this? Execute SQL Task ? Data Flow Task ? OLE DB Source ? OLE DB Destination? It's a little confusing even after reading for a day. Any examples great appreciate and will award ...more >>

I have following tables: 1. Registration with RegistrationId, Name 2. EventMeal with MealId, MealFee 3. RegistrationMeal with RegistrationId, MealId, MealQuantity (this can have more than one row for same RegistrationId) 4. EventSession with SessionId, SessionFee 5. RegistrationSession with Re...more >>

I have data as following: create table #test (jobcategory int, startsusptime datetime, endsusptime datetime) nsert into #test values (1, '2007-05-03 14:12:39.033', '2007-05-04 06 insert into #test values (2, '2007-05-03 14:19:26.547', '2007-05-03 14:21:53.890') insert into #test values ...more >>

How can I find out the size of our SQL Server Database??? Any help would be greatly appreciated. Thanks in advance for your help. PSULionRP...more >>

The following gives me the error u.username is invalid in seklect list because it is not contained in either an aggregate function or the group by clause SELECT u.Username, u.Email, ar.RoleName, uc.LastActivityDtm, COUNT(t_Proxy.ProxyUserID) AS Expr1 FROM t_Roles AS uar INNER JOIN ...more >>

I'm doing a bit of research for a short posting on the sp_oa_* procedures, used to handle COM objects in SQL Server. Can anyone provide the history of these, including in which version of SQL Server they made there first appearance? Thanks in advance, KJ ...more >>

how can i call a function from a stored procedure...more >>

I have a table username Roles Seema Admin Seema AppAdmin Seema Testing Bobby Manager Bobby Admin I want a query so that i can get something like seema Admin, AppAdmin, Testing Bobby Manager, Admin...more >>

I want to rebuild index on all the tables on my database with the exception of 7 tables. how can I do that? Thanks ...more >>

I have a small client who wants to consolidate Terminal Services and SQL Server on the same box to save money. I have never been a proponent of this but I also can't find a Microsoft best practice that addresses this. Has anybody seen a Microsoft blessed best practice on this? Do you know w...more >>

Hi, I have 2 tables: one with real time data, and another is lookup Table Data col1 date col2 amount table lookup col1 identity col col2 slot col3 alias col4 start_time sample of table data dt amount 2007-08-06 00:01:00.000 0 2007-08-06 00:01:23.000 0 2007-08-06 00:02...more >>

Hi, I posted some trigger code yesterday that somebody was kind enough to fix, but further testing has thrown up another problem with the code. What I want to do is add a subnet into Table B for every IP that gets inserted into Table A, if that subnet does not already exist. If I add an IP ...more >>

Allow me to share with you here some information about one man his name is muhammad. In The Name Of Allaah, Most Gracious, Most Merciful YOU MUST KNOW THIS MAN MUHAMMAD (May peace and blessings of God Almighty be upon him) You may be an atheist or an agnostic; or you may belong to anyon...more >>

Hi, I have a SQL table that has data like this: Title Month Info 1 ---- 7 ---- 100 1 ---- 7 ---- 100 1 ---- 8 ---- 200 1 ---- 8 ---- 250 2 ---- 7 ---- 150 2 ---- 7 ---- 150 2 ---- 8 ---- 300 2 ---- 8 ---- 300 3 ---- 7 ---- 250 3 ---- 7 ---- 250 3 ---- 8 ---- 100 3 ---- 8 ---- 200 ...more >>

Hi, I'm sure this is probably a silly question, but I'll ask anyhow. I'm trying to debug a large proc (sigh) and am putting print statements in it to do so. Working fine, but everytime it does a update or insert it prints out the rows affected as well, like the example below. This adds a lot o...more >>

Hi, i have two queries with the following data: Hours worked query: EmployeeID_FK HoursWorked OvertimeHours Absences query: EmployeeID_FK SickTaken HolidayTaken They are independant calculated columns (from hours worked table and absences table), however the EmployeeID_FK is como...more >>

Hi, I have two tables - Table1 and Table2. Table 1 contains dates and Table 2 contains records. I need to get first two records from Table1. And in table 2 I need to get all records falling within those two dates in Table1. After that I need to move to next two records in Table1 until ...more >>

I require a query from a login audit table that will select the latest entry only for each user. The data I want to see consists of three fields: 1. username 2. login_date 3. login_time I can get as far as creating a temporary table with the entries sorted by username, login_date (descendin...more >>

Hi! what am I doing wrong. declare @val1 int set @val1 = cast (count (Select * From table1 where col1 is not null) as int) update table2 set mycol = Case @val1 = 0 then 3 else case @val1 > 2 then 1 else 0 end where mycol is null ...more >>

Hi, In my application, I have some SQL like SELECT Max(No) FROM Prod My app coding logic is if the max no is now 1000, then the new No for the inserting Prod will be added 1, namely 1001. Now comes the situation, if many users are inserting the Prod and the concurrent connection is als...more >>

This query works beautifully. What I want to do is, select the SURV_YY_DT available in the table and sum without having to hard code each year. SELECT ABA_NR , SUM(CASE YEAR(SURV_YY_DT) WHEN 2006 THEN 1 ELSE 0 END) AS c2006, SUM(CASE YEAR(SURV_YY_DT) WHEN 2005 THEN 1 ELSE 0...more >>

Hello I would like to know on the xml column if there is a schema associated. What query must i use ? Franck ...more >>

Just playing around and i came across the IN function eg select name from table where name in('smith',jones') or you could just select name from table where name='smith' or name='jones' they both do the same thing, only issue i found was you cant seem to use wildcards unless you do a sub...more >>

Hi! I have an application where the client call the server over .net remoting (tcp). The application has three parts (Database on server A) -> (BI Services on server B) -> (Testclient on server B) The final code to be called looks something like this: Public Sub Update() Usin...more >>