Friends, How we can protect our database with sql injection. --Rahul ...more >>

Hi All, I have below table structure: ItemID Price FromDate ToDate --------------------------------------------------------------------------------------------- 1 10.00 01/01/2005 ...more >>

I have a module that processes sales forecasts and calculates bill-of-materials to figure out product demands. Right now, the processing can take several hours (sometimes 12+) to perform and write about 3 millions records as it figures things out. I also need to reference the data in this ...more >>

Personally, when I see CHAR(1) with 'Y' and 'N' instead of bit, I get mad. But it's apparently so common I have to ask: is there any good reason for it? Paul ...more >>

hi, i have a simple query that needs to be created dynamically... SELECT a.isbn FROM dbo.author a LEFT JOIN dbo.rating...more >>

I have two queries SELECT TOP 10 WITH TIES td.InventoryId, SUM(td.Quantity) FROM tblTransaction t, tblTransactionDetail td, tblCustomer c, tblInventory i WHERE t.TransactionId = td.TransactionId AND t.CustomerId = c.CustomerId AND td.InventoryId = i.InventoryId AND t.Custom...more >>

We have a company standard which says " no 'Select * from " , which I agree with ) . ( This is NOT my question) So I went and self reviewed my code, and I found the only place I had a select * was with EXISTS and NOT EXISTS statements. Below are 4 methods. Which do you use/prefer? And ...more >>

In a store procedure, do you need to explicitly Commit a transaction? If you exit the SP where you have done a Begin Tran and haven't done a Rollback Tran or Commit Tran - will the tranaction be rolled back or comitted? Thanks, Tom ...more >>

Hello, I hope someone can help me, as this query is driving me a bit mad! Suppose I have two tables, which contain sales data... create table saleshistory ( buyername varchar(50), email varchar(50), saledate datetime ) create table saleshistoryitems ( saleshistoryid int foreign key ...more >>

How do you call a SP that returns 3 recordsets (cursors) from another stored Procedure? -- Thanks and God Bless, ThomBeaux...more >>

Using SSIS, I want to store my configuration in a database table. I opened Package Configuration Wizard, and selected Configuration Type: SQL Server, Configuration location is stored in an environment variable. Next I created an environment variable SSIS1_CONFIG For integrated security, ser...more >>

I have a situation with a table variable where I insert rows, use the data, delete the rows and then subsequently add new rows. I need the identity column (in this case IdentityAppID) to be re-seeded to 1 everytime I insert a new rowset. I've tried using dbcc checkident and various other metho...more >>

Hi, I have an .xls file (which is of size 40+ MB). I want to import it into SQL Server 2005 using SSIS packages. I am totally new to that .. can any one help me with that pls? My mgr doesn't want to do it via import/export wizard. Regards Pradeep...more >>

How do I know if I have SP2 for SQL Server 2005 installed? Thanks, Ron ...more >>

Good afternoon, people. I've bumped into an odd problem, I hope someone can point me in the right direction. I have a list of numbers. I'd like to update those numbers where I one exists in another table. This is a slightly simplified form: DECLARE @BestNumbers TABLE ( ID INT NOT NU...more >>

We have a stored proc we inherited from the previous developers that is somewhat messy (temp table, cursors, etc.). As noted its not the most well written sproc but we are seeing really strange behavior when running inside a transaction vs. outside a transaction. Outside the transaction it tak...more >>

I am just curious here. In my case, I am creating a diagram showing the relationships between 2 tables that has a CompanyID in the HRUsers table. But I don't want to enforce the restraint. There are cases where there will be no CompanyID and if I enforce the restraint I get an error. S...more >>

Using Sql Server 2000, I am forcing a constraint error for testing and am confused on the errors I am getting: After the error occurs, Scope Identity is blank (not 0) and @@error is 0: The Code: ************************************************ INSERT INTO ftsolutions.dbo.temp (CompanyID,Fi...more >>

Select * from tbl1 Where city = 'abc' returns 30 rows with unique Names. THe user wants to see all 30 rows with the row containing Name = 'Joe smith' as the first row. If I order by the name column, 'Joe Smith' is in the 15th row. How can I list this dataset where the row containing ...more >>

I have the following data sample: id job_id old new updatetime updatename 14169 9005 4 3 2007-03-12 14:26:45 msetstatusjob 14161 9005 3 4 2007-03-12 10:37:03 mregisterjob 14158 9005 4 3 2007-03-12 10:30...more >>

pknum int (autoinc) pressnum int active bit startuporder int ……. I’m working on a startup list. This query reset the startup order declare @i integer set @i = 0 Update press SET @i = startuporder = @i + 1 where active = 1 The problem is there is no update order by, so the pre...more >>

Hi, I have 2 tables as follows: Table A: Invoice No ------------- 1234 5487 7894 4545 Table B: Invoice No -------------- 1234/5487 4545/1111 1234/2000 I want to run a query that will show any match between the 2 tables even if Invoice No of Table A is part of Invoice No in Table...more >>

I am looking at implementing paging using some of the new features of SQL 2005. Most of the techniques I see on how to do this has a static order by statement. In my case, the sort column and order will be decided by the user when he clicks on my datagrid. I found a technique that generated...more >>

Hi, This is a comparison between SQL Server 2005 and SQL Server 2000. I use dynamic sql in a stored proc as follow : CREATE PROCEDURE MyProc ( @Param1 navarchar(50)) AS BEGIN declare @query nvarchar(4000) set @query = ' ' set @query = @query + ' select Col1, Col2, Col3 , .... ' set...more >>

I have three tables: InstMaster, InstProducts, and Contacts. The InstMaster contains Master records for Bank information. It has InstID int; InstName varchar(50) The InstProducts table has: InstID int; Proprietaryname varchar(50) The Contacts Table has: InstID int; ContactName ...more >>

this select statment brings back 6 records. select (select Visit from PatientVisit where PatientVisitId = PatientVisitAgg.PatientVisitID) as sVisit from PatientVisitAgg where PatientProfileId = '7847' and PatBalance > 0 How can I get the max date and min date from this record set? ...more >>

I have a question/would like some input on a group of database tables design. One of the main goals of this redesign is the ability to maintain a history of who the crews/crewleaders/crewmembers were and when they were assigned to various crews. The objective of this redesign is so product...more >>

I have a table with the following structure. There is a unique ID for each column: Unique_ID Grade1 Grade2 Grade3 Grade4 1 A+ A B A 2 C A+ C D etc. Basically, there are rows of grades pe...more >>

When I "View Dependencies" for a Table in SQL2005, it lists some but not all SProcs that I would say depend on the Table. For example, if a SProc UPDATEs the Table, it lists it. But if the SProc SELECTs from it, it does not. How can I determine all the SProcs that reference a table in any...more >>

I'm trying to use PIVOT instead of CASE but can't make it. What's wrong with the pivot query below? create table t1 (a int, b char(5)) go insert t1 values(1, 'SVE') insert t1 values(1, 'FIN') insert t1 values(1, 'DAN') insert t1 values(2, 'SVE') insert t1 values(2, 'FIN') insert t1 value...more >>

I am looking for a free website where they have given examples/ tutorial on T-SQL, mainly writing advanced smart SQL statements. I am looking for simple tricks that SQL programmers use. These would be things like calculating moving averages, calculating price returns, creating cross-tab type out...more >>

Hi, I'm trying to write a stored procedure that can query the database it is running on, but also is able to query another data source that is accessed via an odbc connection. Is this possible and what steps do I need to take? Thanks for any help. Rob ...more >>

Hi guru's SQL 2000 standard - is there a way of creating a script that will terminate all user processes to a specific database apart from 3 that must remain ? I can find scripts to terminate ALL processes but not specific ones Please let me know if you need any more information Thanks...more >>

Want to store (write/read/update) images into SQL DB from VC++ code. Pls, give me any reference where can get knowledge. Any sample code also awesome. Zanx...more >>

Hi There. I want to update in 1200 ZIP fields the value A-xxxxx to xxxxx (all different characters exept the A-) how can i solve this. ...more >>

Hi guys, I need your help writing a query that would return the common part of two strings. Ex: from 'Wallet Neo PVC Beige' and 'Wallet Neo Nylon Black' i need 'Wallet Neo' I've been busting my brains, but... maybe I can't think right because of the pressure... Thanks ...more >>

Hi I've never really had the requirement to use but with testing I've found that sometimes this command can be used to improve performance. I've inhereted a system where the developer used this on a table with 250k rows. The process that use this table only runs once a month in the quie...more >>

Hi I'm currently using Sql Server management studio and Team Foundation server as the source control system. I have a database solution which multiple scripts (DDL, stored procedures etc) Developers are allowed to create tables, sprocs etc in the development environment, but when moving...more >>

select MunicipalityID, DHGridID, DHCompanyID, count (*) as Antal from EnergySUpply where not DHGridID is null group by MunicipalityID, DHGridID, DHCompanyID order by DHGridID, DHCompanyID may return more than one record per DHCompanyID. If that is the case I only want the one with the highe...more >>

Can I declare a cursor in a scalar-valued function? Thanks ...more >>

Hi all, How can I get programatically the tables on which my sql view depends ?? Now I'm using .NET Framework 2.0 and Sql.Dmo to get the CREATE VIEW ... script (using SqlDmo.View.Script), but I need to get the table names, too, to create tables first. Thanks for any advice ...more >>

in sql table there is column "createdtime" (Int, Not Null) values like 86205 12712 how to convert this int by the simpliest way this to time like 11:05 - for example 12:30 Thanks Peter -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-...more >>

Hi, I'm stuck with a update query and need some help. I'm using OPENQUERY to select data from a linked server to update a tabel on the local server, but can't seem to get it right, Tried something like this: -------------------------------------------------------------------- set @sql= 'S...more >>

I tried to run stored proc which has mutiple linked servers. When I tried to run, I got the error message like below. Server 'sqlken' is not configured for RPC anybody has an idea why I got this and how to fix? Thanks ...more >>