Search results for query: *

Hi, This is before i read the link you sent SQLSister and before i tested the code you sent me Denis. I dislike the use of Dynamic SQL in my code but i always do it when there is a parameter involove in my query. I gave a glimpse at your code Denis and maybe i can use it instead. In that case...

I made a mistake. This is "Statusecond" not "myFunction" sorry.

Hi Denis I'd like to build a table, based on another table. My table's columns should display months (24 months for 2006-7). Ther are 4 rows for various states of a customer. I'd like for each value to insert: INSERT INTO myTable (row-col) SELECT myFunction(status,date) which is: /*EXEC...

Hi everyone, I have a procedure within whice i execute a function as follows:SELECT 'bbb', DBO.statusecond ('%aaa%', '20070801') COMMIT and a function that runs dynamic sqlexec(@dynamic). When it comes to running that dynamic sql i get the following error message: . Why is that ? Must i...

Thanks a lot Borislav ! Glad you're here again to help.

Hi everyone, I try to form a dynamic-sql command where an "int" param is involved and i dont know how to do it. My code is: /*EXEC statusecond 'aaa', '20070801'*/ ALTER PROCEDURE statusecond @stat_param VARCHAR(50), @date_param SMALLDATETIME AS BEGIN TRANSACTION DECLARE @year_stat INT SET...

Thanks a lot Chris. Thank you Greg for the links.

Hi 25061959 Thanks for trying to help. I finally found the source of my problem and it lays in the sort of "layout". Somehow, for a reason i dont know, the: view became "web layout". When it is on "normal" or "print layout" everything works fine. When it is on "Web layout" all i described happens.

Hi everyone, I want to load an image. At the "select image source" the "relative to" box, i'm required to choose either"document" or "site root" and i dont understand the implication of each selection. Can anyone explain me that ? Thanks

Hi everyone, I'm accustomed to add page numbers to my "Word" documents. I tried to add "page numbers" from "Insert" menu item + "page number" but the "page number" menu item is dimmed and i cant do that. I use to make a "new page entry" pressing "shift+enter" keys but it is not working. I have a...

Thanks a lot George !

Hi everyone In order to free disk space i need to identify tables and databases on the disk. Can i know a table's size (in bytes, not rows !) and database's size through system files in the SQL SERVER ? Any other resource to learn about my databases size ? Can anyone tell me what is the...

Thanks a lot !

a number showing the position of a certain character. Hi everyone, In my select query i want to display the position of the character '-'. My query goes like: select position(phone,'-') to show where the '-' of each phone number i situated. can anyone tell me what i should replace with ? Thanks...

Hi everyone, My question is as simple as that: I want to add a new user for a particular database. That user should be working freely on that particular database (createing db, editing tables, removing tables) but he shouldn't have access to any other database and shouldn't have maste's...

Thanks a lot Denis

Hi klewis 10367, Thanks, I ran the code as you suggested CREATE TABLE ##texttab (c1 text) INSERT ##texttab values ('Put your long message here.') DECLARE @cmd varchar(56) DECLARE @recipients varchar(20) SET @cmd = 'SELECT c1 FROM ##texttab' EXEC master.dbo.xp_sendmail @recipients='robertk'...

Hi everyone, i run the following code (xp_sendmail)CREATE TABLE ##texttab (c1 text) INSERT ##texttab values ('Put your long message here.') DECLARE @cmd varchar(56) SET @cmd = 'SELECT c1 FROM ##texttab' EXEC master.dbo.xp_sendmail 'robertk', @query = @cmd, @no_header= 'TRUE' DROP TABLE...

Thanks

Hi Glasgow, No i didnt try in the first place but having tried after reading your last notification i see "new horizons". I'll have to spend some time learning that matter but at this moment i'm very gratefull to you.