Viewing 15 posts - 61 through 75 (of 161 total)
To All thank you much, it is straight table so I am looking to make it small statement rather than this big query for what I am doing now
April 17, 2018 at 12:28 pm
Correct Steve.
Or let say my table #MyTemp has two additional columns 1 is ConductedTotal, PassedTotal these two columns need to populate using the above rules ..
April 16, 2018 at 4:08 pm
Hi Alan
Thank you for your input is there any why can we correct the order of fields
when I see the out put in preview mode in...
April 9, 2018 at 3:09 pm
I used left join t find out only SSN. but not sure how to do for emails any idea? or query? please advise
March 23, 2018 at 9:13 am
Hi There thank you for your answer,
my file initial rows has data some titles and some summary information which i don't need to load to sql table,
August 24, 2017 at 9:58 am
Hello there can somebody please give suggestions.
Thank you
July 16, 2017 at 9:16 pm
Can any one please help me
June 6, 2016 at 8:25 pm
Thank you friend
I tried below (it may helpful to otherS)
SELECT *,
CASE WHEN LEFT(REPLACE(REPLACE(REPLACE(REPLACE(LEFT(phno,7),')',''),'(',''),' ',''),'-','')+REPLACE(REPLACE(RIGHT(phno,LEN(phno)-7),' ',''),'-',''),1) = '1' THEN STUFF(STUFF(STUFF(REPLACE(REPLACE(REPLACE(REPLACE(LEFT(phno,7),')',''),'(',''),' ',''),'-','')+REPLACE(REPLACE(RIGHT(phno,LEN(phno)-7),' ',''),'-',''),5,0,'.'),9,0,'.'),2,0,'.')
ELSE STUFF(STUFF(REPLACE(REPLACE(REPLACE(REPLACE(LEFT(phno,7),')',''),'(',''),' ',''),'-','')+REPLACE(REPLACE(RIGHT(phno,LEN(phno)-7),' ',''),'-',''),4,0,'.'),8,0,'.')
END
FROM #myphone
but...
May 19, 2016 at 9:12 pm
Thank you for your input
I tried that but some how I am able to achievement mid level
it is ok if we can do it in steps wise (like we do...
May 19, 2016 at 6:14 pm
Excellent old hank
it is worked great
Thank you all for your suppoet
January 25, 2016 at 9:56 am
Raj, Thank you
as I mentioned I have same kind of sql statements 10 simple update I gave 3 above,
so I am checking one update statement rather than 10 update...
January 25, 2016 at 7:30 am
Actually checking myself one thing ,
also the second one is, I have this kind of individual queries 10, I just put 3 here, so would like to do...
January 24, 2016 at 10:00 pm
Thank you much for sharing it SQLRNNR
but I don't have rights to execute it but to gain knowledge purpose I should check on it
Thank you Again
January 13, 2016 at 9:30 pm
Hello spaghettidba Thank you much for your help
1) I tried it, it gives me null for storeprocedures column and NumberOfRows column for all rows
2) also for lastupdatedate gives user has...
January 13, 2016 at 9:27 pm
Viewing 15 posts - 61 through 75 (of 161 total)