sql - Convert DateTIme to Date / "int is not allowed" error -

-

I searched and searched - have found variations on the theme, but there is no real answer to my problem.

I need to convert MAX from datetime to date , and put it in a new table I created .

Here is my code: 

  INSERT INTO [dbo]. [OPTITE EMails] ([email address], [first optode], [LastAutOutDate], [BOID], [brand_ID]) SELECT [[email_add]. [email_add], [dbo]. [email_add], [dbo]. [Email_add]. [Brand_ID], convert (date-time, max [[first optot date]) [FirstOptAutadet, Convert (Datetime, Max ([E-MailAddance_Samuri]] [LastOutOutDate]) from AS LastOutOut Date [DBO]. [Distinct Email address] [dbo]. [Email address = samurai] on [dbo]. [Distant email id]. [Email adrecise] = [dbo]. [Email address_samuri]. [Email adressed] WHEEE [DBO]. [E-mail Address_samuri]. [Lasta Tetradit] is not [dbo] by the null group. [Specific EM .. AilIds] [emailaddressid], [dbo] [emailaddresses_summary] [bu_id], [dbo] [emailaddresses_summary] [brand_id] ... GO  < / Pre> 
 It needs to go into this table:  
  [emailaddressid] int no null primary key, [first optod date] daytime tap, [finalopactdate] daytime False, error message that I get: message 257, level 16, state3, line 56  
 
 [buddyid] at null, [brand_id] ent null   < P> Data type to fulfillment Built-in conversion is not allowed for numbers. Use the CONVERT function to run this query.   
 Whatever I can think of, I have tried. My code resulted in the  CONVERT  statement string that I thought would solve it. Anything is not working please help?   
 
 
 You are getting an error because you have found the column order incorrect; The columns given in the accompany statement do not match the order in the selection statement:  
  INSERT INTO [dbo]. [Email address] [email address] [email address] [[email address]] [email id] [email address] [e-mail address] [dbo]. [Email address_samuri] [BOID]. [Db.o.]. [Email address_samuri]. [Brand_id], convert (dateaddime, max [[first optot date]), as the first optooddate, convert (datetime, max ([emailaddresses_summary]. [Lastopupoutdate] ) AS LastOptOutDate   
 You want it to:  [e-mail add Reset] [DBO] as email [opt-eTemail] ([e-mail address], [first address], [FirstApotAutDate], [LastAutOutDate], [BOID], [Brand_ID]) SELECT [DBO]., Convert (DataTime, Max ([Email address dot]] [firstopotautdate]) AS FirstOptoutDate, Convert (Datetime, Max ([E-MailAdWordsSamuri]. [LastOutOutDate]) AS LastOptoutDate, [DBO]. [Email AddressSamuri]. [BOID], [Dbo]. [Emailaddresses_summary]. [Brand_id]   
 With that, you have a total The Olm might want to change the  
 , MAX (convert (datetime, [emailaddresses_summary]]. AS FirstOptOutDate, MAX (convert (datetime, [emailaddresses_summary]. [LastOutOutDate]) AS LastOptOutDate   
 Because the intent is better, and the maximum consolidated function at the same time Applies to changed date time column before (can varchar?)

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: < P> Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i
Read more

java - Why my included JSP file won't get processed correctly? -

-
I am trying to create Java web framework (and learning), and on the basis of 'Code Generator In the process of making the material view of the database in the process of development, I stumbled into a difficulty, which I do not know how to solve it. First of all, I want the following index.jsp : & lt; Body & gt; Use all pages to be created. & Lt;% @ include file = "header.jsp"% & gt; & Lt; Hours / & gt; & Lt;% @ included file = "body.jsp"%> & Lt; Hours / & gt; & Lt;% @ include file = "footer.jsp"% & gt; & Lt; / Body & gt; And, in body.jsp , I should have it like this: & lt; Jsp: include page = "$ {Application_modul}"%> Where application_modul is an attribute defined in its controller: request.setAttribute ("application_modul", "USER_ACCOUNT \\ ' View_user_account.jsp "); This file can be found properly, but the processed JSP does
Read more