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
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.