Search results for query: *

Dear All, I have customer table with datecreated and emailid field. I need to select all customer records exactly created 365 days before(last year same day) by comapring their email id with last 45 days sales records to find the customer those who not renewed their policy within last 45 days...

Dear All, I need to filter traveller by age. How to filter this for eg: Traveller (column) Mrs.Dolo Jaku, 72; Mr.Jame Jaku, 65; Mr.Kate blitz, 22; Ms.sheva dove, 36; Mr.James don, 22; Ms.Fleming don, 36; Mr.James Jaku, 65 Result Mrs.Dolo Jaku, 72; Mr.Jame Jaku, 65; I need to filter all...

Dear All, we have 2 db and i try to retrview yesterdays records from both db,i used where cst.DateCreated >=DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,0)AND cst.DateCreated <DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) In one DB its pull exactly yesterday record and in another DB it pulls day before...

Dear All, I scheduled a daily report using SSRS and it is now stored in local server.But i need to automate and send this file to another server using SFTP.How to do this.Any help regarding this is highly appreciated. Many Thanks. Regards, SG

Dear All, I have a to select all rows from cst table.In this table we have two cstid for each customer But the corresponding 'price' field shows different price.I want to select all the rows, which has less price than another one. For ex: CStid Price 1000 14.98 1000 7.53 2000 83.57 2000...

Dear All, I need to reterview data between the time range ie.Yesterday 1 Am to today 1 Am record (24hrs) The below query pulls the data between (2011-07-04 00:00:00.000 to 2011-07-04 23:59:59.999) cst.DateCreated >=DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,0) AND cs.DateCreated...

Hi Markors, Logic:- I have a 'calculation' coulmn(datatype:test) in pr_cal table.In this coulmn a big string is stored. for eg: Begin Calculationis <br />\n<br simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard galley Total Price including...

Thanks for your reply markros I try to execute the script, it returns the whole string as it is.Its not extracting the integer value.Please let me know how to amend the query further. Reagrds, SG

Dear all, Declare @key varchar(100) Set @key = 'Total Price including Commission at This Level: ' Select SUBSTRING(calculation,start,finish-start) From ( Select calculation, start = charindex(@key,calculation,1)+LEN(@key)+1, finish = charindex('...

Dear All, I have a 'calculation' coulmn(datatype:test) in pr_cal table.In this coulmn a big string is stored. for eg: Begin Calculationis <br />\n<br simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard galley Total Price including Commission...

Hi all, EXEC msdb.dbo.sp_send_dbmail @recipients='sg@domainname.com', @body='Message Body', @subject ='Message Subject', @profile_name ='test', @query ='select top 10 * from [databasename].dbo.cst ', @attach_query_result_as_file = 1, @query_attachment_filename ='Results.csv' This query is...

Hi All, I need to send the query result in mail.I Succeffuly configured the database mail setup and received the test mail. But If i execute the below query :- EXEC msdb.dbo.sp_send_dbmail @recipients=sg@domainname.com', @body='Message Body', @subject ='Message Subject', @profile_name...

Thanks for ur greeting and for ur reply Djj. Yes, i want to do this in T-SQL.I am using SQL Server 2008 R2. and i want to store the result in particular folder.So how to set 'dynamic generate file name' for the result.Thanks in advance..

Hi all I have a set of query and i need to automatate that in regular intervals to avoid manual work.I need to do the below tasks.Any help would be highly appreciated. 1.Need to run automatically and store the query result in particular folder? 2.Need to send an email if there is an...