Hi, I would like to query a table - OrgStructure where I would like to see the dates from June 2005 to May 2006. I do not care about the starting day within the month of June and the ending day of May, 2006 as long as it includes all the dates within the time frame of June 2005 to May 2006. ...more >>

Hi, I want a SELECT statement to return a value to a case statement. Can this be done? Is there simply an error in my script? If it can't be done, how would I do this? I'm getting an error around the closing bracket of the Case statment. Thanks in advance for any ideas on this. Below is...more >>

HI all, How can I pad a int number to produce a char with leading '0' Say I have a number 31, I want to produce '0000031' THanks Robert ...more >>

Hi, I have a request to fetch the half of the table over network. The table has about 1 million rows (400 MB). Is there a way I can write a stored procedure, so, the large result set won't "reside" in the RAM and just shoot directly via the pipe? My concern is the large result set wil...more >>

Hi There, How can i find the description of audit table contains any emplyee_id in it like this below. Select * from Audit where desc like (Select employee_id from employee) Select * from Audit where desc in (Select employee_id from employee) Thanks ...more >>

We are in the process of building a pretty large database. It encompasses several functional modules, like Accounts Payable, General Ledger etc. The decision has been made, to go with a single database instead of one database per functional module. How do I deal with the following scenario, wh...more >>

hello. i have a recordset of size 100. but, what i want to do is select 10 records at a time, starting with 1-10, then 11-20, then 21-30, etc. i'm trying to break it down into smaller chunks so that if a user, for example, clicks on page 2 of my website, he only gets records 11-20. does anyo...more >>

i have a script that deletes 2000 rows from my database. does it matter if i have a GO after each delete or should i just have one for all 2000. my database is under full recovery. i'm guessing it does not matter from a transaction log standpoint since all the entries will be recorded anyway...more >>

Hi, I want to define alert for system error messages but it seems that we cannot alter these messages like SQL Server 2000 to be logged in Windows events. For example error #208, is it possible? Thanks in advance, Leila ...more >>

I have 2 tables (Match and Team). Match - Table 1 MatchID int Team1ID int Team2ID int Team3ID int Team - Table 2 TeamID TeamName Description I would like to query the Match table and join to the Team table to return team details for a given match. So I would like to see the follow...more >>

Hello, I would like to program in ASP with connecting a remote MSSQL. However the regional options (Location and Language) are different from the two servers. How can I ensure the non-English can be displayed correctly? Thanks a lot. J > "J@Work" <licp@hotmail.com> wrote in message > ...more >>

I need to update ACTINDX in TABLE2 for each JOBTITLE in TABLE3; please help. Thanks TABLE1 ACTINDX ACTNUM_1 ACTNUM_2 ACTNUM3 ACTNUM_4 ACTNUM_5 30562 222 411001 000000 150 350 30563 222 411001 000000 155 355 TABLE2 JOBTITLE ACTINDX 209401 ...more >>

how can I get the physical location of the database file from sql server manager ...more >>

Hello there I have huge table with 1,500,000 records When i use Create Table to create temp table based on the huge table with only 6 records of 12 and insert all the data it takes at least 12 seconds And when i use Select () into statement it takes 3 seconds on the execution plan the ...more >>

Hi all I used Windows Authentication mode in sql2005.and I also add my users in logins.. but when I try to connect to sql2005 from another pc it gives me error 18452.. I did the same for sql2000 but it works well. ?? I also use SqlServer Authentication mode and it works well too.. thank...more >>

.... I just can't quite get the syntax correct. Consider master/detail tables, M and D. M has a unique column named "Name". It is the FK into the detail table, where it is not unique. What I want is a result set that has M.Name and the count of detail records associated with that name, eg...more >>

Hello, I've a MSSQL 2000 server with program scripting in ASP (at another server). I have a problem that some data in the database is non-English and I find that those non-English characters cannot be retrieved well. I would like to know if any programming or database configuration may help...more >>

is there a way to print the output in a specific color when calling the "print" command in sql? For example if was to call "print 'Something' " in query analyzer can i make it print out in a specific color? ...more >>

I need to sort this table like this: SELECT * FROM custom_carts ORDER BY position ASC This will list about four results, but I just need the first record found. Then find this item: select * from archive where name = 'Custom Carts' and then copy two fields from the FIRST item fou...more >>

Set NoCount On If Exists ( Select Name From TempDb..SysObjects Where Id=Object_Id('tempdb..#Blocks') and Xtype = 'u' ) Begin Drop Table #Blocks End Create Table #Blocks ( Block VarChar(6) , ParentBlock VarChar(6) ) Insert Into #Blocks( Block , ParentBlock ) Values ( 'aaa' , '111' ) Insert In...more >>

Hi, this is what i have in my stored procedure declare @SQL varchar(6000) declare @TableVar table ( ID int IDENTITY PRIMARY KEY, Crs_Id int ) set @SQL = 'INSERT INTO @TableVar(Crs_ID) values(2)' exec(@SQL) when i run this, i get a "Must declare the variable '@TableVar'." er...more >>

I've written a stored procedure on my SQL server that deletes records older than 7 days from a table. My SQL server the procedure resides on a shared hosted environment. I now want to schedule the procedure daily, which i attempt to setup through the enterprise manager tools menu. As i ...more >>

Hi All I have SQLServer 2005. Is there a security issue if webapp talks directly to production database. Is there any approach where you can have webapp talks to some copy of production database and this gets sync with production database. Please let me how you deal with this kind of sit...more >>

Hello All, probably a very simple solution to this but i am having a problem. I have 2 tables that contain data, the second table joins to the first table, neither of these tables contains XML however i have created a select statement that returns the data i want in XML format. This works fine ...more >>

HI all, Using SQL 2005, I create a simple view Select * from employee order by name But when I select the view with select * from employeeview the sort order is not adheered to. I have to specificcally issue a order by on the view Can someone explain this to me Thanks Robert ...more >>

I want to take the alter scripts of all SPs in a DB (in separate files). How do i do this? I am using SQL Server 2005. ...more >>

Hi, I an new to this group. I think this group will be helpful to me. I have to appear in the test of database. can any one help me by providing the Multiple chocie question with answer about the databases or sql server. ...more >>

I have a database with 4 relevant tables of information. table1 - inventory list of all computer assets along with userID. The userID is not always populated. table2 - a list of users and their cost codes. (not all users will be in list, just those with cost codes) table3 - a list of asse...more >>

I'm a new bie to SQL. Getting crazy with a query. I posted 3 times and couldn't grasp the help as i can't understand clearly. All what i need is to query the dates based on the below data. The datatype of StartDate and EndDate is Datetime and just when you query the output is shown as below. ...more >>

Hi I would lile to run the following query: ################################################################################### select B.FI, B.DI, B.KLNR, B.YEAR, SUM(B.COUNTVIS) , SUM(B1.COUNTVIS) as BC1 , SUM(B2.COUNTVIS) as BC2 , SUM(B3.COUNTVIS) as BC3 , SUM(B4.COUNTVIS) as BC4 ,...more >>