Search results for query: *

hello. i mispelled a same word in more than 20 stored procedures and i cant figure it out wich of them has it to correct them. is there a possibility to find this word in all sp at once? thanks in advance. jonas

ah ok i got it! Thanks

thanks denis for your replay. but the updated stored procedures are in my notebook.. which i want to updated on my server. (i have a copy of the database in my notebook where i use to work on my programs)

hello. I was updating many stored procedures on my notebook. Now i need to restore to the server database but i cant find the way to restore automatically only the stored procedures to the exising database. Could someone help me? thanks in advance.

hello, I imported a table to sql server which it hasnt identity field. I created a field now but how can I give the correlative numbers at once in Stored Procedure to all the records? thank in advance. For example -> name last_name Cnt price total John Smith 1 10 Sarah...

hello, is there any program which can help me to take control over other workstations such as preventing installing new programs or locking system configurations, etc. thanks in advance

Hello! Is there a sql to do like this using one table and all this months columns in one row? TABLE structure: Client_id --- Date ---- TOTAL 150 --- 01/JAN/2005 ---- 10$ 150 --- 05/JAN/2005 ---- 5$ (15$ in JANUARY for Client_id 150)...

The day column is a datetime field. 01-08-2005 10:00:00 (august 1rst)

Sorry I meant ordering but also is grouping because in total field it needs to be sumarize for example Incomes for August: Day - Total 1 - 100$ <- sum of invoices on day 1 2 - 0 $ 3 - 120 $

hello I need to list records grouping by day but also the ones wich day didnt have movement. For example: August: day - Total 1 - 5000 2 - 0 3 - 2000 4 - 0 until 31 Thanks in advace!

Hello. I would like to select records that are not include on a table. For example, a Client ID that is not included on an invoice table, etc. Can I use Count function? Thanks in advace.

Hello.. How can I use a select statement to get this result: (for example for month August) day - ticket number - Total Amount 1 - 1 (to) 30 - 329.50 2 - 31 (to) 52 - 409.50 3 - 53 (to) 64 - 59.50 4 - 65 (to) 75 - 829.50 etc till day 31 all in one row per...