Comments by saad88 - CodeProject

saad88 17-Apr-15 14:56pm View

I am using SQL2005 , thats my problem , i have used this
update [dbo].[ss_MCB_master]
set expiry = CONVERT(VARCHAR(11), cast([Offer Expiry Date] as datetime), 106) AS [DD MON YYYY]
where Lang_code = 'F'
this works for select but not working on update , i know its giving me in english but i can make table and change it for french , because i have 2005 version , any help , and sorry basically its internal so i have to update database , please any help now

saad88 2-Apr-15 10:18am View

so columns are email,address,cell,type,version .... so i have to add version column by my self ..... so any rough code idea would be much appriciated , the scope of project is to take invalid data out and insert few things in , i have Pentaho ETL but i am looking for stored procedure

saad88 20-Feb-15 11:00am View

Hi MIka

Still taking a lot of time .... last query was taking over 5 hours ..., and this new one is running from over 4 hours .... i don`t know .... what to do

saad88 19-Feb-15 16:30pm View

hi mika

its giving me error on e before inner join

from ReportingAcxiom)
) e
INNER JOIN ReportingAcxiom ON e.campaign = ReportingAcxiom.campaign

any suggestion

saad88 19-Feb-15 12:35pm View

or should i do it like i have done it for reportingAcxion , at the start of the query
and write drop statements at the ends

saad88 19-Feb-15 12:33pm View

Hi Mika

i have non clustered index on campaign in master table .... also i know its stupid to ask but can u please incorporate these in query i wrote above , i just made it but not working .... or can u mention where i need them in query , i know i can create them all at same time ..... but can i use like create index and then drop after i finish .... what u say

saad88 17-Feb-15 13:09pm View

thanks a lot tomas for solution ... really appreciate

saad88 17-Feb-15 11:20am View

hi john that`s the problem .... i was a developer now i got extra responcibility of QA for sql quries ... i dont have any indexes o tables or views .... only some default generated by SQL clustered indexes ... so before creating non clustered indexes i wantto take experts opinion

saad88 17-Feb-15 10:28am View

Hi john ... i have seen the execution plan and its showing around 35 and 36 % cost on clustered indexes on views ... i have the plan .... sorry to ask but could you tell me how to show plan on code project on this page

saad88 17-Feb-15 10:09am View

hi tomas , the opentime is datetime fields .... i am using these format because i have date and time as yyyy-mm-dd 00:00:0000 and i only want to report as dd-mm-yyyy and no time

saad88 5-Feb-15 16:51pm View

Thanks Ryan ... i appreciate....thats enough help

saad88 5-Feb-15 16:35pm View

Hi ryan .... thanks ..... i have never checked execution plan .... can u just tell me how to get it in ssms 2012 ... do i have to do it on this query

saad88 5-Feb-15 16:34pm View

Thanks .... can you give me a general query idea or code for CTE for this senario .... anyhelp would be much appriciated

Comments by saad88 (Top 13 by date)