////////////////////// Table Name ='sysatt' Column Name ='DtAtt' ///////////////////// select DtAtt FROM sysatt WHERE DtAtt BETWEEN '2007-01-01' AND '2007-04-17' AND DATENAME(Dw,DtAtt)='Sunday'

vivek

I want to mask the text for identifying the corrent syntax of IP address example 10.179.10.28 // is correct 10.567.7889.7. // is incorrect how to identify the incorrect one.

vivek

SELECT MASTER.EMP_CODE,MASTER.EMP_NAME,ADVANCE.ADV_AMT, LOAN.LOAN FROM MASTER ,ADVANCE,LOAN WHERE MASTER.EMP_CODE=ADVANCE.EMP_CODE AND MASTER.EMP_CODE=LOAN.EMP_CODE AND LOAN.AVAILED='Y'

vivek

ON button click. -- 1. First make the object of the report (say AA.rpt) Dim obj As New AA -- 2. Pass the database (userid,pwd, server, Database name) obj.SetDatabaseLogon("sa", "sa", "10.179.10.38", "PUBS") -- 3. Use the object of crystal report viewer. crViewer.ReportSource = obj crViewer.Visible = True

vivek

hi, you can easily develop reports using the wizard which comes as you start crystal reports (i.e. using the report expert ).It ask .. 1.type of expert (choose standard here ) 2.database (select your database from the window) 3.links , columns etc. go on as per your requirement and step asked. still if problem persist do post the problem . vivek if each mistake is new one then U R making progress.

vivek

hi, try this out ... I am giving you the code to fragment the column field as you have described. Try the code with diffrent strings like '1.1.1.1' ,'1.891.91.21' etc. I am taking '1000.087.1567.7956' as example. <-----------------------------------> DECLARE @vStr AS VARCHAR(100); SET @vStr='1000.087.1567.7956' --first no. SELECT SUBSTRING(@vStr,1,CHARINDEX('.', @vStr) - 1)as A --second no. SELECT SUBSTRING(@vStr, CHARINDEX('.', @vStr)+1 ,CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )-(CHARINDEX('.', @vStr)+1)) as B --third no. SELECT SUBSTRING(@vStr,CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )+1 ,CHARINDEX('.',@vStr,CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )+1)- (CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )+1)) as C --fourth no. SELECT SUBSTRING(@vStr,CHARINDEX('.',@vStr,CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )+1)+1,LEN(@vStr)+1-(CHARINDEX('.',@vStr,CHARINDEX('.',@vStr,CHARINDEX('.', @vStr)+1 )+1)+1)) as D <--------------------------------> kindly do feel free to ask if you have doubt about it..... vivek delhi vivek

hi all, I am copying a table to another table using select * into targettable from sourcetable . The new table named "targettable" is created but the primary key (constraints) and default values for the table are not coming as "sourcetable". Is there any way to have a table copy with the same table structure and design??????. vivek

yes my dear, ..... Name of the file ts_pick.js The code: // Title: Timestamp picker // Description: See the demo at url // Version: 1.0 // Date: 2001-05-12 (yyyy-mm-dd) // Notes: Permission given to use this script in any kind of applications if // header lines are left unchanged. Feel free to contact the author // for feature requests and/or donations function show_calendar(str_target, str_datetime) { var arr_months = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; var mons=["JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]; var week_days = ["Su", "Mo", "Tu", "We", "Th", "Fr", "Sa"]; var n_weekstart = 1; // day week starts from (normally 0 or 1) var dt_datetime = (str_datetime == null || str_datetime =="" ? new Date() : str2dt(str_datetime)); var dt_prev_month = new Date(dt_datetime); dt_prev_month.setMonth(dt_datetime.getMonth()-1); var dt_next_month = new Date(dt_datetime); dt_next_month.setMonth(dt_datetime.getMonth()+1); var dt_firstday = new Date(dt_datetime); dt_firstday.setDate(1); dt_firstday.setDate(1-(7+dt_firstday.getDay()-n_weekstart)%7); var dt_lastday = new Date(dt_next_month); dt_lastday.setDate(0); // html generation (feel free to tune it for your particular application) // print calendar header var str_buffer = new String ( "\n"+ "\n"+ " Calendar\n"+ "\n"+ "\n"+ "\n"+ "

\n"+ "\n"+ "\n \n"+ "

"); str_buffer=str_buffer+(""); for(inc=0;inc"+arr_months[inc]); else str_buffer=str_buffer+(""+arr_months[inc]); } str_buffer=str_buffer+(""); str_buffer=str_buffer+new String("

"); str_buffer=str_buffer+("

hi, obviously yessssss.............. vivek 9868079257 delhi vivek

It is too simple.. try this out... --> convert(char,getdate(),101) <--function .... vivek

hello, try out .. one of these.. 1. sp_columns tablename 2. select name from syscolumns where id = object_id('tablename') vivek

try this out ... i.e. insert into chk values('notwking',convert(char,getdate(),105) the time part will be removed. vivek

Begin tran update statement..... ..... rollback tran vivek

Reply to me if solution is helpful to you. In Sqlserver 2000 1. Goto the menu click "query" tab. 2. select "Results to file " option. 3. Execute the query F5. 4. It will prompt the window to save the file .Save the file as ".html" extension. 5. Your requirement is fullfilled.(note -->The result is not in order/linear in order). vivek

It is too simple .... vivek

what the meaning of QUOTED_IDENTIFIER ,ANSI_NULLS in this view(sqlserver 2000) SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO - -select *......... -- - GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO vivek

why " setcount on" is used in stored procedures ? what does it actually means ? vivek

well if you are able to make a simple html 0r dhtml pages and link them.You are having the code. for making a website following things must be done on your machine. 1. Install IIS. 2. right click at "my computer" go to manage section. 3. then click on "services and applications" and then right click on "IIS services". 4. You are having a option for making the "website". 5. now follow the instructions. vivek

hi, Can anyone help me in -> how to search a word or text in a web page ? . I using ASP & Sql Sever 2000. vivek

I need a php code OR ASP which sends the subject,body and attachment of email to the local intranet configured lotus notes 6. vivek -- modified at 4:55 Monday 6th February, 2006