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: 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

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
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