Dear all I m using sql 2000 and facing some problem in following query using following sample data create table tab_sample (h_rec varchar(8),f_rec varchar(8),m_rec varchar(8)) insert tab_sample select '11111','11111','22222' union all select '11112','21111','11112' union all select '111...more >>

I am creating a project with microsoft access 2000 front end and sql server 2000 backend. When i print report from the form then what my system does is ,creates some views according to criteria from the form on the fly and at the end it links all those views and create final view and that fin...more >>

Hi, Can somebody please tell me why the following SQL statement does not work? SELECT E. EmployeeName, T.TitleDesc FROM Employee E INNER JOIN JobTitle T ON E.TitleID = T.TitleID WHERE E.EmployeeNumber = 12345 AND CASE WHEN T.StopDate IS NULL THEN E.JobStartDate >= T.EffectiveDate ELSE E.Jo...more >>

Hello to everyone. I need to synchronize data between servers, where the source is SQL Server Express 2005, and the the server is SQL Server 2000. I´m using VB.NET, and I linked the server, and then pass the information to the server, but here is my problem: TABLE CUSTOMERS ID CUSTOMER...more >>

Hi every one, I have one query Is it possible to get all location list of City's latitude and longitude? For example i have latitude and longitude value of City Toronto then base on those value(latitude and Longitude value of Toronto) ,Should i get the all location list of city Toronto? ...more >>

Hi, I am using SQL Server 2000. I need to store the Credit Card numbers for my application in one of the columns of my table. I need to Encrypt it using some encryption algorithms (preferable AES encryption). Are there some UDF or stored procedures which I can use to do this. Maybe someo...more >>

Given the following statement: SELECT ChainID FROM Location GROUP BY ChainID HAVING COUNT(*) = 1 How can I update the results to make all unique ChainID's = 0? In other words, how can I combine the following? UPDATE Location SET ChainID = 0 WHERE ... SELECT ChainID FROM Locatio...more >>

Our compnay www.globnikesneakers.com wholesale Nike Air Max, Nike Air Max 360 ,Nike Air Max 90 ,Nike Air Max 91, Nike Air Max 95 ,Nike Air Max 97, Nike Air Max 2003 , Nike Air Max 2004, Nike Air Max 2005 ,Nike Air Max 2006, Nike Air Max 2007, Nike Air MAX Tn Plus, Nike Air Max Ltd ,Nike Air M...more >>

Hi, Is there any built-in string function in sql server that makes a string init capital? For example "init capital" should become "Init Capital" Thank you, Max ...more >>

Hi, Is there any way to supress the resultsets of a stored procedure called inside another? Right now I am using sp_executeSql to run it, so something like this would be great (just made this up!): EXEC dbo.sp_executeSql @query WITH NO_RESULTS In this case I am just timing the procedu...more >>

Hi, I have strings between 100 and 10000 chars long to store efficiently in = a table. I believe the 'text' is the data type to use. But what is the storage = overhead? thanks,...more >>

I heard I can use bcp commmand to send data on shared folder. but I'm not sure how to use for ftp sites. is it possible to do that? if it's not , then is there any other way to send data into ftp sites using batch file? ...more >>

When should someone start thinking about making different instances on SQL Server? We have relatively small databases ( all under 500 MB, most under 50 MB ) but the list of DBs is starting to grow. I was wondering about making other instances ( I just started a new project so it would be po...more >>

I have a table where I have orders that have been placed. Obviously it can have many different statuses. The problem is how do I make the programs/stored proc know what the values are? For instance - I have a statuses of Open, Completed, Processing, Shipped to name a few. If I store the sta...more >>

Hi there, I have a problem that's beginning to do my head in and hope someone can help!!! I've got a SQL Server 2005 database which is partly encrypted (certain columns per table are encrypted). I have two different passwords for two different symmetric keys and these passwords are in tu...more >>

Where can I ask VS 2005 C# questions? Please provide a link. Thanks, David Bachman...more >>

Running the following commands in 2005 give the monopoly error below: -- script go select 1 -- error A fatal scripting error occurred. Incorrect syntax was encountered while parsing go....more >>

Didn't get a response yesterday, so I'll try again: I'm looking for strategies to handle a 1.5 terabyte database and I think I've got a way to do it. What's killing us is that when we do a CHECKDB on this database, it hammers the server for 9 hours straight. (SS 2000 SP4) Well, I read ...more >>

Hi, I have tried to succeed opening a file (txt or whatever) to an already open sql connection in SQL Server Management Studio. In same way as we can in Query Analyser. Is it possible? One similar question is that I want to open a file to a new connection. I try open a .trg file, the file ...more >>

Given that when you add a primary key to a table, sql server automatically creates a clustered index by default... Is there a way to tell sql server that when you add a primary key that you want the constraint enforcement to be done by an already existing clustered index, rather than automati...more >>

Hello, I was wondering if anyone knew what the minimum files were needed to run SQL? Thanks...more >>

I'm using SSAS to build a cube. Within my data source view (DSV), I = have some tables that are used over and over (forget the term). =20 For example I have a Worker table that is joined on by a Fact table many = times. Within the Fact table are columns such as CreatedByWorker, = DecisionByW...more >>

Dear all, I got a Table A as follows Field-A 1 2 3 4 5 And I got another Table B Field-B 1 2 3 ...more >>

How can I create this computed field that will "reset" itself at the beginning of each year... I know how to create the computed field. What I'm trying to do is that at the beginning of each year the last part of the computed field needs to start at zero and increment up by one until the ...more >>

hey all, @var = GETDATE() Is there an easy way to replace the Day of @var with any day? Thanks, rodchar...more >>

hey all, i have a sequence of numbers starting at 120-144. i need to loop thru this range of numbers and do the following: case between 0 and 48 .... case between 49 and 120 .... case > 120 is this possible to do in sql? thanks, rodchar...more >>

Hello, I use the following SQL-Statement to find out ID-Values from several Tables: CREATE PROCEDURE dbo.stProc_FindID @strtblName nvarchar(128), @DSNr nvarchar(5), @intNummer int, @intJahr int, @ID_Verf nvarchar(40)OUTPUT AS DECLARE @sql nvarchar(4000) SET @sql = 'SELECT @ID_Ver...more >>

Is there any why to know at what time Assigned/Revoke the Fixed Database Role to the User. Thanx in Advance Farhan Iqbal...more >>

I've just noticed that the production database has inconsistent collation set on varchar columns either Latin1_General_CI_AS or SQL_Latin1_General_CP1_CI_AS This is probably happenning on many, if not all tables. How do a reset the collation sequence for all columns throughout the databa...more >>

Hi, We run a system that has a very large back-end database, shared with a Kronos product. The kronos Product runs on the same IIS server, but uses a java client to communicate with the SQL server. The Kronos product has no performance issues. Our ASP system built on top of the Kronos syst...more >>

Hello all, Who works faster in sql for creation of an index: CREATE INDEX or Alter table tab add index ? ...more >>

Hi, I need to populate a database for a load-test. I tried VS2005 for db proffesionals and it's datageneration plans, but it's simply not working with the current configuration. Do you know/use any other tool,preferable free, that can do this? Thanks Andre ...more >>

As our SQL Server 2005 Express edition database is growing and growing and we use it by about 20 concurrent users, the performance is decreasing from day to day and has reached an unacceptable degree. A similar Access database proves to be about 5 times faster. Someone claimed to me that SQ...more >>

My issue. I'm running a web app which makes command calls to a DB using SQL Authentication. One task the app will have to do is utilize th "xp_cmdshell" to populate an Excel spreadsheet and move the file from location A to B which is a linked server. Since the DB user executing all my sql co...more >>

Does Log Truncation happen when I issue a ""BACKUP DATABASE XX TO DISK = YYY" statement from my code? ...more >>