This has me a little stumped... this is not the real database situation, just a paraphrased version that should produce the results in an example I can then use to make my actual query. I need to get a recordset for each store of all the hours and sales broken down by employee... Employees ...more >>

hi, I am not able to use today date by using getdate() in UDF. Is there anyway to work around? Thanks Ed...more >>

If the update trigger returns an "inserted" table with multiple records, is there any way to address each record individually without using a cursor? The code below is my solution using a cursor but the DBA says no cursors. Thank you for your help. /* Assume "inserted" table returned mult...more >>

Hi, is it possible to return a list of all tables in a procedure? sp_findtables_from_procedure @proc='procedure1' I'm not sure if it can be done. ...more >>

Hi All I have to copy text data from a table in one database to a table in a different database, both table reside on the same server. I tried two options which didn't work (see code below), and will be more than gratefull for any help. Thanks Elie Grouchko ***********************...more >>

Heres my query select database_name,backup_finish_date from msdb..backupset where type = 'D' order by backup_finish_date desc Apparently i want to just get a distinct database_name only So current results when i run that query give me DB1 2005-03-05 00:02:54.000 DB2 2005-03-05 0...more >>

hi All in my database The log File Is to Big How can i Trancate or deleted Pelase Help me use SQL2000 ...more >>

Hi, I have an app that does case-insensitive, accent-insensitive searches using sql server fulltext engine. It deals only with western-european lanaguages (mostly just English and French). The tables are stored in Latin1 General CP1. However, I also need to process the search results in ...more >>

dear all i need to execute a stored procedure in sql server from another stored procedure. this mean that my application calls a stored procedure but i need when i call this stored proceure to run an other one. is that possible and can anybody help me to acheive this task?? Thank you. ...more >>

I have SQL Server2000 installed on dedicated server. One only application which send sql queries to the server is application server - users can not connect directly to SQL Server. Most of times transaction run near average time - around 30 ms. Minimal time I have seen is 20 ms for transaction...more >>

Hello experts, I have a sproc that gets several params, default is null. I'd like to build a WHERE clause on the fly for just the params with values. Something like SELECT * from foo WHERE if( @a IS NOT NULL foo.a = @a) and if( @b IS NOT NULL foo.b = @b) ...more >>

Hi All, I have many scheduled jobs running that creates a centralized database from 20 different databases in 20 different locations. The jobs say they were successful, but the information is not coming over all the time. If I manually run the job in EM, it works fine. Some of the jobs cal...more >>

How can I manage the errors into a stored procedure? Example: CREATE PROCEDURE MyProcedure @UserName SYSNAME = NULL AS BEGIN DECLARE @v INT SET @v = 0 EXEC @v = sp_helpuser @UserName IF (@@ERROR <> 0) BEGIN RAISERROR('My Error Message...', 16, 1) R...more >>