I have a table of various integers How can I select the first ocurrance of a consecutive grouping of x integers? example, if the table contains 1, 3, 4, 7, 8, 9, 11, 22, 333 mystp (3) would return 7 because 7,8,9 is the first consecutive 3 numbers mystp (2) would return 3 because 3,4...more >>

Procedure Long Running SP_OACreate Hi, WE have a procedure which uses sp_OAcreate to use COM objects The problem is this procedure is long running, When I reboot the server the procedure is finishing within few minutes I have increased the SQL memory from Min: 832 MB max: 1792 MB to Mi...more >>

Hi, i am writing some queries for a payroll section of a database. An employee has a field in their table which states their StandardWorkingHours, typically 8 hours per day. I also have a second table called HoursWorked, and consists of the following fields: EmployeeID_FK HoursWorked Date...more >>

hi i connect via ODBC with a login under certain "schema_x" if i try to execute a stored proc "myProc" if "schema_x.myProc" don't exists i believe sql server then should try with "dbo.myProc" but it is not working it seems sql always try to map to "dbo.myProc" without trying to map "sche...more >>

I have read in a couple books about these 2 things.. and i have yet to actually find them within our SQL2005 server... We have a few queries we would like to view the execution plan to see the estimated time it will take to process... and We woudl like to check out the query analyzer th...more >>

I've got two DTSX packages in one project. When I make one the one showing in the main screen, then hit the run button, it runs the other one. Every time. How do I make it run the one I want? Are there any good books on how SSIS stores its files, or what the hell it does when you try t...more >>

Is there a system function that can tell if a given year is a leap year? Thanks. David ...more >>

Hi All, With help from this newsgroup I got the sql query shown below to return rows as column. Now, I need to make a minor modification to the sql query to NOT return rows with NULL value when no data was found for MimeDate and/or MimeSubject, and/or MimeMessageID. When I added a WHERE ...more >>

I was just reading the following from MS regarding performance: http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx In this link MS recommends the following: "The number of data files within a single filegroup should equal to the number of CPU cores." What is the reas...more >>

I have field in my data base datetime data type fields they have this information 2004-06-09 11:37:25.483 I want to write a T-SQL sentence but i need to get as a result just the date part with out the time. It 's possible, can you help me? ...more >>

I need to be able to detect the difference between '3020' and '3020 ' in a select statement WHERE clause. I have tried "CONTAINS" but get the error 'Cannot use a CONTAINS or FREETEXT predicate on table 'SalesOrder' because it is not full-text indexed.' I do not have the ability to change the...more >>

I am making an ASP webpage that requires user authentication to Active Directory. I would like to make it so that only certain users can run select queries on only certain tables and only certain users can run update queries on certain tables and so on. Is it possible to specify these permiss...more >>

Hi Guys 6 months ago my predecessor (no longer working for us) upgraded a live database from SQL2000 to SQL2005 without any planning; after a week of sheer panic, we got it working without collapsing, but there is a marked difference in performance between the application running on SQL2000...more >>

Is there any way to get applicationname with a SELECT, I'm talking about the param (APP=name_of_application) that you can provide in connectionstring when connecting to SQL server. I have seen this name on "Process Info" tab in Enterprise Manager... reg. Kjell Brandes...more >>

Command being sent: exec SiteProdRatesCalc 'RTS', 'EUR', 'Aug 9 2007 12:00:00:000AM', NULL, 140, NULL, 76 Results: Server: Msg 8624, Level 16, State 1, Procedure SiteProdRatesCalc, Line 890 Internal SQL Server error. DELETING ANY SITEPRODUCTRATES ENTERED TODAY FOR FC, OT, NT BY SITE GROUP...more >>

Hi guys, I have two tables, let me say Table1 , Table2 both table have a field "Table_code" I need a query to retrieve the Table_codes from Table2 which Table_codes are not present in Table1. Please help me. ...more >>

Is there a way to reset the @@DBTS value? I realise there may be some "Why do you want to do that ?" answers - we're working on that one. Thanks...more >>

Hi. It´s possible to install the SQL-DMO for SQL Server 2005 in a machine with Windows 98 SE? My problem is when I try to register the "sqldmo.dll" for SQL Server 2005 I allways get the error LoadLibrary("C:\Programas\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll")failed. GetLastError retur...more >>

I have the following Batch file:- rem script to create Basic Structure del output.log CALL :load "Database.sql" %1 %2 CALL :load "tables.sql" %1 %2 CALL :load "PK and FK.sql" %1 %2 GOTO :end :load echo FILE: %1 echo. >> output.log echo FILE: %1 >> output.log osql -S %2 -E -d %3 -...more >>

/* Hey guys. It is waaayy too late and I am just missing something here. A query that works if I use a temp table throws an error if I write it using a derived table. Hopefully someone can quickly spot whatever the heck I am missing. Thanks in advance!! Oh, and don't even get me started ...more >>

Hi there, how do I debug a stored procedure in SQL 2005? ...more >>

Hi, the following query: USE MYDB DECLARE @Constant_IP INTEGER DECLARE @Constant_Image INTEGER SET @Constant_IP = dbo.Constant ( 'ip') SET @Constant_Image = dbo.Constant ( 'image' ) SELECT Adjacency1.ID, (SELECT TOP 1 Condition FROM ...more >>

Hello there Is there a simple way to reset identity Starting point and Increment for entire database? Instead of creating huge script with alter table for that ...more >>

I was told there is a hotfix available from Microsoft to 'enable' the @@identity function in SQL Server 2005. Could someone here confirm / deny? Cheers ...more >>

In our system users can create custom reports. Before they run the report I like to run an EXISTS check to see if any data will be returned and if nothing is found I display a message box instead of running a blank report. The query I am doing is this... IF EXISTS (SELECT * FROM vwAgentSt...more >>

I am building a web application (.NET) with E-Commerce functionality. One piece of data that we have to store is social security number, and credit card number for the shopping customer. This is literally the only data that requires encryption, and being doubly defended throgh firewalls, an...more >>