Hi, I suddenly ran into a serious problem. We installed a new SQL Express 2005 SP1 on a different server and now it seems to be case sensitive with the variables in stored procedures: -------------------------------------------------- ALTER PROCEDURE [dbo].[GetUserID] (@UserName varchar(5...more >>

Considering the following query which transposes rows into columns as desired; please notice that the column name aliases are "hard coded" (e.g., AS ABO, AS RHFactor, AS A1, AS A2, etc). Each row in the table Lookup_TransplantParticipantFacts contains the desired "column name" for the corre...more >>

I am trying to use the following statement in order to automatically get data from the last period of the previous year if the period entered is 1. I do this to get data for the current period and one period prior. WHERE CASE @period WHEN 1 THEN ((SELECT period FROM TE_Period WHERE (date_cl...more >>

Hi all, I have a problem in converting date from English to the Persian(Farsi- Iranian Language-). By that I mean I want to change the calendar in SQL server 2005 from English Calendar to Iranian calendar. What should I do? Please help me asap. Thanks all, Nassa ...more >>

I have many students taking many assessment tests during a course. I want to average their scores and then be able to count the number of students that have scores in a range, i.e. 75-100, 50-75, etc. I would think there must be a way to count averages. I'm new at this and I am drawing a blank...more >>

I have a parent child relationship and want to it display in an aspx page. TableA 1 Folder1 2 Folder2 TableB 1 first 1 second 2 firstTwo And display in a type of tree structure: Folder1 first second Folder2 firstTwo I'm not sure how to return the result set(s) for th...more >>

Hi All; i want to know how to parse a row for example i make query ,i get some rows ,i wanna parse the se rows .....like if i get I LOVE YOU then i need I to be in one column ,LOVE to be in a nother next column ,YOU to be in another next coulmn.....so can i get the street number from a long ...more >>

Hi, I backed up my database using the following t-sql command: USE pwsk EXEC sp_addumpdevice 'disk', 'Backup-PWSK', 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\PWSK-BKUP.data' BACKUP DATABASE pwsk TO [Backup-PWSK] and restored using the following command: Restore database PWSK...more >>

hi all; alright i have customerID ,order,orderDate......how to write a query to show what is the latest order a particular customer has ordered.... remember the same customer may have several rows in the table ,but they might not be organized based on the date..i need aquery to select the late...more >>

Is there a way to make this WHERE clause more attractive, (less codes)? For your infomation, I am trying to extract data from history table. Thanks, Culam SELECT da.id, da.open_dt, ag.extract_dt FROM Deposit da JOIN Deposit_aggr ag JOIN da.id = ag.id WHERE (da.OPEN_DT = GETDATE() - 12 AND...more >>

I need some help writing a query summing up line items (units) on unique invoices and then getting an average unit per invoice. Any help on constructing the query would be greatly appreciated. ...more >>

TableA MyID Type Val1 Val2 Val3 ID1 A1 V1 V2 V3 ID2 A2 V3 V4 V5 ID3 A1 V11 V21 V31 TableB Type Desc Comment A1 My Desc1 Desc1 A2 My Desc2 Desc2 A3 My Desc3 Desc3 MyNewTable: MyID Type Desc Comment Val1 Val2 Val3 ID1 A1 MyDesc1 Desc1 V1 V2 V3 ID2 A2 MyDesc2 Desc2 V3 V4 V5 ID3 A1 My...more >>

SQL 2k sp4 I'm trying to optimize a stored proc and am seeing performance issues with ISNULL and would like to know if anyone else out there has experienced the same, and what options I might have. I have a sproc that accepts multiple optional variables. An example of what I'm d...more >>

I have a view that looks like : col1 col2 col3 and in my stored procedure i want to have a parameter: @col varchar(20) = 'col1' and do something like this: SELECT * FROM view WHRE @col = 4 the procedure compiles fine but when I run it I get an error: ...more >>

Hi All, i wish to do a thesis in sqlserver database data mining.Can anybody help me where i will get a sample thesis in data mining? Thank You. Regards Psella ...more >>

Hello This is a good question and I'm not sure of the best route to take. I have two tables (5 million records in total). I do my select (joining on both tables) to get my record set. For this example my select returned 1 million records. I now need to insert these 1 million records into ...more >>

Hi Just a quick question, I have a SQL DB with 5 million records. These 5 million records are formed in two tables so if I want to get the whole record out in one hit I have to join the tables. My question is, with tables this big would storing the data in one table be faster? These are rea...more >>

Hi everybody, i have a problem with SQLServer 2000 I have an application that allow that the user send a SQL statement, I'm currently validating the input string should be only SELECT , i do that with LTRIM and then a substring of 6 character must be equal to "SELECT". (the user that conn...more >>

Our application supplies a bit of a front end to the user maintenance on the database, using SQL Server authentication. We don't allow some operations on a user, for example drop user, if that user is logged in. The procedure, under 2000, created a temporary table #tmp containing the columns...more >>

Hi everyone, I recently Upsized my MS Access2003 DB to SQL Server 8.0, ever since I did I wasn't able to update a bit field using stored procedures. Bellow is my Stored Procedure that I'm trying to use to update the "Ordered" Field CREATE PROCEDURE update_master_table (@ID int, @part...more >>

How do we check Tempdb contention via scripts. I would like to be notified when tempdb is on the peak by email or some other communicaiton method. Every now and then we get a message the default filegroup is full on tempdb. ...more >>

Is there any way to list the user defined views in the order of dependency. view1 might call view2. So it should list first view2 and then view1. ...more >>

Hi all Im creating the sp's which i have never created before. The length of sp goes to something around 800 - 1300 lines.. Im able to achive this but there is only one problem.. optimization The exection of sp takes lot of time and need to optimize.. The sp contants all the scenario l...more >>

Hello, I am planning to use three databases on the local SQL Server. DB1 will be for App1, DB2 for App2, and DB3 will hold tables, that both, App1 and App2 need to access. With applications I mean ASP.NET applications. Obviously, I need in App1 and App2 at least two SqlConnection and Sq...more >>

Ii dont know if I am on the right or wrong track, maybe someone can help. I have 2 tables, bt and inventory. What I need to do is add all the quantites in the bt table with yesturdays date to the quanties in the inventory table with yesturdays date. I am doing something wrong because if there...more >>

Hi, just two days ago i have posted about this.what i want is equivalent SQL code for pivot operator(SQL Server 2005) in sql server 2000.I dont want to go for third party tool.Also it should be dynamic.That is no. of transformations(that is no. of rows to turn into columns) is not known bef...more >>

Scenario We are currently developing a production system using VS.Net 2005 and SQL server 2005 we have a test system and a production database system in our programs we refer to the database as DbClorius so in test modus we simply change the host file of a system so that our program...more >>